Ņ 5. Table 4-5 shows a shipping manifest. Your assignment is as follows: a. Draw a relational schema and diagram the functional dependencies in the relation. b. In what normal form is this relation? + c. Decompose MANIFEST into a set of 3NF relations. d. Draw a relational schema for your 3NF relations and show the referential integrity constraints. TABLE 4-5 Shipping Manifest 00-0001 Boston Brazil 39 Shipment ID: Origin: Destination: Ship Number: Item Number 3223 3297 Type BM BM Description Concrete Form Steel Beam Shipment Date: Expected Arrival: Captain: Weight 500 87 Quantity 100 2,000 Shipment Total: 01/10/2010 01/14/2010 002-15 Henry Moore TOTALWEIGHT 50,000 174,000 224,000

Ņ 5. Table 4-5 shows a shipping manifest. Your assignment is as follows: a. Draw a relational schema and diagram the functional dependencies in the relation. b. In what normal form is this relation? + c. Decompose MANIFEST into a set of 3NF relations. d. Draw a relational schema for your 3NF relations and show the referential integrity constraints. TABLE 4-5 Shipping Manifest 00-0001 Boston Brazil 39 Shipment ID: Origin: Destination: Ship Number: Item Number 3223 3297 Type BM BM Description Concrete Form Steel Beam Shipment Date: Expected Arrival: Captain: Weight 500 87 Quantity 100 2,000 Shipment Total: 01/10/2010 01/14/2010 002-15 Henry Moore TOTALWEIGHT 50,000 174,000 224,000

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter2: Data Models

Section: Chapter Questions

Problem 11P

See similar textbooks

Similar questions

What is a relation?
What is the most common method of specifying a primary key in a relational schema description? Group of choice: A. by enclosing the key attributes in parentheses B. by stating the key attributes first in the relation definition C. by writing key attributes in all capital letters D. by italicizing the key attributes E. by underlining the attributes that comprise the primary key
database Assume that you have the following relation; R(a,b,c) a b c ---------- 1 A F 2 B M 3 T F 4 R M 5 A F And S is a relation with one attribute called c and has one tuple with the value 'F". Then the cardinality of R divided by S will be = ----- Select one: a. Non of the mentioned b. 2 c. 1 d. 3
1. The BOOK CHECKOUT relation stores data about books checked out by students at a university. The functional dependencies are given below for this relation. a. Which normal form is this relation in and why? b. Using the normalization steps develop a set of 3NF relations for this view. Describe the relational schema for the 3NF relations that you developed. Be sure to list the referential integrity constraints BOOK CHECKOUT (StudentID, StudentName, StudentPhoneNumer, ISBN, BookTitie, CheckOutDate, ReturnDate) StudentID > StudentName, StudentPhoneNumer ISBN -> BookTitle StudentiD, ISBN ->CheckOutDate, ReturnDate
For developing our queries, we will be using the following relational schema: Student(SID, name, username, major) Course(cname, description, department, weight) Offering(OID, cname, year, term, duration) Enrolled(SID, OID, grade) A course relation is the generic description of a course which is offered by a department. The offering relation is the specific instance of a course being taught in a given term, and is the entity which will be associated with the student enrollment. Students are enrolled in these offerings and achieve a mark. Express each of following queries in Relational Algebra: | Write a relational algebra query which will list the cname and description of all the courses which are being offering in the Fall 2018 term. 2 Write a relational algebra query which will list the name of all the students who have earned 60% in both 'COSC2P12' and 'COSC2P13'.
What is the link between a relation's main key and the functional dependencies among all of its attributes?
Consider the following relations:Album (albumId: integer, title: string, artistId (FK): integer)Artist (artistId: integer, name: string)Composer (artistId: integer, name: string)Singer (artistId: integer, name: string)Write the following queries in relational algebra.(1) Find all the titles of the albums.(2) Find all the tuples whose albumId is 2.(3) Rename the relation Artist to Art and attributes to artId, title.(4) Find all the tuples that are either an Artist or a Composer.(5) Find the tuples of Artists who are not a Composer.(6) Find the tuples of people who are Composer and a Singer at the same time.(7) Find the titles of albums created by the artist ‘Black Sabbath’.
Based on the following table a)Write a 1NF relational schema and identify the partial and transitive dependencies. b)Write the relational schema for 2NF and 3NF.
Write a relational calculus based on the following relations: Professor (ProfID, ProfName, DeptNo) Course (CrsID, CrsName, Credits, DeptNo, ProfID) Department (DeptNo, DeptName) Use tuple relational calculus; 1. List all professor names, who are the owner of the courses named, "Database Design". 2. List all professor names who teach the 3-credit courses provided by the department named "Information Technology".
PART A. Identify all dependencies. PART B. Write Relation Schema to meet 3NF requirements PART C. DRAW CROWS FOOT ERD
Consider the following relational schema:Student (sid, sname, dept)Enroll (cid, sid, grade, semester)Course (cid, cname, dept, credit)Prereq (cid, pid) Write the following queries in Relational Algebra expression: a) For students who have received an A in a course, return name of students and titleof the course. b) Find name and id of students taken at least one of the prerequisite of CS595course and got an A grade in this prerequisite course.
What are three advantages of using a surrogate key rather than the main key to access a relation instead?