Data Management Week 1 Assignment Joyce Harshada

docx

School

Wilmington University *

*We aren’t endorsed by this school

Course

IST-7000

Subject

Industrial Engineering

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by CommodoreMink1912

Week 1-Assignment Customers And Car Hire Project Data Management Joyce Harshada Muthyala IST 7000 College of Technology, Wilmington University July 18, 2023

Please evaluate the conceptual data model displayed below before responding to the following two questions, referencing any website URLs you may choose to in your responses. 1)Describe each of the following elements of the data model in your own words. a. Entities b. Attributes c. Relationships d. Primary keys 2) List all the elements that make up the data model. a. All the entities b. All the attributes for each entity c. All the relationships between entities (e.g., one Manufacturer has Zero-to-Many Models) d. All of the primary keys

e. One or more business rules about the data. For instance, although a child has two parents, data for only one parent may be stored in the database. 1)Describe each of the following elements of the data model in your own words. a. Entities b. Attributes c. Relationships d. Primary keys a. Entities: In a relational database, an entity is any thing that may have data collected and saved about it, be it an object, location, person, or other thing. b. Attributes: The traits or possessions of an entity are its attributes. c. Relationships: The links between different relational database tables are known as relationships. d. Primary keys: The field that uniquely identifies a record in the database is known as the primary key. 2) Identify all of the components in the data model: a. All the entities

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

b. All the attributes for each entity c. All the relationships between entities (e.g., one Manufacturer has Zero-to-Many Models) d. All of the primary keys e. One or more business rules about the data. For instance, although a child has two parents, data for only one parent may be stored in the database. a. All the entities Manufacture Customer Model Vehicle Vehicle Category Booking Booking Status b. All the attributes for each entity Manufacture : manufacturer_code (Primary Key) , manufacturer_name, manufacturer_details Customer : Customer_id (Primary Key) , customer_name, customer_details, gender, email_address, phone_number1, address_line_1, address_line_2, address_line_3, town, county, country Model: model_code (Primary Key) , daily_hire_rate, model_name Vehicle: reg_number (Primary Key) , current_mileage, daily_hire_rate, date_mot_due, engine_size

Vehicle Category: vehicle_category_code (Primary Key) , vehicle_category_description Booking: Booking_id (Primary Key) , date_from, date_to, confirmation_letter_Sent_yn, payment)received_yn Booking Status: Booking_status_code (Primary Key) , booking_status_description c. All the relationships between entities (e.g., one Manufacturer has Zero-to-Many Models) Manufacturer – Model One to Many relationships Model – Vehicle One to Many relationships Vehicle – Vehicle Category Many to One relationship Vehicle – Booking One to Many relationships Customer – Booking One to Many relationships Booking – Booking Status Many to One relationship d. All of the primary keys manufacturer_code, Customer_id, model_code, reg_number, vehicle_category_code, Booking_id, Booking_status_code e. Business rules There should only be one customer per booking. If the booking status is not equivalent to hired, the vehicle may be assigned to the customer.

Data Management Week 1 Assignment Joyce Harshada

Related Documents