Free

Regional Bus Transit - Assignment Example

Comments (0) Cite this document
Summary
The relationship between the entities is important for the data model. It defines the main logical representation of the data flow…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER93.7% of users find it useful

Extract of sample "Regional Bus Transit"


Regional Bus Transit
Data Management Team Project – Project Description
Project Name/Title: Reginal Bus Transit.
Data Dictionary
Entity
Attributes
Data types
Size
Description
BUS
Registration number(pk)
Type of bus
Number of Passengers
Date valid
Size
Varchar
Varchar
Int
Int
Int
10
12
3
12
10
It is the primary key for bus table and it gives identification of bus.
It is about bus details
It gives detail of number of passengers in bus.
It shows detail about bus validity.
It shows capacity of bus.
ROUTE
Route Number(pk)
Area covered
Bus number
Number of stops
Length of route
Varchar
Varchar
Varchar
Int
Int
10
12
10
3
10
It is the primary key for route table. It gives identification of route.
It gives details about area covered.
It is the primary foreign key
It gives details about the stops
It gives details about length of route.
DRIVER
Employee Id(pk)
Contact number
First Name
Last name
Shift timings
Varchar
Int
Varchar
Int
Int
10
12
16
10
10
It is the primary key of driver table and should not be null
It provides detail of contact number of driver
It shows first name of driver
It shows last name of driver
It shows shift timings of driver
STOP
Stop name
Route number
Bus hault
Bus timing
Varchar
Varchar
Varchar
Int
10
10
20
10
It shows name of particular stop and is primary key
It shows the route number
It gives details about bus hault
It gives details about bus timings
City
City name
Zip code
Address
Stop name
Route number
Varchar
Int
Varchar
Varchar
Int
30
5
30
10
10
It gives details about city name
Zip code of city
It gives details about address of city
Details of stop name
It 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-modeling
SQL Tutorial.(n.d.). Retrieved March 24, 2016, from http://www.w3schools.com/SQl/default.asp
Woody, B. (2003). Developing a data dictionary. Retrieved April 7, 2016, from http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=382 Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Regional Bus Transit Assignment Example | Topics and Well Written Essays - 500 words”, n.d.)
Regional Bus Transit Assignment Example | Topics and Well Written Essays - 500 words. Retrieved from https://studentshare.org/management/1702631-regional-bus-transit
(Regional Bus Transit Assignment Example | Topics and Well Written Essays - 500 Words)
Regional Bus Transit Assignment Example | Topics and Well Written Essays - 500 Words. https://studentshare.org/management/1702631-regional-bus-transit.
“Regional Bus Transit Assignment Example | Topics and Well Written Essays - 500 Words”, n.d. https://studentshare.org/management/1702631-regional-bus-transit.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Regional Bus Transit

Regional Studies

...? Regional Studies of the of the Regional Studies Japan Japans buyer electronics commerce is renowned for constructing peak of the journals of electrical devices goods that numerous persons understand and enjoy. The reality is that Japan is dwelling to numerous peak manufacturers’ renowned electrical devices gear that is renowned worldwide. Japan is dwelling to the electronics commerce, for example Sony, Hitachi, Casio, RV, Toshiba, TDK, Kenwood, Olympus, Nintendo, Epson, Yamaha, Fujitsu, Sharp, Canon, Fujifilm, Panasonic, JVC, Pioneer, etc. You can glimpse the register will extend to proceed on and on. In 1946, Sony has taken location and Akio Morita and Masaru Ibuka founded. There is no question that...
9 Pages(2250 words)Essay

Regional economy

...?Regional Economic Development: Assignment 2 Part 1. Critically assess those areas of European Union economic policy that have had important effects on regional economies within the union. The European Union policy of innovation and Research and development, and the implementation of financial and management instruments reflect the creation and dissemination of innovation in the area of European Union, as well as complexity of the Research and development policy and implementation processes. In the research is conducted, that innovations and Research and development in the context of the European Union policy is determining factors for the growth of regional economy and the stimulation of...
4 Pages(1000 words)Essay

Elderly Receive Free Bus Rides

...Elderly Receive Free Bus Rides Introduction During the period of Jun it was decided that the seniors living in the region of Oakville will be offered one free day of travelling through Oakville Transit each weak (Oakville Transit 2012). Halifax Metro Transit announced during the period of September 12th that on every Tuesday of each week, senior citizens aging above 65 will get a free day of travelling through the transit for a period of three months (CBC News 2012). During Jun 2012, the senior citizens living in Niagra might be offered one complete day of free travelling through Niagra Regional Transit...
3 Pages(750 words)Essay

Regional Econmic

