List relationship type in terms of cardinality

Assignment Help Database Management System
Reference no: EM131436886

Design a database for public libraries.

John works for an IT service company as a senior database designer. His company just won a few contracts to serve several public library systems within the state of Maryland. Each library system operates independently though John is in charge to design a single database to store information needed for all libraries. Below are some of the data that need to be kept track of.

A. For each library system, the database needs to store library name (e.g. "City of Baltimore Public Libraries" and "City of Annopolis Public Libraries"), phone, and mailing address.

B. Need to store customer information including name, phone, and address.

C. Each library issues it's own library card to its customers. A customer can have multiple library cards, one for each library system. For example, a customer can have both Baltimore library card and Annopolis library card. Need to store library card number (different library systems may issue cards with the same number), PIN, issue date, expiration date, and current balance due if any.

D. A library has many branch locations. Customers visit a branch to check in/check out items. Need to store branch name, phone, address.

E. Different libraries share generic catalog information. A catalog item has general information such as title, description, release/publishing date, edition, publisher. Currently there are two types specific catalog items - book and DVD. Need to track ISBN, total pages, and hardcover/softcover for books. Need to track length and genre for DVDs.

F. Each branch stores and maintains physical items. General information about each physical item can be found by checking catalog. There could be multiple copies for the same title so each copy needs to be stored separately. For each item the database will store copy number, purchase date, and vendor name purchased from.

G. A library card can check out multiple items. Need to keep check of check out date, due date, and return date. A item can be checked out and returned the same day, but cannot be checked out again using the same library card on that day.

Please complete the following tasks to design the database to meet requirements specified. State any relevant assumption you make, but do not add any additional data requirement unless really necessary.

I. Identify entities and attributes. List entity name and attribute names for each entity.

II. Identify relationships among entities. List relationship type in terms of cardinality and specify business rules (e.g. 1:M between Library and Branch: a library has many branches; a branch belongs to one and only one library).

III. For each entity, identify primary key and foreign key if applicable. If you use surrogate key for PK, also specify business unique key (natural key). For FK, also specify parent entity and the matching attribute in parent entity.

IV. Create ERD using crow's foot notation using ER Assistant or Visio. The ERD should incorporate all items mentioned in I, II, and III.

Reference no: EM131436886

Questions Cloud

How much less time does a joint take to set : Find an estimate of an observed setting time for an ambient temperature of 65°F.- How much less time does a joint take to set if the temperature rises by 10°F?
Find an estimate of an observed value y for x : Find expected percentage in employment growth if percentage of product or process innovators is 2%.- Find an estimate of an observed value y for x = 3.5.
Report on the fishing exercise conducted during field camp : A report on the fishing exercise conducted during the field camp, using class results. Details of what is required for this report will be explained during the field camp
Find an estimate of an observed y value for x : Find the expected value of y if the number of headers is 1000.- Find an estimate of an observed y value for x = 1200.
List relationship type in terms of cardinality : John works for an IT service company as a senior database designer. His company just won a few contracts to serve several public library systems within the state of Maryland. Each library system operates independently though John is in charge to d..
Identify a company that is well known for its excellence : Identify a company that is well known for its excellence in the management of technology and innovation. After researching the company's website and on the Internet.
Half-life of a first-order reaction : What is the half-life of a first-order reaction if it takes 4.8´10-3 seconds for the concentration to decrease from 1.33 M to 0.51 M?
Construct a scatter plot for the data : Construct a scatter plot for these data.- Find the estimated regression line. Add a graph of the estimated regression line to the scatter plot in part (a).
Discuss the arguments for and against the concepts of action : Utilizing case law examples, discuss the arguments for and against the concepts of affirmative action and employment at will. Your essay should be 1500 in APA format. Use at least seven credible sources for your essay.

Reviews

Write a Review

 

Database Management System Questions & Answers

  Explain part of the vba program

PAris timezone and the format should be a access database like the one I have sent you. I need the writer to explain part of the VBA program. Tell me if you can do it

  Create a relational model from your er model

Create a relational model from your ER model. All keys should be clearly identified. Demonstrate that your database is in at least 3rd Normal Form. Write the DDL to create the tables for your design.

  Develop two select commands for each table

Develop two SELECT commands for each table. One of the commands for each table should use a WHERE clause to filter the records being returned.

  Characteristics of leasing in client sever architecture

Characteristics of leasing in client sever architecture

  Mention various steps required to draw an e-r diagram draw

mention various steps required to draw an e-r diagram. draw an e-r diagram for student information system. mention all

  Quality and correctness of schema design

Create an ER/EER diagram to represent the conceptual schema described by the above Universe of Discourse - You can use MS Word to draw the Entity Relationship diagram, and then use it for mapping step.

  Describe implement relationship between employees-projects

Describe how you would implement relationship between employees and projects in each of the given scenarios: Many employees can work on given project, but each employee can work on only single project.

  Create website for fashion designer who wants a unique page

There are many creative uses for tables. Imagine that you have been hired to create a Website for a fashion designer who wants a unique page that stands out. Describe how you could use tables to meet this goal.

  Prepare a systems proposal

Prepare a Systems Proposal that includes an executive summary and a problem statement. Refer to the guidelines and recommended format for the systems proposal.

  Identified in the system analysis report

An E-R diagram of your database that clearly shows the primary and foreign keys - Database has minimum number of records in each table as specified in assignment instructions.

  Database implementation in mysql

After receiving 21 different setups, the management of Oak Creek Stadium has decided on the attached ER diagram and instance tables for the development of a database to keep track of its operations.

  Can you say that attribute b defnitely is or is not a key

State the defnition of a lossless-join decomposition with respect to this example. Answer this question concisely by writing a relational algebra equation involving R, R1, and R2.

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