Question
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
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
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
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
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
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
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.
CREDIT CHECK CREDIT REQUEST Uses Cred it Cneck ID Request ID Request Date Requesting Party Name Credit Check Date Credit Hating Used byStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started