Overview of business case:<\/p>\n
Drive-n-Drop is a transport company that provides bus services to the public in the Sydney metropolitan area. The company employs a number of bus drivers and owns a fleet of over 90 busses. Drive-n-Drop has been using an Excel spreadsheet to track their business activities; however, this has caused many redundancies and inefficiency.<\/p>\n
With view to their expanding business and under the new management, they decided to investigate the option of implementing a database system. Accordingly, they hired you to design a relational database to better track and record their operational data.<\/p>\n
Your task:<\/p>\n
Create an ERD for each of the following statements that describe the current business rules for Drive-n-Drop. For each new statement being the business rule, extend the ERD to include the additional business rule in the ERD (created in previous point ? for example; B will include A&B, C will include A, B & C, etc.)<\/p>\n
Use Crows Foot notations and include all of the following in each part:<\/p>\n
All entities with Primary key and any foreign key attributes; The relationships between entities; The cardinality and optionality of each relationship; Any M:N relationships are be resolved to 1:M relationships<\/p>\n
Drive-n-Drop discovered business rules for your ERD:<\/p>\n
Each driver is assigned to one shift (morning, afternoon, night), and each shift includes a number of drivers. (2 marks) A bus is assigned to a driver for each shift, with the bus number appearing on the driver\u2019s shift. That\u2019s is how the driver knows what bus to pick up from the depot at the start of his\/her shift. (2 marks) Each shift covers multiple routes; that is, with some shifts there are up to 6 routes that are covered, depending on the length of the route and the number of stops pertaining to the route. (2 marks) Each route is of different length and includes multiple sections. A route is covered multiple times in each shift depending on the time of the day and peak period: for example Route 305 takes 1.5 hours to be covered in a whole shift, but is serviced every 15 minutes. (4 marks) Submission Method: Online via Turnitin<\/p>\n","protected":false},"excerpt":{"rendered":"
Overview of business case: Drive-n-Drop is a transport company that provides bus services to the public in the Sydney metropolitan area. The company employs a number of bus drivers and owns a fleet of over 90 busses. Drive-n-Drop has been Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-155540","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/155540","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=155540"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/155540\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=155540"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=155540"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=155540"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}