Design a clean and normalized database

Assignment Help Database Management System
Reference no: EM13812411

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: EM13812411

Questions Cloud

Definitions for prejudice-discrimination-racism-sexism : definitions for prejudice, discrimination, racism, sexism, and homophobia
Briefly summarize what this group is working on : The following Website may be used for reference to complete this assignment. The Website represents an electronic document titled "Standards Organizations" written by William Stallings (2009). Select one (1) of the working groups in the IETF or IEE..
Should the united states implement national health care : Should the United States implement National Health Care
Circumstance would it be ethically required to end that life : circumstances would it be ethically required to end that life
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: Analyze and identify some of the logical problems that might exist in the library system
Capacity implications of the marketing campaign : What are the capacity implications of the marketing campaign (assume no learning)?
Director of continuous improvement of a company : Assume that you have recently been hired as the director of continuous improvement of a company. You are an outside hire with limited history of the firm and personal capital at the firm, and you are responsible for lean production, total quality ..
Analyze the contention avoidance methods : Analyze the contention avoidance methods proposed by the authors for the cache, memory controller, front-side bus (FSB), and prefetching hardware in the distributed architecture
Integration of activities that procure materials : Supply chain management is the integration of activities that procure materials and services, transform them into intermediate goods and final products, and deliver them to customers.

Reviews

Write a Review

 

Database Management System Questions & Answers

  Role of metadata in data acquisition process

You are a vice president of marketing for a nation-wide appliance manufacturer with three production plants. Explain different ways you would tend to analyze your sales. What are the business dimensions for your analysis?

  Describe a general company security policy for database

Describe a general company security policy for the database "layer" of security only (avoid getting into network security protocols or application level security for this exercise, and assume that there are security mechanisms in place that allow ..

  Explain the content and user access methods

Find an example of an actual data warehouse. For this example, explain the content, user access methods, purpose, and sources of data (what on-line transaction processing [OLTP] databases feed data into the data warehouse) -

  Build an entity relationship model for the above scenario

Draw a DFD (Context and Level 1) for placing an order based on the E-R diagram shown here.

  Part 1 - reportwrite a 2000-word report that describes a

part 1 - reportwrite a 2000-word report that describes a suitable methodology from the literature for the purpose of

  Database for university keep track of its course offerings

Assume you are making a database to help university keep track of its course offerings. You might have following entities in database, as they are distinct items in real life.

  Create an erd to show the resultant tables

Create an ERD to show the resultant tables at the 3NF level with all the needed attributes, Primary/Foreign keys etc - Create the RDM with appropriate attributes, primary and foreign keys.

  Define the importance of various system analysis

By now you should have a "toolbox" full of useful design and analysis tools. List the tools in your toolbox and then write one short paragraph on how you can/will apply them in your careers, lives, etc.

  Develop an activity diagram for the scenario

In each task, please feel free to make any assumption necessary for the readers. The explanation of your assumptions can help the readers to understand what you have considered differently but as important criteria in producing your model.

  Construct a data warehouse bus matrix

First construct a Data Warehouse Bus Matrix to identify the company's business processes and any likely Data Marts and design the star schema for any Data Marts you have identified.

  List and describe three main capabilities or tools of a dbms

List and describe three main capabilities or tools of a DBMS. Describe the effect of cloud computing on traditional IT infrastructure

  What amounts will be require for ordering supplies

Design a spreadsheet that will enable you to request the required funds from your team's finance officer, order supplies from the home office, and ensure dissemination of appropriate quantities to each village.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd