Regional Bus Transit - Assignment Example

 Regional Bus Transit Data Management Team Project – Project DescriptionProject Name/Title: Reginal Bus Transit. Data DictionaryEntityAttributesData typesSizeDescriptionBUSRegistration number(pk)Type of busNumber of PassengersDate validSizeVarcharVarcharIntIntInt 10 12 3 12 10It is the primary key for bus table and it gives identification of bus.It is about bus detailsIt gives detail of number of passengers in bus.It shows detail about bus validity.It shows capacity of bus.ROUTERoute Number(pk)Area coveredBus numberNumber of stopsLength of routeVarcharVarcharVarcharIntInt 10 12 10 3 10It is the primary key for route table.

It gives identification of route.It gives details about area covered.It is the primary foreign keyIt gives details about the stopsIt gives details about length of route.DRIVEREmployee Id(pk)Contact numberFirst NameLast nameShift timingsVarcharIntVarcharIntInt 10 12 16 10 10It is the primary key of driver table and should not be nullIt provides detail of contact number of driverIt shows first name of driverIt shows last name of driverIt shows shift timings of driverSTOPStop nameRoute number Bus haultBus timingVarcharVarcharVarcharInt 10 10 20 10It shows name of particular stop and is primary keyIt shows the route numberIt gives details about bus haultIt gives details about bus timingsCityCity nameZip codeAddressStop nameRoute numberVarcharIntVarcharVarcharInt 30 5 30 10 10It gives details about city nameZip code of cityIt gives details about address of cityDetails of stop nameIt is the foreign key and provides route number[Woo02].

The relationship between the entities is important for the data model. It defines the main logical representation of the data flow.The relationship between entities Bus and Driver are one to one.The relationship between entities Bus and Route is one to many.The relationship between entities Bus and Stop is one to many.The relationship between entities Driver and Stop is one to many.The relationship between entities Route and City is one to one.The relationship between entities Stop and City is one to one.

3NF:All the relationships in the entity-relationship diagram are normalized to third normal form by removing transitive dependencies where the non-key attributes in an entity depend on another non-key attribute. The functional dependent attributes are separated and defined as foreign keys in the entity. All the attributes in a table that are related to another table are normalized by providing the foreign key of another table. Presently information model is in third standardized structure form.

References Draw.io - free flowchart maker and diagrams online. (n.d.). Retrieved March 26, 2016, from https://www.draw.io/ Hoffer, Jeffrey A., Fred R. McFadden, and Fred R. McFadden. "Logical Database Design and the Relational Model 62." Modern Database Management. Upper Saddle River, NJ: Prentice Hall, 2002. 62-107. Print.Hoffer, Jeffrey A., Fred R. McFadden, and Fred R. McFadden. "Logical Database Design and the Relational Model 155." Modern Database Management. Upper Saddle River, NJ: Prentice Hall, 2002. 155-88. Print.Rouse, M.(n.d.).

Data modelling definition. Retrieved March 13, 2016, from http://searchdatamanagement.techtarget.com/definition/data-modelingSQL Tutorial.(n.d.). Retrieved March 24, 2016, from http://www.w3schools.com/SQl/default.aspWoody, B. (2003). Developing a data dictionary. Retrieved April 7, 2016, from http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=382