Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Solve all three questions. Question 1: An E/R diagram when converted to relations gives rise to the following relations: R(A,B,C)S(A,D)T(D,F,G) You may assume that the
Solve all three questions.
Question 1: An E/R diagram when converted to relations gives rise to the following relations: R(A,B,C)S(A,D)T(D,F,G) You may assume that the same alphabets refer to the same attribute (e.g., the attributes A in the relations R, and S ). What E/R diagram could have produced these relations? Please make sure all constraints are used to derive this schema. Question 2: Draw an E/R diagram to model project groups in CSC430. Keep in mind that each enrolled student (identified by a SID) can work at most one project. Each project is identified uniquely by its name. Be sure to identify all the appropriate multiplicity and referential integrity constraints in the diagram. Indicate key attributes in each entity set. (15 points) Question 3: Consider the relational database whose schema is shown below: EMPLOYEE (Emp-ID, E-name, gender, DOB, disability, health-status) COMPANY (Company-name, tax-ID, company-status) LIVES (Emp-ID, street, city) WORKS (Emp-ID, Company-name, salary) LOCATED_IN (Company-name, city) The primary key for each relation is denoted by the underlined attribute. 1. Write the DDL commands to create the above relations. (7 points) 2. Write the following queries in Relational Algebra: (8 points) a. List the names of all female employees, who work for the 'Ruston Bank' (a unique company name in the database). b. List all the companies who are in located-in the same city of the company 'Ruston Bank'. c. List the name of all employees who work for the 'Ruston Bank'. d. List the personal information of name, street, and city of all employees who work for the 'Ruston Bank' and earn more than $10,500Step 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