Final Project – Steps 1-4
You are maintaining a small library for you and your friends to share so everyone can add books, and
check in and out books for their own use. This small library has grown lately and you would like to
create a small database to manage it better. After careful consideration, you think that the database
should store the following information (which is not presented in any particular order or structure):
Book authors
Boot title
ISBN
Publisher
Year when the book was published
Number of pages
Book owner
Price paid for the book
Where the book was bought
When the book was bought
Book's subject matter
Book category
Who borrowed the book
When the book was checked out
When the book was checked in
For how long a book was borrowed by one of your friends
For this section, complete the following steps (steps 1-4):
1.
Build a list of business needs, rules and assumptions based upon the scenario and
information provided.
2.
For organizational purposes, create a data dictionary table (refer to Table 3.6 in Chapter
3).
3.
Create a relational diagram following the rules of normalization from the contents of
your data dictionary table. Show your progression through each normal form from 1
st
through 3
rd,
including an explanation of how you have met each normal form.
4.
Define the relationships between the entities, including optionality and cardinality in the
logical model. Use Crow's Foot notation.
Submit your assignment to Canvas using the file name
StudentName_FinalProject_Steps1-4
. Your
assignment file must be in MS Word, RTF, or text format only. The diagrams may be submitted in the
default format of the application you use to create them.
