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 DetailsStudents in PSIO 201 Online are required to follow the exam…
Students in PSIO 201 Online are required to follow the exam guidelines (you may visit this link to view the Honorlock Student Guide for PSIO 201 Online at any time during the exam). Please confirm below that you will abide by the our required exam guidelines and that you will adhere in every way to the UA Code of Academic Integrity during our exams in this course.
Read DetailsA slice of pumpkin bread contains the following nutritional…
A slice of pumpkin bread contains the following nutritional information: Carbohydrates: 25 grams Fat: 10 grams Protein: 9 grams Total calories: 225 kcal. Using your computer calculate: 1- How many calories come from fat in this slice of pumpkin bread? 2- What is the percentage of calories from fat in this slice of pumpkin bread?
Read Details