Construct a database for a parking service system

Assignment Help Computer Engineering

Reference no: EM133370237

Question 1

We plan to construct a database for a parking service system. The university has many parking-lots which can accommodate many vehicles.

Each parking-lot has id, name, and location. A parking-lot consists of many parking spaces (or spots) and each parking space (or spots) has a unique number.

Every customer has zno and name. A customer can purchase more than one parking-permit.

A vehicle has id, brand, and color. A customer can own multiple vehicies.

Each parking permit has no. and price. A parking-permit allows a vechicle to park in dedicated parking spaces.

The university maintains a time table and uses it to record when a customer parks a vechicle at a dedicated parking space (or spot) at a specific time-slot in the timetable.

A time-table has id, date, and hour.

Draw an ER diagram for this application. Specify key attributes of each entity type and structural constraints on each relationship type

Question 2

Write DDL statements to create the tables for the ER diagram of Question1

Reference no: EM133370237

Questions Cloud

Add a playgame method to the cardwars class : Add a PlayGame method to the CardWars class. It should have 3 parameters: List for the cards, List for the high scores, and a string for the name of the high

Name and describe the health service organization : Name and describe the health service organization. Define its product/service background. Describe its primary target market in terms of the segmentatio

What has been zaras approach to achieving and sustaining : What has been Zara's approach to achieving and sustaining competitive advantage and How has Information Technology (IT) enabled Zara's strategy

What is the significance of pandas : What is the significance of PANDAS (pediatric autoimmune neuropsychiatric disorders associated with streptococcus)? Discuss any ages that are of concern.

Construct a database for a parking service system : Draw an ER diagram for this application. Specify key attributes of each entity type and structural constraints on each relationship type

How sexual orientation and gender identity : A discussion of how sexual orientation and gender identity are similar and how they are different. Include a definition of both in your discussion.

Discuss form of common problem that would be issue : BSIT 320 Bellevue University Discuss a form of common problem that would be a connectivity issue. It could be about using APIPA addressing, IPv4 instead of IPv6

Discuss two or more ethical considerations either for : Stem cell research is still a current healthcare issue. The United States Food and Drug Administration (FDA) has only approved a very limited number

What are the benefits of hex over binary : What are the benefits of Hex over Binary and why are we seeing the Hex interpretation of data with our forensic tools?

User Account

All Pages