Question: You want to create a database about the books on your shelf. Each book has authors (only the last name is needed), title, publisher, courses

You want to create a database about the books on your shelf. Each book has authors (only the last name is needed), title, publisher, courses used in (course number only). Draw the ER diagram using the Chen-like model, and then write the English description for your diagrams. Compare the English to your diagrams and state any assumptions you made when drawing the diagrams.
Which attributes would you consider composite attributes in this database? Which attributes would you consider multivalued attributes in this database? Could there be any derived attributes? What would be good keys? Map your diagram to a relational database.

Step by Step Solution

★★★★★

3.49 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

THE ENTITY This database records data about BOOKS For each BOOK in the database we record the Author ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Database Design Using Entity Relationship Diagrams Questions!

You want to create a database about businesses. Each business will have a name, address, the business phone number, the owner's phone number ,and the frst names of the employees who work at the...

what is OLAP Operations.

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

You want to create a database about the books on your shelf. Each book has authors (assume that only the last name is needed), title, publisher, courses used in (course number only). Draw the ER...

qns 1: Write Java Code for the following case scenarios: Consider the following class declaration: public class Circle { private double radius; public Circle (double r) { radius = r; } public double...

Identify the output of following Java code. Justify the syntax. File Name:Instuctor.java /** This class stores data about an instructor. */ public class Instructor { private String lastName; // Last...

1 . Requirements 7 : 4 5 PM Sun Jul 2 1 CourseDemo Q Done This class stores data about an instructor. * / public class Instructor { private String firstName; / / First name / * * first name, and...

Unit III Scholarly Activity Unit III Scholarly Activity Assignment Content Hazard Analysis Your boss has asked you to investigate these operations and tasks that he feels have a significant potential...

CS246 Lab 3: Joins and Sub-queries Objectives The objectives of Lab 3 are to: . Create and execute queries involving CROSS, NATURAL, INNER, OUTER, and SELF joins Create and execute queries involving...

Your task is to write an essay that analyzes the article, "Criminalization of Homelessness". Focus your attention on the most important parts, examine them, connect them to the whole, and use that to...

Identify a company with a product that interests you. Consider ways the company could use customer relationship management (CRM) to strengthen relationships with its target market. Specifically,...

What are the CVP assumptions?

Explain how Treasury Department Circular 230 differs from the AICPA's Statements on Standards for Tax Services . (Select all that apply.) Question content area bottom Part 1 A. Circular 230 only...

With respect to evaluating audit evidence, which of the following statements is false? a. The auditor evaluates the evidence gathered and decides whether it supports a favorable or unfavorable...

Suppose we modify the deterministic version of the quick-sort algorithm so that, instead of selecting the last element in an n-element sequence as the pivot, we choose the element at index n/2. What...

Suppose we are given two n-element sorted sequences A and B each with distinct elements, but potentially some elements that are in both sequences. Describe an O(n)-time method for computing a...

Is our linked-list-based implementation of merge-sort (Code Fragment 12.3) stable? Explain why or why not. /** Merge contents of sorted queues S1 and S2 into empty queue S. */ public static void...

The base 10 representation of the largest signed value that can be stored using only 6 bits is: 31 126 63 011111

Amalgamated General Corporation is a consulting firm that also offers financial services through its credit division. From time to time the company buys and sells securities . The following selected...

Intro Samsung has sales of $52,000 and a net income of $16,000. Total assets are $46,000 and total equity is $27,000. The consumer electronics industry as a whole has the following characteristics:...