Question: Exercise 1 Using Chen Notation, design a database for a car rental enterprise. The database should include the following information: basic information about cars: license

Exercise 1

Using Chen Notation, design a database for a car rental enterprise. The database should include the following information: basic information about cars: license number (unique for each car), model, purchase date, replacement price, car class information about car classes: size, description, rental price basic customer information: customer number, name, phone number rental transactions: which car, which customer, date out, date in

Exercise 2

Using Crow's Foot Notation, design a database for an apartment rental enterprise, including: apartment data: city, street, house number, apartment number, size (ft2), purchase date and price, rent per month renter data: name, contact information, which apartments he/she rents (one renter may have several), rental time period, check out date, record of payments

Exercise 3

Using Crow's Foot notation, design a database for a dog grooming business that also provides

boarding.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!