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 System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Consider the following table Given the above table, determine its stage of normalization and…

A: The given table is in 2NF which consists of Partial dependency of attributes i.e., the non prime…

Q: nformally describe the conditions to be met for a relation to be in Third Normal Form. Describe why…

A: 1. For a relation to be in 3NF, all the functional dependencies should be in form X->Y where X is…

Q: This question is based on the following relation and sample data, where Employee Social Security…

A: Actually, database is a used to stored the data.

Q: Table_1 below has a primary key of column1. Which column(s) from this relation could be a foreign…

A: When designing a relational database, it is important to determine which columns could act as…

Q: NORMALIZATION The table above displays snippet of the monthly loan application report send by all…

A: Answer:

Q: Ņ 5. Table 4-5 shows a shipping manifest. Your assignment is as follows: a. Draw a relational schema…

A: a. Relational Schema and Functional Dependencies:Here is the relational schema for the Shipping…

Q: Answer the following questions based on the functional dependencies for a relation as provided…

A: The key for the given relation is AC_Num. Therefore any functional dependency whose left side is a…

Q: PLZ help with the following: Consider the following relations: Suppliers (Snumber, sname, address)…

A: given relation Suppliers (Snumber, sname, address) Parts (Pnumber, pname, color)…

Q: 2. Part 2 nsider the following database with the below relations: customer-id customer-name…

A: A database is organised collection of data which is capable of performing operations on it. The…

Q: Using normalisation, depict the relationship schema of the 2NF tables. State the respective primary…

A: Here two composite primary key [Order_Num,Supplier_Num] and the non key…

Q: Show all the steps as you perform normalization for each problem up to 3NF. State your final…

A: From looking at table values since there is transitive dependency as Emp_no determines Lcode and…

Q: a) Consider the following EER diagram. Map it to the relational model. Specify the relational schema…

A: A relational schema is a blueprint utilized in database design to represent the records to be…

Q: Convert the following ERD into relational schema. Sh

A: Relational Schema There are three relational tables: Table Customer represents entity Customer with…

Q: Given the relation below named Student_Registration , answer the following questions. S_id…

A: Relational Schema: A relational schema in a database gives a outline of how data is organized in a…

Concept explainers

Enhanced ER Model

The enhanced ER model is an abbreviation for Enhanced Entity-Relationship (EER) model. As you know, the entity-relationship (ER) model is a pictorial illustration of the relationship between various entities of a domain. In the case of a large amount of data with multiple interrelated entities, the ER diagrams become complex and tough to interpret. For such cases, the need for enhancement in the ER model was observed, and thus, the EER model was designed.

Question

2. Given the following relation and example data:
Part_No Description
20 GB Disk
10010
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 Price
Seberang Jaya,
$100
Penang
Subang Jaya,
Selangor
Petaling Jaya,
Selangor
Subang Jaya,
Selangor
Kelana Jaya,
Selangor
Subang Jaya,
Selangor
$90
$220
$290
$310
$2,100

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Use the technique of normalization to validate the structure of your relational schema. Demonstrate that each of your relations is in third normal form (3NF) by displaying the functional dependencies between attributes in each relation. Note, if any of your relations are not in 3NF, this may indicate that your ER model is structurally incorrect or that you have introduced errors in the process of deriving relations from your model.
Please draw an relational ERD with multiplicities and all the attributes based on following description: ( Please identify the primary key in each entity.) An Adult Education Department runs various courses during the daytime and evenings, and at different times of the year. For example, ‘Spanish level 1’ is offered on Monday mornings, Monday evenings or Wednesday evenings, and runs over 25 weeks from October to March. On the other hand, ‘Introduction to Digging Up Your Ancestors’ only runs for 8 weeks, but is offered on Tuesday or Wednesday evenings from October to December, January to March, and April to June, with an optional field week in August. There is always a maximum number of places for each course offering, which is dependent on the individual teacher. For example, ‘Spanish level 1’ on Monday evenings may be limited to 20 places, but on Wednesday evenings the limit may be 25. Each course offering is only taken by one teacher, however teacher may take…
Consider the follow relations’ schemas to answer the following questions: Student (sid, name, level, address) Book(bid, title, author) BorrowedBook(sid, bid, date) 1) Assume that, there are 10,000 Student records stored on 1,000 pages/blocks, 50,000 Book records stored on 5,000 pages, 300,000 BorrowedBook records stored on 15,000 pages, and there are 500 different authors. Find out what is the record size for each of the previous relation?, and what is the blocking factor for each relation?
Which relational process describes a binary relationship? Multiple occurrences of an entity type are bound together by intersection data. A single occurrence of one entity type is associated with intersection data. A single occurrence of one entity type is associated with a single occurrence of another entity type. Multiple occurrences of an entity type are associated with multiple occurrences of another entity type
Informally describe the conditions to be met for a relation to be in Second Normal Form. In terms of functional dependency, describe why the following CUSTOMER_PURCHASE relation is not in second normal form. This table describes every instance of an individual Customer purchasing a Product. How would this relation suffer from Update Anomalies? CUSTOMER_PURCHASE (CUSTOMER_ID, PRODUCT_ID, PURCHASE_DATE, PURCHASE_AMT, PRODUCT_DESCRIPTION, CUSTOMER_NAME) Note the relation’s primary key is underlined