Question: Produce a normalised entity-relationship model for the proposed database system for The Ride You Rent. Use Int

[answerhappygod]

Question:
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
the third normal form (3NF).
Supporting material:

Question Produce A Normalised Entity Relationship Model For The Proposed Database System For The Ride You Rent Use Int 1 (64.23 KiB) Viewed 37 times

Format:
Please clarify between the normalisation forms:

Question Produce A Normalised Entity Relationship Model For The Proposed Database System For The Ride You Rent Use Int 2 (77.07 KiB) Viewed 37 times

Portfolio of Evidence (PoE) – Background With the growing popularity of e-hailing there is a growing need for people who want to be able to access convenient, affordable, and safe transport to and from wherever they may want to go. Being a part of the driver community for an environment such as this is not always the easiest thing as the drivers of these e-hailing vehicles are normally the owners of the cars, meaning their car is for both work and leisure, which can take a huge toll on the car itself. Because the maintenance of the car is also normally solely dependent on the owner unless they have a motor plan or service plan, working everyday with their cars means this service period comes quick and fast and the renewal of these plans can prove to be a little costly, which sometimes makes it a whole lot harder to maintain a solid career as an e-hailing driver. "The Ride You Rent" is a new start-up that hopes to solve that issue by providing drivers with the ability to rent out a car for a specified amount of time to perform their regular e-hailing duties and once done they can return the vehicle and not have to worry about the maintenance. At present they have been capturing cars and tracking rentals using a paper-based flat-file system, which can become very hard to manage on a day-to-day basis. The Ride You Rent has sent out an RFQ to contractors who can develop a management system where they can manage drivers, rentals and returns on all their rental vehicles, as well as track any late fees that could be incurred should a driver return a car after the specified rental time. They would like to be able to access this system from a desktop computer as well as a mobile phone, as some of the Inspectors are normally sent out to collect the vehicles at pick-up points, if the drivers are not able to return them straight to the depot. In the spirit of moving to a paperless system they want the Inspectors to be able to log the return using a mobile phone as soon as the vehicle is collected They do plan on expanding the system to add more functionality but for now they only need the Driver, Inspector, Vehicle, Rental, and Return Management functionality designed and developed.
Below are some samples of the hard copy records currently kept by The Ride You Rent: Car Make description Hyundai BMW Mercedes Benz Toyota Ford CarBodyType description Hatchback Sedan Coupe SUV Car CarNo Car Make Model Body Type Kilometres Available Travelled Service Kilometres 15000 HYU001 Hyundai Grand i10 Hatchback 1500 yes 1.0 Motion HYU002 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 TOYOO2 Toyota Avanza 1.0 SUV 98000 15000 yes TOY003 Toyota Corolla Sedan 15000 50000 yes Quest 1.0 MER001 Mercedes c180 Sedan 5200 15000 yes Benz MEROO2 Sedan 4080 15000 yes Mercedes A200 Sedan Benz
FOR001 Ford Fiesta 1.0 Sedan 7600 15000 yes Inspector Inspector_no Name Email Mobile 1101 1102 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 [email protected] 0821966584 2158 Prospect St Garsfontein Gauteng 0042 2529 St. John Street Somerset West Western Darlene [email protected] 0841221244 Peters Cape 7110 Vita Soto 1474 Wolmarans St Sundra [email protected] 0824567924 [email protected] 0826864938 [email protected] 0855991446 Mpumalanga 2200 Opal Rehbein 697 Thutlwa St Letaba Limpopo 0870 Vernon 1935 Thutiwa St Letsitele Hodgson Limpopo 0885 Crispin 330 Sandown Rd Cape Wheatly Town Western Cape 8018 Melanie 616 Loop St Atlantis Cunningham Western Cape 7350 likon [email protected] 0838347945 [email protected] 0827329001 Kevin Peay 814 Daffodil Dr Elliotdale [email protected] 0832077149 Eastern Cape 5118
Renta! Carno Inspector Driver Rental Fee Start Date End Date HYU001 Bud Barnes Gabrielle Clarke 5000 2021-08-30 2021-08-31 HYU002 Bud Barnes Gabrielle Clarke 5000 2021-09-01 2021-09-10 FOR001 Bud Barnes Geoffrey Franklin 6500 2021-09-01 2021-09-10 BMW002 Tracy Reeves Vita Soto 7000 2021-09-20 2021-09-25 TOY002 Tracy Reeves Darlene Peters 5000 2021-10-03 2021-10-31 MERO01 Sandra Goodwin Darlene Peters 8000 2021-10-05 2021-10-15 HYU002 Shannon Burke Vernon Hodgson 5000 2021-12-01 2022-02-10 TOY003 Shannon Burke Melanie 5000 2021-08-10 2021-08-31 Cunningham Return Carno Inspector Driver Return Date Elapsed Fine Date HYU001 Bud Barnes Gabrielle Clarke 2021-08-31 0 0 HYU002 Bud Barnes 2021-09-10 0 0 FOR001 Bud Barnes Gabrielle Clarke Geoffrey Franklin Vita Soto 2021-09-10 0 0 BMW002 Tracy Reeves 2021-09-30 5 2500 TOY002 Tracy Reeves Darlene Peters 2021-10-31 2 1000 MER001 Sandra Goodwin Darlene Peters 2021-10-15 1 500 HYU002 Shannon Burke Vernon Hodgson 2022-02-10 0 0 TOY003 Shannon Burke Melanie 2021-08-31 0 0 Cunningham
Instructions The Portfolio of Evidence (PoE) requires you to create a database cloud web application for The Ride You Rent. The web application will be progressively developed through the execution of Part 1 (database design) and Part 2 (data, queries and migration) that build on each other to create a final application (POE Part 3) for CLDV6211 Summary Sheet: ITEM DESCRIPTION Summary of Activities Students must upload their submission to Learn or any other secure alternative platform as instructed by the lecturer. Please verify where and how this should be done with the lecturer before submission Tools & Resources Please supply the URL of the Web App with your submission, and include file exports as indicated for the Azure database. • Microsoft Visual Studio 2017 or higher • Microsoft Visio or other database design software; MS SQL Server 2012 or higher • Windows Azure subscription with Microsoft Azure SQL Database The data for The Ride You Rent as shown above is not necessarily normalised – it is your duty to organise the data in the most optimal way possible. For example, the hard copy records shown above will not necessarily map directly to database tables. You are expected to use these tables as a starting point for your own normalisation and optimisation of The Ride You Rent. Where required you should show all SQL scripts along with their results. Submit the URL of your Web App. Submit a file export of your Azure database.
Learning Units: 1-3 At the end of this specific task, students should be able to: Create a normalized entity relationship model using the IDEFIX 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 (IDEFIX) 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
RUBRIC FOR POE PART 1 Excellent Poor Levels of Achievement Good Developing Score Ranges Per Level 3-4 2-3 4-5 0-2 9-10 7-8 3-5 0-2 9-10 7-8 3-5 0-2 RUBRIC 1 (for POE Part 1) In order to be awarded full marks for these elements, students need to have: 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. POE PART 1 SUBTOTAL 9-10 7-8 3-5 0-2 9-10 7-8 3-5 0-2 4-5 3-4 2-3 0-2 /50
Normalisation steps (from UNF to 3NF) 2NF 3NF UNF 1NF List of un-normalised Attributes split into attributes showing: separate data groups having broken out the chosen key repeated groups. field; repeating groups in identify keys of each (....) group and any foreign key links using @ Further data groups created by breaking out part-key dependencies. Identify keys of each group and any foreign key links @ Key of repeated group will be compound one of at least two fields Rules? 10