Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Students also viewed these Databases questions