Draw a project-level er diagram for situation

Assignment Help Computer Engineering

Reference no: EM133423571

Question: A parking station in Binghamton serves customers paying fixed monthly fees. Each customer has attributes, customer ID (identifier) assigned by the parking station, customer name, customer address, and customer phone. The monthly fee changes periodically and is negotiated separately for each customer. The parking station wishes to maintain a history of the fee details for each customer. The attributes of fee details include fee ID (identifier), amount, time period, start date, and end date. The parking station has more than 1000 parking spots with sensors that detect whether there is a car parked in that spot. Each parking spot has attributes, parking spot ID (identifier), parking spot floor, and parking spot number. The sensor can also detect which customer has parked at that spot and when. The parking station wants to keep track of each time a customer uses a parking spot, including the number of the license plate, start and end parking times. Draw a project-level ER diagram for this situation.

General instructions for the following questions:

You must draw project-level ER diagrams.

If the attribute types are not explicitly provided, you need not denote them using a symbol.

Add relationship names.

If there are many-to-many relationships, they need to be resolved.

Use a computer tool to draw your diagrams.

Reference no: EM133423571

Questions Cloud

Design a mailing list database : design a mailing list database. Your boss said, "All we need is just keep listing our 10 million+ clients' names and addresses. We use it to create mailing

Determine the effectiveness of your change : In order to evaluate an evidence-based practice project, it is important to be able to determine the effectiveness of your change.

What is the clinical significance of this to the patient : Calculate the INR for the following data set. Answer to the nearest tenth of a decimal point. Show all your work & circle your final answer.

How many different genotypes could be produced from : how many different genotypes could be produced from a single mating event? 291 How swer to 20 explain diversity we see in humans, even between siblings?

Draw a project-level er diagram for situation : CS 600 Open University Malaysia track of each time a customer uses a parking spot, including the number of the license plate, start and end parking times

What are these 3 letter codes called : During translation, the mRNA leaves the nucleus and travels to a ribosome where it is "translated" into an amino acid sequence. The "genetic code" is written

Develop a c program to implement the gale-shapley stable : Develop a C program to implement the Gale-Shapley stable marriage algorithm. The program reads in a file storing preference lists, and outputs the solution

What does the article suggest people should do and explain : Distinguish carbohydrates from other macromolecules (proteins, etc) Give two specific examples of how carbohydrates function within the human body.

Describe what happens during the reflex in terms of stimulus : Describe what happens during the reflex in terms of stimulus and involved muscles Explain whether it is monosynaptic or polysynaptic and what this means Explain

User Account

All Pages