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\mathrm{.}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$\_$Steps$1-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 $12$ to $1-$page paper to explain how and why you did everything.$)$

I need a complete answer from step $1$ to step $10$ please.