Answer both questions and explain your answers.

Question 2: Consider the following Seven relations for a car-rental database

application in a company:

CUSTOMER(Cust#, Cname, City)

RENTAL(Rental#, Rdate, Cust#, Time, Date, Hourly_rate) RENTAL_CAR(Rental#, Car#, Driver#, State_time, End_time, Amount_recieved)

CAR(Car#, Year, Model, Price, Depreciation, Last_service)

SERVICING(Garager#, Car#, Service_date)

GRAGE(Garage#, GAddress, Owner_name)

DRIVER(Driver#, DName, DAddress)

Here, Hourly_rate refers to the per hour rate for a specific rental. Amount_received is the total fare; Time and Date are the time and date when the car and driver is sent to the customer. Rdate is the date the rental order was placed. Assume that a car can be driven by any driver and can go to more than one garage for servicing. Specify the foreign keys for this schema, stating any assumptions you make. What other constraints can you think of this database?

Question 2: Consider the following relations for a Library database that keeps track of users, suppliers, books, user registration and supply details:

USER(Ssn, Uname, Uaddress, Card#, Rdate)

BOOK(Book_isbn, Book_title, Publisher, Author)

BOOK_BORROWED(Ssn, Card#, Issue_date, Return_date, Book_isbn)

SUPPLIER(SSsn, Sname, Saddress, Account#)

SUPPLY(Book_isbn,SSsn, price, Sdate)

Specify the foreign keys for this schema, stating any assumptions you make.