Create 3nf table designs, Shahama is a small city with a

Create 3nf table designs

Assignment Help Database Management System

Reference no: EM131499107

Question: Database Design: Shahama Public Transit Authority

Shahama is a small city with a population of 50,000. Until now, Shahama was served by a bus route from the nearby Abu Dhabi city. The Shahama City Council has agreed to fund the purchase of several buses to serve three routes in Shahama and neighboring areas. As the city's IT director, you have been asked to set up an information system for the new Transportation Authority. Assume that multiple buses will run on each route.

Tasks

1) Draw an ERD for the Shahama Public Transit Authority system and Indicate cardinality on the diagram.

2) Identify all fields you plan to include in the tables.

3) Create 3NF table designs.

Reference no: EM131499107

Questions Cloud

Idea about cyber defense and ct : What is your idea about cyber defense and CT being more effective than drone assassination? 200 words list references.

Calculate the annual fuel savings and in gallons : Calculate the annual fuel savings, in gallons, for the truck and car assuming both vehicles are driven 17,000 miles per year.

What is the name of the sender as spam emails is displayed : List the (sender) originating server IP address. What is the name of the sender as it is displayed? And what is the real email address behind the name?

What is an external cost : Comment on the following statement: "The socially optimal amount of pollution is zero." What is an external cost?

Create 3nf table designs : Shahama is a small city with a population of 50,000. Until now, Shahama was served by a bus route from the nearby Abu Dhabi city. The Shahama City Council.

Analyze and synthesize data acquired from an illustrative : Analyze and synthesize data acquired from an illustrative, fictional case study (see below) and present the findings in a paper.

Perfectly competition ski resort business : Suppose that Keystone is a firm in perfectly competition ski resort business.

Explain the invention and growth of crowdsourcing : Examine the invention and growth of crowdsourcing in the field of interface design.

Profit-maximizing assumption : Does this result suggest why economists are not overly concerened about wheather the profit-maximizing assumption is exactly correct?

User Account

All Pages