... Submitted] Economic Implication of Open Spaces The purchase of open spaces and conversion to natural area systems was a response to the growing infringement of suburban development and ranch conversion of landscapes that are causing losses in biological diversity and agricultural production. While the purpose of such purchases is recommendable, there is much to be resolved regarding the wisdom of conserving against the opportunity of gaining profits from converting the property into prime lots. Environmental science would tell us that making use of the lands for industrial purposes leads to ecological alterations that are irreversible. Not only does it result to the loss of wildlife habitat, it also presents dangers... Submitted] Economic...
2 Pages(500 words)Essay

NY transit strike

...NY transit strike Why were union members unhappy with their prior contact from 2002? The union members had three unfulfilled demands from the 2002 contract. These demands were in the areas of: retirement, pension and wage all of which were to be increased by a certain percentage but that did not happen. In the wage and salary increase for example, the agreed terms were for the workers to have a 6% increase every year since 2002. The paid increase was 3%, 4% and 3.5% for the three years consecutively which was way lower than the agreement in the contract (Books Llc, 35). What was the status of the MTA budget in 2005? According to MTA, they had a surplus of $ 1 billion in that year. The truth however was that the company...
1 Pages(250 words)Assignment

United Food & Commercial Workers Union, Local 1099 v. Southwest Ohio Regional Transit Authority, 163 F.3d 341; Rita Miller V. Clinton County, 544 F.3d 542

...United Food & Commercial Workers Union Case number 97-4126, United Food & Commercials Workers Union (UFCWU), et al, Plaintiff-Apellees, vs. Southwest Ohio Regional Transit Authority (SORTA), Defendant, Appellant, was argued from June 15 1998 and decided on December 10 1998. The defendant, SORTA, which is a state agency, had appealed against a district court’s ruling that granted UFCWU preliminary injunctive relief whereby the defendant was required to accept a proposed bus advertisement. In the case’s prior history, pursuant to 42 U.S.C. 1983 and on grounds of First Amendment, UFCWU challenged SORTA’s decision to reject the planned wrap-around advertisement, which they (SORTA) termed as...
4 Pages(1000 words)Essay

Transit finance project

...Macro & Micro Economics: Transit Finance Project Number: Part Introduction All the societies set up organisations for responding to the specific requirements of the society. Municipal institutions are also a type of such organisations for responding to a wide range of specific needs of local communities. The geographical area of municipal institutions is generally very small, but they perform a wide range of functions. A municipal institution is a form of local government which, unlike provincial or central governments, is located at the heart of the society served by it. The Federation of Canadian Municipalities (FCM) is a national organisation of Canada, which represents the municipal governments in Canada. Within...
9 Pages(2250 words)Research Paper

BUS

...In my working experience in restaurant, the manager tried to apply Quality management. For instance, every day at the settled time we had meetings todiscuss the main results of our work. In addition, we were aware what exactly our manager required from us to provide the high quality of restaurant service. In this context, waiters knew their plan from managers, cookers told the others the dishes that are ready to expire, and managers gave examinations to the newcomers. In my opinion, the very idea of these gatherings was effective. In theory, they enabled direct communication between different ranks within the restaurant hierarchy, the staff was aware of restaurant’s vision, and everyone saw all the achievements and failures... my working...
1 Pages(250 words)Essay

Regional

... Summary The essay “Re-examining the Rhetoric of the Cultural Border” by Heewon Chang examines the rhetoric of cultural border, borderlands and boundaries. The author uses four examples of people who lived in multicultural contexts to demonstrate that individuals can define and redefine their cultural identities in multicultural societies. One of them was a multiracial born by parents of different races and raised in a different culture. The second was an adoptee born of Korean origin but adopted by Jews who lived in USA. Thirdly, Peter was born in United States by immigrants from Korea (Chang 2013). Lastly, an immigrant to United States was married by a Korean immigrant to United States. In all these cases, there was no boundary... Summary...
1 Pages(250 words)Book Report/Review

REGIONAL UNEMPLOYMENT

...A Study of Unemployment Rates in Various Regions of the United Kingdom. By A Study of Unemployment Rates in Various Regions of the United Kingdom Task 1 – Tabulation of unemployment data. Figures in % Unemployment Rates per region Scotland Wales London Northern Ireland Jan to March 2010 8.3 9.4 9.2 8.0 April to June 2010 8.3 8.9 9.5 7.9 July to Sep 2010 8.4 8.0 9.2 7.8 Oct to Dec 2010 7.9 8.3 9.2 7.9 Jan to March 2011 7.9 7.9 9.2 7.8 April to June 2011 7.9 8.4 9.9 7.9 July to Sep 2011 8.0 9.3 10.1 8.3 Oct to Dec 2011 8.6 8.9 10.3 8.4 Jan to March 2012 8.3 9.1 10.1 8.2 April to June 2012 8.0 8.5 9.0 8.0 July to Sep 2012 8.1 8.2 9.0 7.9 Oct to Dec 2012 7.6 8.6 8.7 7.8 Jan to March...
2 Pages(500 words)Essay
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

Let us find you another Assignment on topic Regional Bus Transit for FREE!

Contact Us