Database Reference
In-Depth Information
Henry Books Case
For the following exercises, you do not use the Henry Books database.
1. The DBA asks for your help in planning the data archive for the following Henry Books database:
Branch (BranchNum, BranchName, BranchLocation)
Publisher (PublisherCode, PublisherName, City)
Author (AuthorNum, AuthorLast, AuthorFirst)
Book (BookCode, Title, PublisherCode, Type, Paperback)
Wrote (BookCode, AuthorNum, Sequence)
Copy (BookCode, BranchNum, CopyNum, Quality, Price)
276
Determine which data from the database to archive; that is, for each table, specify whether data needs to be
archived. If it does, specify which data, when it should be archived, and whether it should be archived with data
from another table.
2. The DBA denormalized some of the data in the Henry Books database to improve performance, and one of the
resulting tables is the following:
Wrote (BookCode, AuthorNum, Sequence, PublisherCode, PublisherName)
Which field or fields cause the table to no longer be in third normal form? In which normal form is the denormalized
table?
3.
Interview the DBA at your school or at a local business to determine the safeguards used to segregate the pro-
duction system from the test system.
Alexamara Marina Group Case
For the following exercises, you do not use the Alexamara database.
1. The DBA asks for your help in planning the data archive for the following Alexamara database:
Marina (MarinaNum, MarinaName, Address, City, State, Zip)
Owner (OwnerNum, LastName, FirstName, Address, City, State, Zip)
MarinaSlip (SlipID, MarinaNum, SlipNum, Length,
RentalFee, BoatName, BoatType, OwnerNum)
ServiceCategory (CategoryNum, CategoryDescription)
ServiceRequest (ServiceID, SlipID, CategoryNum,
Description, Status, EstHours, SpentHours,
NextServiceDate)
Determine which data from the database to archive; that is, for each table, specify whether data needs to be
archived. If it does, specify which data to archive, when it should be archived, and whether it should be archived
with data from another table.
2. The DBA denormalized some of the data in the Alexamara database to improve performance, and one of the
resulting tables is the following:
MarinaSlip (SlipID, MarinaNum, MarinaName, SlipNum,
Length, RentalFee, BoatName, BoatType, OwnerNum,
LastName, FirstName)
Which field or fields cause the table to no longer be in third normal form? In which normal form is the denormalized
table?
3.
Interview the DBA at your school or at a local business to determine the security and access privilege proce-
dures used to safeguard data.
