Database Design and Development

Homework #$1$

Instructions: Complete the assignment through individual effort only $-$ you are not allowed to give or receive help with anyone else.

Provide complete answers to the questions below. All required tables should be created with data in MS Word. The answers to all

questions should be in a single MS Word document. The document should include an appropriate header $($your name, date, and class

information$),$ and be uploaded to D$2$L by the due date. This is a graded assignment and, therefore, must be completed through

individual effort. After you submit your file, be certain to logout of D$2$L$,log$ back in$,$ go to the drop box, and verify that you gave me

the correct file.

Use the following tables that depict that an author can write many books, and a book can have many authors. Each book has only one

publisher, but a publisher can publish many books. An author can attend many book signings. Each book signing is done by only one

author. The primary keys to consider are indicated.

SIGNING $($primary key: SIGN ID$)$

AUTHOR $($primary key: AU$\_$ID$)$

WRITES $($composite primary key: AU$\_$ID$,$ BOOK$\_$ID$)$

BOOK $($primary key: BOOK$\_$ID$)$

PUBLISHER $($primary key: PUB ID$)$

Does the SIGNING table have entity integrity? Why or why not?

Does the AUTHOR table have entity integrity? Why or why not?

Does the WRITES table have entity integrity? Why or why not?

Does the BOOK table have referential integrity in its relationship with PUBLISHER? Why or why not?

Does the AUTHOR table have referential integrity in its relationship with SIGNING? Why or why not?

Does the WRITES table have referential integrity in its relationship with BOOK? Why or why not?

Create the table that would result from an Equijoin of AUTHOR$-$join$-$SIGNING.

Create the table that would result from a RIGHT Outer Join of PUBLISHER$-$join$-$BOOK.