2. Determine which attributes represent the primary keys and any alternate keys if any are present.

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
icon
Related questions
Question
100%

please help with question 2 this is for Database Systems

100
UA100 145A Brittany
101 Brittany
200
UA100
1 Grand Ave
RESID EMPID ROOM FNAME LNAME START END BLDG ADDRESS
Brightly 2020-01-09 2020-01-09 Baldor 1 Grand Ave
Brightly 2020-01-13 2020-01-14 Baldor
Low 2020-01-05 2020-01-05 MS
2020-02-01 2020-02-07 MS
2020-02-14 2020-02-16 Baldor
300
UA349
John
5 Grand Ave
5 Grand Ave
350
UA852
Ben
Cuervas
400
UA978
Apple
1 Grand Ave
475
UA349
Low 2020-01-20 2020-01-21 Baldor 1 Grand Ave
85
345
101
145A
Mac
John
1. First, start by identifying each of the functional dependencies between the attributes.
2. Determine which attributes represent the primary keys and any alternate keys if any
are present.
3. Determine whether or not the table is presently in third normal form.
4. Demonstrate how you could encounter insertion, deletion, and modification anomalies
on the table provided above.
5. Demonstrate the process of normalization for this table. Clearly represent the entities
in first (1NF), second (2NF), and third (3NF) normal form. Briefly describe what
was accomplished at each level of normalization.
6. Submit an entity relationship (ER) diagram of the schema in third normal form
(3NF) and create these tables within DB2. Submit your SQL with the appropriate
constraints.
Transcribed Image Text:100 UA100 145A Brittany 101 Brittany 200 UA100 1 Grand Ave RESID EMPID ROOM FNAME LNAME START END BLDG ADDRESS Brightly 2020-01-09 2020-01-09 Baldor 1 Grand Ave Brightly 2020-01-13 2020-01-14 Baldor Low 2020-01-05 2020-01-05 MS 2020-02-01 2020-02-07 MS 2020-02-14 2020-02-16 Baldor 300 UA349 John 5 Grand Ave 5 Grand Ave 350 UA852 Ben Cuervas 400 UA978 Apple 1 Grand Ave 475 UA349 Low 2020-01-20 2020-01-21 Baldor 1 Grand Ave 85 345 101 145A Mac John 1. First, start by identifying each of the functional dependencies between the attributes. 2. Determine which attributes represent the primary keys and any alternate keys if any are present. 3. Determine whether or not the table is presently in third normal form. 4. Demonstrate how you could encounter insertion, deletion, and modification anomalies on the table provided above. 5. Demonstrate the process of normalization for this table. Clearly represent the entities in first (1NF), second (2NF), and third (3NF) normal form. Briefly describe what was accomplished at each level of normalization. 6. Submit an entity relationship (ER) diagram of the schema in third normal form (3NF) and create these tables within DB2. Submit your SQL with the appropriate constraints.
Expert Solution
Step 1

" As you have asked for question number 2 among all the questions, so here I am answering only question 2"

 

primary Key:

In a schema, the primary key is the key that is unique for every row. It is a column that contains a unique identifying value for each column. A schema must have a primary key to perform the operations like- insert, update, and delete data from a schema or a database table.

Alternate Key:

A database table or Schema can have more than one column that contains a unique value for each row. In such a case, we select any one column as the primary key and the rest of the keys as the alternate or secondary key. Suppose there are three columns that contain the unique value, then one will be primary and the rest two will be alternate keys.

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Procedures in SQL
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.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education