Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello. I am doing some Database Management work and need some help with some questions. Thank you in advance! 1.) For the following ER diagram

Hello. I am doing some Database Management work and need some help with some questions. Thank you in advance!

1.) For the following ER diagram choose the correct rational schema

image text in transcribed

a.)CREDIT_REQUEST(request_id, request_date, Requesting_Party_Name, Credit_Check_id)

CREDIT_CHECK(Credit_Check_id, Credit_Check_date, Credit_Rating)

b.)CREDIT_REQUEST(request_id, request_date, Requesting_Party_Name)

CREDIT_CHECK(Credit_Check_id, Credit_Check_date, Credit_Rating, request_id)

c.)CREDIT_REQUEST(request_id, request_date, Requesting_Party_Name)

CREDIT_CHECK(Credit_Check_id, Credit_Check_date, Credit_Rating)

CREDIT_CHECK(Credit_Check_id, request_id)

-------------------------------------------------------------------------------------------------------------------------------------

2.) For the following ER diagram choose the correct rational schema

image text in transcribed

a.)EMPLOYEE(Emp_No, Emp_Name, Emp_Title, Emp_Date_of_Birth)

DEPENDENT(Dep_name, Dep_Relationship, Dep_Age)

b.)EMPLOYEE(Emp_No, Emp_Name, Emp_Title, Emp_Date_of_Birth)

DEPENDENT(Emp_No, Dep_name, Dep_Relationship, Dep_Age)

c.)EMPLOYEE(Emp_No, Emp_Name, Emp_Title, Emp_Date_of_Birth)

DEPENDENT(Emp_No, Dep_name, Dep_Relationship, Dep_Age)

d.)EMPLOYEE(Emp_No, Emp_Name, Emp_Title, Emp_Date_of_Birth, Dep_name, Dep_Relationship, Dep_Age)

------------------------------------------------------------------------------------------------------------------------------------------------------------

3.) Create ER Diagram that correctly represents the following business rule:

An account must be either Checking account, or Savings account or Loan Account and can be any combination of the above but it cannot be anything else.

------------------------------------------------------------------------------------------------------------------------------------------------------------

4.) For the following ER Diagram

image text in transcribed

a.)A person can be married to any number of persons but not at the same time

b.)A person can be married to any number of persons even at the same time

c.)A person can be married to any number of persons even at the same time and must be married to at least one person

------------------------------------------------------------------------------------------------------------------------------------------------------------

5.)For the following ER diagram. The business rules that are interpreted are

image text in transcribed

a.)Each person can be either a staff or student(or something else), but not both

b.)Each person must be either a staff or a student, but not both

c.)Each person can be either a staff or a student(or something else) or both

d.)Each person must be either a staff or a student, or both

------------------------------------------------------------------------------------------------------------------------------------------------------------

6.)For the following ER diagram. The business rules that are interpreted are

image text in transcribed

a.)A person can be an Academic staff, a General staff, an Undergraduate Student or a Postgraduate Student. This person cannot be any combination of the above and cannot be anything else

b.)A person can be Academic staff, a General staff, an Undergraduate Student or a Postgraduate student. This person can be any combination of the above and cannot be anything else.

c.)A person can be Academic staff, a General Staff, an Undergraduate Student or a Postgraduate Student. This person cannot be any combination of the above and can also be anything else.

d.)A person can be an Academic staff, a General staff, an Undergraduate Student or a Postgraduate Student. This person can be any combination of the above and can be anything else.

------------------------------------------------------------------------------------------------------------------------------------------------------------

7.)For the following ER diagram. The business rules that are interpreted are

image text in transcribed

a.)Each person can be married to any number of persons

b.)Each person must be married to exactly one person.

c.)Each person may be married to one person or may not be married.

d.)Each person may be married to number of persons or may not be married.

------------------------------------------------------------------------------------------------------------------------------------------------------------

8.) Create an ER diagram for the following

a.)A department may employ any number of persons. A person must be employed by, at most, one department.

b.)A manager manages, at most, one department. A department is managed by exactly one manager.

c.)A team consists of many players (and at least one). A player plays for exactly one team.

d.)A team consists of 5 to 10 players. A player plays for exactly one team.

e.)A lecturer teaches, at most, one course. A course is taught by exactly one lecturer.

f.)A Book in the library may have multiple copies.

g.)A vehicle, which is a land-vehicle or water-vehicle, can be an ocean-vessel, a river-raft, a rail-vehicle or a road-vehicle. If it is a rail-vehicle it cannot be a road-vehicle at the same time. Other options may also exist.

------------------------------------------------------------------------------------------------------------------------------------------------------------

9.) Based on the relational schema that you created for question 8 and only for table BOOK(f). Complete (as many rows as needed) the following table for the Physical schema design.

image text in transcribed

CREDIT CHECK CREDIT REQUEST Uses Cred it Cneck ID Request ID Request Date Requesting Party Name Credit Check Date Credit Hating Used by

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional Microsoft SQL Server 2014 Integration Services

Authors: Brian Knight, Devin Knight

1st Edition

1118850904, 9781118850909

More Books

Students also viewed these Databases questions

Question

What are the key differences between cash and accrual accounting?

Answered: 1 week ago

Question

=+8. Be sure you considered consumer benefits.

Answered: 1 week ago

Question

=+4. Consider competitors' campaigns. How could yours stand out?

Answered: 1 week ago

Question

=+5. Review the six categories of 50 strategies.

Answered: 1 week ago