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.
|
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.
|