2. Given the following relation and example data: Part_No Description 10010 20 GB Disk 10220 256 MB RAM card 10440 17" LCD Monitor Supplier_No 124 112 213 112 125 112 Supplier_Name Seagate IBM Kensington IBM Sun Microsystems IBM a) List the functional dependencies in this relation. b) Convert this relation into a set of 3NF relations. SupplierAddress Seberang Jaya, Penang Subang Jaya, Selangor Petaling Jaya, Selangor Subang Jaya, Selangor Kelana Jaya, Selangor Subang Jaya, Selangor Price $100 $90 $220 $290 $310 $2,100

2. Given the following relation and example data: Part_No Description 10010 20 GB Disk 10220 256 MB RAM card 10440 17" LCD Monitor Supplier_No 124 112 213 112 125 112 Supplier_Name Seagate IBM Kensington IBM Sun Microsystems IBM a) List the functional dependencies in this relation. b) Convert this relation into a set of 3NF relations. SupplierAddress Seberang Jaya, Penang Subang Jaya, Selangor Petaling Jaya, Selangor Subang Jaya, Selangor Kelana Jaya, Selangor Subang Jaya, Selangor Price $100 $90 $220 $290 $310 $2,100

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter11: Database Performance Tuning And Query Optimization

Section: Chapter Questions

Problem 19P

See similar textbooks

Similar questions

Normalise the following relation to remove modification anomalies showing all steps for 1NF, 2NF and 3NF . State any necessary assumptions to support your answer. Important : Provide appropriate justification for each normalisation step. STUDENTCOURSE(StudentNumber, StudentName, TotalCredits, GPA, AdvisorNumber, AdvisorName, Office, CourseNumber, CreditHours, Grade) Primary Key: StudentNumber, CourseNumber Functional DependenciesStudentNumber -> StudentName, TotalCredits, GPA, AdvisorNumber, AdvisorName, OfficeAdvisorNumber -> AdvisorName, OfficeCourseNumber -> CreditHoursStudentNumber, CourseNumber -> Grade
Database Systems Question 3. A relation R is given which is R(A,B,C,D,E). It has the following functional dependencies: BC -> ADE , D -> B. Answer the following based on this information. Which normal forms does this relation satisfy? Which type of dependencies violates BCNF? Is this relation in BCNF? If not, is it possible to decompose it to BCNF?
DATABASE SYSTEMS 16.Consider a relation R = (A,B,C,D,E) with the following functional dependencies: {C,E → D, D → B, C → A} and identify a candidate key. None of them {C,E,D} {C,E,B} {C,E} 17.A join in which tuples from R1 that do not have matching values in the common attributes of R2 are also included in the result relation. R1 left outer join R2 R1 semi join R R1 equi join R2 R1 natural join R2 18.When two transactions that access the same database items have their operations interleaved in a way that makes the values of some database items incorrect this problem is call? none of them dirty read summary problem the lost update problem 19.Protect the database from inconsistencies and data loss Database recovery Database Transaction & Concurrency control Concurrency control Concurrency control & Database recovery 20.Let E1 and E2 be two entity types in an entity relationship diagram. E1 have all three simple single-valued attributes while E2 have two simple…
Consider the following relations: Employee(E_id: integer, E_name: string, Age: integer, Salary: real) Works(E_id: integer, Dep_id: integer, Start_date: date) Department(Dep_id: integer, Dep_name: string, Budget: real, Manager_E_id: integer) What referential integrity constraints exist between these relations? What are the options for enforcing these constraints when a user attempts to delete a Dept tuple?
Please don not reject. It is not graded TABLE 5.36 ASSIGNMENT (EmployeeNumber, ProjectNumber, ProjectName, HoursWorked)Assume that ProjectNumber determines ProjectName, and explain why this relation is not normalized. Demonstrate an insertion anomaly, a modification anomaly, and a deletion anomaly. Apply the normalizationprocess to this relation. State the referential integrity constraint. TABLE 5.37 ASSIGNMENT (EmployeeNumber, ProjectNumber, ProjectName, HoursWorked)Assume that ProjectNumber determines ProjectName, and explain why this relations not normalized. Demonstrate an insertion anomaly, a modification anomaly,and a deletion anomaly. Apply the normalization process to this relation. State thereferential integrity constraint. QUESTION Explain the difference between the two ASSIGNMENT tables in exercises 5.36 and 5.37. Under what circumstances is the table in exercise 5.36 more correct? Under what circumstances is the table in exercise 5.37more correct?
In a database, there are values a data element can take, and there are values it cannot take. In other words, data element values should be within correct ranges. For example, ages of employees should be between 18 and 80. Which one of the following database features ensures that? a) Security b) Data Integrity c) Data Sharing d) Concurrency Control e) Data Independence Which one/ones of the following uniquely distinguishes the tuples of a relation? a) primary key b) super key c) candidate key d) alternate key e) foreign key f) a, c, and e g) a, b, c, d, and e. h) a, b, c, and d. Which one(s) of the following may exist more than once for a relation? a) primary key b) super key c) candidate key d) alternate key e) foreign key f) a, b, and c g) b, c, and d h) b, c, d, and e h) a, b, c, and d. i) a, b, c, and e j) a, b, c, d, and e. In the…
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 for a library database: Book (Title, Author, Catalog_no, Publisher, Year, Price, bookCoverType, contractDate) Collection (Title, Author, Catalog_no) Assume {Author, Title} is the key for both relations Additional functional dependencies are Title,Author --> Catalog_no Catalog_no --> Publisher, Year, bookCoverType Publisher, bookCoverType --> Price Author --> contractDate a) Explain what normal form the relation is in. b) Apply normalization until the 3rd State reasons behind each normalization
Consider the following relation for published books:BOOK (Book_title, Authorname, Book_type, Listprice, Author_affil, Publisher)Author_affil refers to the affiliation of the author. Suppose the following dependencies exist:Book_title → Publisher, Book_typeBook_type → ListpriceAuthor_name → Author-affil (a) What normal form is the relation in? Explain your answer.(b) Apply normalization until you cannot decompose the relations further. State the reasons behind eachdecomposition.
20. A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation. a. Referential b. Referencing c. Specific d. Primary
Let us consider the following relational database. Students(stuID, lastName, firstName, major, gpa) Faculty(facID, name, deptName, rank) Classes(classNhmber, facID, schedule, room) Enrolls(stuID, classNumber, grade) The primary keys are underlined. The referential integrity constraints are as follows: The column facID of relation Classes that references table Faculty, The column of stuID of relation Enrolls that references table Students, and The column classNumber of relation Enrolls that references table Classes. The following SQL statement is intended to define the table Students. However, this statement does not work correctly. CREAT TABLE Students( lastName VARCHAR(20), firstName VARCHAR(20), major VARCHAR(40) gpa DECIMAL(3,2), PRIMARY KEY(stuID)); However, this statement does not work correctly. Briefly explain why and list the corrected SQL statement.
Consider the following relation with functional dependencies as shown below.R{sno,sname,age,cno,cname,group}R(A,B,C,D,E,F)A-B,CC-FD-Ewhich normal form is the relation R is in?

SEE MORE QUESTIONS

Recommended textbooks for you

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS