Design a clean and normalized database

Assignment Help Database Management System

Reference no: EM13811429

Design a clean and normalized database that handles books for a library application. You need to consider the following rules before you design the database:

All books are mapped to categories. For example, the book Distributed Operating System belongs to:

?Computer science

?Operating systems

?Distributed systems

The following parameters associated with the books are available with the library:

?Author

?Quantity

?Year of purchase

?Year of publication

?Publisher

A member can have one of the following memberships:

?Life members (Platinum)

?Yearly members (Gold)

?Monthly members

?Members with fixed durations

?Visitors

Depending upon the membership, every member can borrow some books.

Using the library project discussed earlier, respond to the following:

Analyze and identify some of the logical problems that might exist in the library system,
Submit the queries required to create the tables in the database. Use proper SQL notation and make sure all tables are normalized (follow third normal form (3NF) schema).
Connect the appropriate tables using referential integrity, which enables the user to retrieve all the details relevant to the database. For example, create separate tables for authors, books, and memberships and connect them through primary and foreign keys.

Reference no: EM13811429

Questions Cloud

Create a program that has an array of given length : Create a program that has an array of length 100 which will automatically be filled with randomly generated numbers between 1-100 each time the program is run

Question regarding the compassionate hospitals and clinics : After Elizabeth received her bachelor's degree, she received no job offers. So she began working toward a master's degree in Human Resources Management.

Difference between this bonds YTM and its YTC : McCue Inc.'s bonds currently sell for $1,250. They pay a $90 annual coupon, have a 25-year maturity, and a $1,000 par value, but they can be called in 5 years at $1,050. Assume that no costs other than the call premium would be incurred to call and r..

Describe the applicable process model : Can you describe the Applicable process model, and data models - the Analysis Phase.

Design a clean and normalized database : Design a clean and normalized database that handles books for a library application. You need to consider the following rules before you design the database: All books are mapped to categories. For example, the book Distributed Operating System bel..

How does video brand globalization and resistance affect you : How does the video "Brands, Globalization & Resistance" affect you? How the logo represents the brand?

Consumerism and planned obsolescence : Consumerism and Planned Obsolescence

Display the invoice number and the invoice date : Display the invoice number, the invoice date, the customer id, and the customer name for each order in the database

Risk-free rate-what is the market risk premium : Porter Inc's stock has an expected return of 12.25%, a beta of 1.25, and is in equilibrium. If the risk-free rate is 5.00%, what is the market risk premium?

User Account

All Pages