Question: Database systems 2.) (5 POINTS) Consider the following relational database. Specify the probable primary key (PK) for each relation. Justify the reason why you decide

Database systems

2.) (5 POINTS) Consider the following relational database. Specify the probable primary key (PK) for each relation. Justify the reason why you decide that way. Staff (staffLastName, streetNo, street, city, zip) WorksAt (staffLastName, branchName, hourlyPaid, monthlyPaid, salary) Branch (branchName, city) 3. (20 POINTS) Assume following two relations belong to a campus database: student(sid, fname, lname, major, totalCredit) enrolled sid, cid, sectionID, semester, year, grade) What is the corresponding English statement for the following relational algebra expressions? 3.A.) (10 POINTS) Gyear 2016 (enrolled student) 3.B.) (10 POINTS) ? sid, cid, fname, lname (student p enrolled)

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 Databases Questions!

A discrete sequence {xn} can be converted into a continuous representation x(t) = ts X n= (t n ts) xn, where ts is the sampling period. (a) State two characteristic properties of Dirac's function. [2...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Portray in words what transforms you would have to make to your execution to some degree (a) to accomplish this and remark on the benefits and detriments of this thought.You are approached to compose...

Let r and s be solutions to the quadratic equation x 2 b x + c = 0. For n N, define d0 = 0 d1 = r s dn = b dn1 c dn2 (n 2) Prove that dn = r n s n for all n N. [4 marks] (b) Recall that a commutative...

Lesson 12 Quiz (Show/Explain all Work) IST 230 Relations on Sets, Databases 1. Let A = {0, 1, 2, 3, 4, 5, 6, 7, 8} and B = {1, 2, 3, 4, 5, 6, 7, 8}. Now let R be a binary relation R from A to B such...

A creative engineer suggests structuring the TLB so that not all the bits of the presented address need match to result in a hit. Suggest how this might be achieved, and what might be the costs and...

the following relational algebra questions based on tables S1 and S2 (below) Question 1 What is the output of S1 S2 ? The row identified by sid 22 The rows identified by sid 31 and 58 The row...

Suppose that R(A, B, C) is a relational schema with functional dependencies F = {A, B C, C B}. (i) Is this schema in 3NF? Explain. [2 marks] (ii) Is this schema in BCNF? Explain. [2 marks] (b)...

answer the question clearly You are building a flight-control system for which a convincing safety case must be made. Would you assign the tasks of safety requirements engineering, test case...

Briefly describe ASCII and Unicode and draw attention to any relationship between them. [3 marks] (b) Briefly explain what a Reader is in the context of reading characters from data. [3 marks] A...

The Trial Balance should equal $30,250 Adjusted Trial Balance should equal $33,322 Post-Closing Trial Balance should equal $23,325 June 1 Issued 5,000 shares of M & M stock to family and friends...

The current sections of Nasreen Inc.s balance sheets at December 31, 2013 and 2014, are presented here. Nasreens net income for 2014 was $153,000. Depreciation expense was $24,000. Instructions...

When the transaction are few, the seller, while sending the goods on sale or return basis treats them as A ordinary sale B no sale C profit

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

=+1 What is the difference between global remuneration and international assignment compensation?

=+ Based on the answers to the previous questions, what is the overall cost of the assignment, and will the various decision-makers (management and IA) consider that the benefits

=+employee to take on the international assignment?