Garage Database Design (Part 1) — E/R diagram Instructions …
Garage Database Design (Part 1) — E/R diagram Instructions You’re designing a database concerning a local garage. Fill in the blanks based on the E/R diagram for this database. To help visualize the structure, draw the E/R diagram on scratch paper. Entities Involved customer, vehicle, job, part Given Information For each customer, we want to record the (unique) name, address, and contact phone number. For each vehicle, we want to record the unique vehicle’s identification number (VIN), and the vehicle’s make, model and year. For each repair job, we want to record the description of the job done (maximum 200 chars), the date, and the total dollar cost. A repair job may involve zero or more parts (like, e.g., battery, windshield wipers). For each part we want to record the unique part number, the part name and it’s cost. Additional Information Each vehicle have one or more repair jobs. Each customer can be primary owner of one or more vehicles. Every vehicle has only one primary owner. Each vehicle can have no more than one repair job in any given day. Fill in the Blanks Entity customer has attributes [customer_attr1]. has a [customer_rel_type1] relationship [customer_rel1] to [customer_str1] entity [customer_ent1]. Entity vehicle has attributes [vehicle_attr1]. has a [vehicle_rel_type1] relationship [vehicle_rel1] to [vehicle_str1] entity [vehicle_ent1]. has a [vehicle_rel_type2] relationship [vehicle_rel2] to weak entity [vehicle_ent2]. Entity job has attributes [job_attr1]. has a [job_rel_type1] relationship [job_rel1] to [job_str1] entity [job_ent1]. has a many-to-many relationship [job_rel2] to [job_str2] entity [job_ent2]. Entity part has attributes [part_attr1]. has a [part_rel_type1] relationship [part_rel1] to [part_str1] entity [part_ent1]. In the E/R diagram weak entity is represented by [diagram1]. the relationship between a weak entity and a strong entity is represented by [diagram2].
Read Details
