Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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,500

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

Flash XML Applications Use AS2 And AS3 To Create Photo Galleries Menus And Databases

Authors: Joachim Schnier

1st Edition

0240809173, 978-0240809175

More Books

Students also viewed these Databases questions