Create an entity relationship diagram

Reference no: EM133300891

Assignment: Create an entity relationship diagram for each of the following:

Question 1: A person is described by first name, last name and a unique personnel number. Customers are persons for whom a customer number and an acquisition date are also given. The latter states since when the person has been a customer. Employees are people for whom a contract number and a contract period should also be saved.
Question 2: Information about customers and vehicles is stored in the reservation system of a vehicle rental company. A unique license plate number and a vehicle type are specified for a vehicle. Customers are described by a unique customer number, first name and last name. Customers reserve vehicles in the office. A vehicle can be reserved by different customers with different reservation dates. There may also be vehicles without reservations. A customer must have reserved at least one vehicle. A reservation date should be specified for each reservation.
Question 3: A member is described by their first name, last name and a unique membership number. A member can have a membership card, each membership card must be assigned to exactly one member. A unique ID number, a start and end date of validity and a club function of the member are specified for a membership card.
Question 4: Students are described by a first name, last name and date of birth. Students may have siblings who are also students. Create an ERD. What options are there for meaningfully defining the primary key for the student entity?

Reference no: EM133300891

Questions Cloud

Philippines during spanish occupation : Philippines During Spanish Occupation. The Influence of Americans to the Filipinos.

Explain this is a true statement and how such a system works : Explain why this is a true statement and how such a system works.One of the topics we covered in Economics was entitled,"Allow businesses to purchase the right

Examine effects of climate change on international business : The paper will examine the effects of climate change on international business or the effects of political crisis on international business.

What is an mvp for bmc business idea : Explain, in general, what an MVP is & what purpose it serves for entrepreneurs. What is an MVP for your BMC business idea?

Create an entity relationship diagram : A person is described by first name, last name and a unique personnel number. Customers are persons for whom a customer number and an acquisition date

Socio-cultural and ecological theory : Looking at the factors affecting human development in terms of Socio-cultural and Ecological Theory,

Conflict serves the system in some way : "Conflict serves the system in some way." What does this statement mean? How is this different than or similar to how you have perceived conflict up to this poi

What is theme or premise of indecent : What is the theme or premise of Indecent? How does the director engage those themes beyond the script itself?

What are various security-sensitive areas found at airports : What are the various security-sensitive areas found at airports, as defined by Transportation Security Regulations?

User Account

All Pages