Microsoft Office Tutorials and References
In Depth Information
17. Suppose you have a table for a dance studio. The fields are dancer’s identification
number, dancer’s name, dancer’s address, dancer’s telephone number, class identifi-
cation number, day that the class meets, time that the class meets, instructor name,
and instructor identification number. Assume that each dancer takes one class, each
class meets only once a week and has one instructor, and each instructor can teach
more than one class. In what normal form is the table currently, given the following
Dancer ( DancerID , DancerName, DancerAddr, DancerPhone, ClassID, ClassDay,
ClassTime, InstrName, InstrID)
Convert this relation to third normal form and represent the design using the alterna-
tive description method.
18. Store the following fields for a library database: AuthorCode, AuthorName, BookTitle,
BorrowerAddress, BorrowerName, BorrowerCardNumber, CopiesOfBook, ISBN
(International Standard Book Number), LoanDate, PublisherCode, PublisherName,
and PublisherAddress. A one-to-many relationship exists between publishers and
books. Many-to-many relationships exist between authors and books and between
borrowers and books.
a. Name the entities for the library database.
b. Create the tables for the library database and describe them using the alternative
method. Be sure the tables are in third normal form.
c. Draw an entity-relationship diagram for the library database.
19. In the following database, which consists of the Department and Employee tables,
add one record to the end of the Employee table that violates both the entity integrity
constraint and the referential integrity constraint.