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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started