Final Project Steps 1-4 (1)
docx
keyboard_arrow_up
School
Metropolitan Community College, Kansas City *
*We aren’t endorsed by this school
Course
143
Subject
Information Systems
Date
Dec 6, 2023
Type
docx
Pages
2
Uploaded by SargentSeaUrchin3884
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.
(What’s due next (steps 5-10):
5.
Determine indexes you will create for each table.
6.
Write the DLL statements that you will use to create the tables and indexes. Don't forget about
the constraints identified from your list of business rules.
7.
Build the tables in the class DBMS.
8.
Using DML commands, insert data into your tables.
9.
Create two Views of your choice. Provide an explanation of their purpose.
10.Write a short 1⁄2 to 1-page paper to explain how and why you did everything.
)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help