Answer Happy

Car Make description Hyundai BMW Mercedes Benz Toyota Ford CarBodyType description Hatchback Sedan Coupe SUV
Car Carno Car Make Model Body Type Kilometres Service Available Travelled Kilometres Hatchback 1500 15000 yes HYU001 Hyundai Grand i10 1.0 Motion HYUOO2 Hyundai i20 1.2 Fluid Hatchback 3000 15000 yes BMW001 BMW 320d 1.2 Sedan 20000 50000 yes BMW002 BMW 240d 1.4 Sedan 9500 15000 yes TOY001 Toyota Corolla 1.0 Sedan 15000 50000 yes TOY002 Avanza 1.0 SUV 98000 15000 yes Toyota Toyota TOY003 Corolla Sedan 15000 50000 yes Quest 1.0 MER001 Mercedes c180 Sedan 5200 15000 yes Benz MEROO2 Mercedes A200 Sedan Sedan 4080 15000 yes Benz © The Independent Institute of Education (Pty) Ltd 2022 Page 4 of 14 21; 22; 23 2022 FOR001 Ford Fiesta 1.0 Sedan 7600 15000 yes
Inspector Inspector_no 1101 1102 Name Email Mobile Bud Barnes [email protected] 0821585359 Tracy Reeves [email protected] 0822889988 Sandra Goodwin [email protected] 0837695468 Shannon Burke [email protected] 0836802514 1103 1104 Driver Name Address Email Mobile Gabrielle 917 Heuvel St Botshabelo [email protected] 0837113269 Clarke Free State 9781 Geoffrey 1114 Dorp St Paarl Western [email protected] 0847728052 Franklin Cape 7655 Fawn Cooke 2158 Prospect St [email protected] 0821966584 Garsfontein Gauteng 0042 Darlene 2529 St. John Street [email protected] 0841221244 Peters Somerset West Western Cape 7110 Vita Soto 1474 Wolmarans St Sundra [email protected] 0824567924 Mpumalanga 2200 Opal Rehbein 697 Thutiwa St Letaba yiyow 34505 @enpaypal.com 0826864938 Limpopo 0870 Vernon 1935 Thutlwa St Letsitele [email protected] 0855991446 Hodgson Limpopo 0885 Crispin 330 Sandown Rd Cape [email protected] 0838347945 Wheatly Town Western Cape 8018 Melanie 616 Loop St Atlantis [email protected] 0827329001 Cunningham Western Cape 7350 Kevin Peay 814 Daffodil Dr Elliotdale xajic53991 @enpaypal.com 0832077149 Eastern Cape 5118
Rental Carno Inspector Driver Rental Fee Start Date End Date HYU001 Bud Barnes Gabrielle Clarke 5000 2021-08-30 2021-08-31 5000 2021-09-01 2021-09-10 2021-09-10 6500 2021-09-01 7000 2021-09-20 2021-09-25 HYU002 Bud Barnes FOR001 Bud Barnes BMW002 Tracy Reeves TOYOO2 Tracy Reeves MER001 Sandra Goodwin HYUOO2 Shannon Burke 5000 2021-10-03 2021-10-31 Gabrielle Clarke Geoffrey Franklin Vita Soto Darlene Peters Darlene Peters Vernon Hodgson Melanie Cunningham 8000 2021-10-05 2021-10-15 2022-02-10 5000 2021-12-01 TOY003 Shannon Burke 5000 2021-08-10 2021-08-31 Return Carno Inspector Driver Return Date Elapsed Fine Date Gabrielle Clarke 0 HYU001 HYU002 Bud Barnes Bud Barnes 2021-08-31 0 2021-09-100 2021-09-10 0 0 0 Gabrielle Clarke Geoffrey Franklin Vita Soto Darlene Peters Darlene Peters 2021-09-30 5 2500 2021-10-31 2 FOR001 Bud Barnes BMW002 Tracy Reeves TOYOO2 Tracy Reeves MERO01 Sandra Goodwin HYU002 Shannon Burke TOY003 Shannon Burke 1000 2021-10-15 1 500 Vernon Hodgson 2022-02-10 0 0 Melanie 2021-08-31 0 0 Cunningham
(Marks: 50) POE Part 1 - Database Design Learning Units: 1 - 3 At the end of this specific task, students should be able to: Create a normalized entity relationship model using the IDEF1X modelling notation Understand the relationships between entities, along with their multiplicities (cardinality and participation) Detail all the relevant names for your attributes and keys to fit the scenario Produce a normalised entity-relationship model for the proposed database system for The Ride You Rent. Use Integration Definition for Information Modelling (IDEF1X) standard, and normalise up to third normal form (3NF) Marks 5 10 10 MARK ALLOCATION Description Notation: Diagram uses an appropriate E-R notation. The notation is used correctly for all elements of the diagram. Entity sets: Diagram captures all entity sets including look-up tables necessary for a database that would satisfy the initial problem statement. Attributes and Keys: Diagram captures all attributes and primary keys necessary for a database that would satisfy the initial problem statement Complexity: The required number of tables and foreign key relationships will be needed to implement the database. Constraints: Diagram captures all cardinality and participation constraints necessary for a database that would satisfy the initial problem statement. (Recognising that if all relationships are legitimately many-many with partial participation, then no constraint annotations are necessary.) Professionalism: Diagram presents a professional appearance. It could be shared with a "real-world" customer without changes. 10 10 5 5