Take Assessment: Exercise 1
Exercise 1: Relational Databases
Design the following two tables and turn in your submissions in an HTML file named BookPublisher.html.
Date of Publication
MH370 was an international scheduled passenger flight operated by Malaysia Airlines that
disappeared on March 8, 2014 during a flight from Kuala Lumpur International Airport,
Malaysia, to Beijing Capital International Airport in China. The l
MAS 370 (Kuala Lumpur to Beijing)
PILOT-ATC RADIOTELEPHONY TRANSCRIPT
Departure from KLIA: 8 March 2014
Delivery MAS 370 G
Anand Paranthawam (B14030004)
Database Systems Design, Implementation, and Management (Seventh Edition)
Peter Rob & Carlos Coronel
1) How many records does the file contain? How many fields are there per record?
Ans: 7 records and 5 fields
2) What problem
1) What is mean by information Hiding?
2) Define Object and its Persistence?
Persistent objects are the fundamental logical units of data storage in an Objectivity/DB
federated database. Persistent objects are created by applications. Each pe
The following tables form part of a Library database held in an RDBMS:
Book (ISBN, title, edition, year)
BookCopy (copyNo, ISBN, available)
Borrower (borrowerNo, borrowerName, borrowerAddress)
BookLoan (copyNo, dateOut, dateDue, borrowerNo)
where Book con