Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

task 3 Create an entity relationship diagram for each of the following subtasks a) to d). Note: The subtasks a) to d) are independent of

task 3 Create an entity relationship diagram for each of the following subtasks a) to d). Note: The subtasks a) to d) are independent of each other and should be considered individually. a) 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. b) 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. c) 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. d) 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???

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Economics questions