Question: 2) Below is the school ER diagram. Please answer the following questions using this diagram. (Class 3, objective 1) a) Name all the Entities you

2) Below is the school ER diagram. Please answer the following questions using this

diagram. (Class 3, objective 1)

a) Name all the Entities you see in the ER diagram.

b) Name all the relationships you see in the ER diagram.

c) Name all of the attributes for the INSTRUCTOR entity.

d) Based on the ER diagram, what is the maximum number of instructors we can have for a

single course?

e) Does every instructor need to teach each semester?

f) How many relationships can you find between DEPT and INSTRUCTOR?

g) Name all the composite attributes you see in the ER diagram.

h) How many multi-valued attributes do you see in the diagram?

2) Below is the school ER diagram. Please answer the following questions

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 General Management Questions!

Q:

please solve all parts Consider the following ER diagram and answer the following questions:. ID Name ID Name Custamers Event Cost ID Music Act s ! Shows ID Time Name Type of Music Stage a) (10%) In...

Q:

Old MathJax webview plz solve this..... Assignment 5 - Create a Network Diagram Hide Assignment Information Instructions A network diagram is built from the WBS in any project. It helps us understand...

Q:

In 2014, Dr. Michael Dulin, chief clinical officer for analytics and outcomes research and head of the Dickson Advanced Analytics (DA2) group at Carolinas Health Care System (CHS), was preparing for...

Q:

Please answer the following questions about the Gibson Insurance Company case: 1. Calculate the unit support cost per policy for new and in-force annuity and life insurance policies using the new...

Q:

Please answer the following questions about the Gibson Insurance Company case: 1. Calculate the unit support cost per policy for new and in-force annuity and life insurance policies using the new...

Q:

Answer the following questions using the attached state's CAFR. 1. Explain the difference among non-spendable, restricted, committed, assigned, and unassigned fund balances. 2. Explain how the...

Q:

CASE STUDY Fund Voting in a Proxy Fight Institutional activism takes many forms, as we have seen. In most situations, mutual funds are drawn into the fray by the actions of others. Company management...

Q:

Answer the following questions using the Delaware CAFR. Reference to the page number if possible. 1. Was the state organizational government chart provided? Briefly explain how the state is organized...

Q:

Answer the following questions using the Delaware CAFR. Reference to the page number if possible. 1. Was the state organizational government chart provided? Briefly explain how the state is organized...

Q:

Answer the following questions using the attached Delaware CAFR. 1. In the Basic Financial Statement section, in examining the fiduciary fund Statement of Fiduciary Net Position and Statement of...

Q:

One of the fastest growing industries in the last twenty years is the memory chip industry, which supplies memory chips for personal computers and other electronic devices. Yet the average...

Q:

According to the evaluation results of authoritative organizations, table football may account for more than 20% of the entire sports game market, and the company spends an evaluation fee of 200,000...

Q:

Solve each of the following equations. (a) a(a-9)=0 (c) 5c+25c=0 (e) 4h-16h=0 (g) -x(2x+3)=0 (b) b(b+7)=0 (d) 11d-d-0 (f) 3k-81k2-0 (h)-4y=0

Q:

Problem 8 - 2 7 ( Algo ) Accounts receivable financing [ LO 8 - 1 ] Charming Paper Company sells to the 1 2 accounts IIsted here. \ table [ [ , \ table [ [ Receivable Balance ] , [ Outstanding ] ] ,...