Question: 9.1 Entity-Relationship Diagrams We previously discusses a database that had two entities, COURSE and INSTRUCTOR. Course has attributes, book, course no, course name, credits with

9.1 Entity-Relationship Diagrams

We previously discusses a database that had two entities, COURSE and INSTRUCTOR. Course has attributes, book, course no, course name, credits with TEACH as a relationship to INSTRUCTOR which has attribiutes date hired, instructor name, instructor ssno, department and school.

"Book" was left as an attribute of COURSE. Extend the database to include book as an entity. Attributes of book are title, author, price, edition and publisher. Explore the relationship that might exist here: use"in" or "by", "write", "teach", and so on. Draw an ER diagram with at least two relationships, one of them ternary. What would be some attributes of the relationships?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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 Databases Questions!

Chapter concentrates on ER Diagrams with Binary Relationships. In Chapter 8, we described a database that had two entities, COURSE and INSTRUCTOR. Book was left as an attribute of COURSE. Extend the...

Draw E-R (Entity-Relationship) diagrams only for each problem. A.) A company has a number of employees. The attributes of EMPLOYEE include Employee ID (identifier), Name, Address, and Birthdate. The...

1 . Entities: Entities are objects or concepts that you want to store information about in your database. In this database, we have four entities: Student: This entity stores information about...

Database design and technology As a database developer, you have been asked to design a new database the operation of the new project within the Liverpool John Moores University (LJMU). LJMU is...

Database course, I need the answer for numbers six, seven and eight, please Assignment 4: Database Implementation Introduction So far this semester, we have focused on database design tools such as...

. You are asked to design a database system for ABC companys training program. Your model will be used by an application that will meet the expected database requirements for the company. Business...

The EER diagram should show all the necessary details, including entities, attributes, primary keys, relationships, and relationship cardinalities. Make sure that all items are properly depicted and...

Exercise Q1: Regarding the following scenario and the main concepts read the presented requirements and answer the questions: Entities of a mini world relationships can have attributes, operations,...

the concept of minimum cardinality, or the minimum number of entities required in any given relationship is a difficult concept to grasp. Let me try to walk through an example that I hope will help....

"Millenium Institute of Information Technology" (MIIT) needs a database. MIIT is an Information Technology (IT) institute with hundreds of students. It is necessary to keep track of all the different...

Part A Which of the following could be the structure of C HO? Oa O b C Submit Request Answer H H H-C-C-C H H 0 4 O-H H b H H 0 H-C-0-C 2 T H O-H H-O H H H-C-0-C-H O-H

Discuss the use of entity-specific information in the generation of fair value numbers under IFRS 13

Discuss with a partner or as a class why the following products would not make 'good' money. Try to rank these in order of how many functions of money these products meet. Remember to justify your...

An investor buys a 9\% annual-pay bond maturing July 15, 2020 on September 6, 2013, (51 days after the coupon date using a 30/360 day-count convention). The bond's yield to maturity is 8%. How much...

15-2 What are the alternative strategies for developing global businesses?

3. Ask exactly how you would be using Microsoft Office tools in your job.

15-1 What major factors are driving the internationalization of business?