User Account

All Pages

How to calculate charges if user returns the book late

Assignment Help Database Management System
Reference no: EM131266007

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,

How to calculate charges if user returns the book late
How to determine the book condition/depreciation
Provision of scanning the barcode instead of entering the data manually
Generating alerts if due date is over
sending emails to all users for new arrivals and delay notifications

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

Reference no: EM131266007

Questions Cloud

Calculate the currents in the 3-phase lines : Calculate the currents in the 3-phase lines, neglecting transformer losses. Draw the phasor diagram.
Identify any ethical issues that could impact chosen firm : Identify any ethical issues that could impact your chosen firm. What steps should be taken to handle these issues? - How should your company integrate corporate social responsibility into its marketing plan?
Difference between a normative and positive statement : What is the difference between a normative and positive statement? Can you provide examples as well?
Purchase of inventory with cash affect the ratio : Assuming a current ratio of 1.0, how will the purchase of inventory with cash affect the ratio? A. increase the current ratio B. no change to the current ratio C. decrease the current ratio D. could either increase or decrease the current ratio
How to calculate charges if user returns the book late : How to calculate charges if user returns the book late? How to determine the book condition/depreciation? Provision of scanning the barcode instead of entering the data manually.
Movement along the same demand curve for product : What happens to the demand curve and the supply curve when any of these determinants change? What would cause a change in demand versus a movement along the same demand curve for this product?
Uses weighted average with a periodic inventory system : During 2012, a company sells 300 units of inventory for $85 each. the company has the following inventory purchase transactions for 2012: DATE TRANSACTION NUMBER OF UNITS UNIT COST TOTAL COST jan. calculate ending inventory and cost of goods sold for..
Balance sheet for its investment in burke corporation : Gilman Company purchased 100,000 of the 250,000 shares of common stock of Burke Corporation on January 1, 2009, at $40 per share as a long-term investment. The records of Burke Corporation showed the following on December 31, 2009:  balance sheet for..
Declare linked list that will hold the elements in the stack : Create a new class named GenericStack that specifies a type variable that provides for generics. Declare a linked list that will hold the elements in the stack. Then, use the linked list to implement the methods listed above.

Reviews

Write a Review

Database Management System Questions & Answers

  Build relatively well normalized relational database

If we added hats in 3 sizes and 3 colors and 3 styles, discuss briefly how many additional tables you 'uld add to the design.

  Construct a relational schema for the er-diagram

Construct a relational schema for the ER-diagram. Make sure that you correctly translate Specialization and Many-to-Many relationships. Please follow carefully the following guidelines when you ?nish this question.

  Analyze the business activity

Data Files needed for this Case Problem: OBrien.accdb (cont. from Tutorial 3) and Tests.bmp O'Brien Educational ServicesKaren O'Brien is using the OBrien database to track and analyze the business activity of her educational consulting company. T..

  Physical schema created for a database

At this point in the design process, you would have a detailed physical schema created for a database. How would you approach converting your schema into a database, complete with sample data? Explain your approach in two to three paragraphs.

  Data mining tools predict future trends and behaviors

Data mining is the retrieval of information from databases, It is a powerful new technology designed to help companies focus on the most important information in their data warehouses. Data mining tools predict future trends and behaviors.

  1distinguish between the terms lsquoerp implementation and

1.distinguish between the terms lsquoerp implementation and lsquoerp configuration2.explain the purpose of the entity

  Write steps to follow to create the relational database

Write down short description of database connectivity with Internet using one of widely disseminated technologies. (that is using either active server pages or Java server pages or others).

  What do you understand by data analytics

Watch the 36-minute video on ‘Data Analytics at Facebook' at www.youtube.com/watch?v=D19.JiG-Ow9g or http://bit.ly/1Vk0r3K or tinyurl.com/facebook-data-analytics, What do you understand by data analytics

  Define relational databases

In this Discussion Board, you are asked to define and describe background information of a relational database. Include the following information.

  Determine the cartesian product of sets

Determine the Cartesian product (A X B) of the given pair of sets. A => Set of first letter of names of countries = A = { R, S, T } B => Set of numbers denoting Postal codes = B = { 0001, 1001}.

  Develop a use case for each of the major processes

Develop a Use Case for each of the major processes and create the context diagram for the system described.

  What is the primary key for each entity

Are there any multivalued attributes shown? If so, discuss how it/they should be handled in the implementation of the relational database.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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