Normalize Table (Problem 6.5) | California State University, Northridge - Edubirdie

University:
California State University, Northridge
Course:
COMP 440 | Database Design
Academic year:

2024
Views:

213

Pages:

3
Author:

Riley K.

Dependency Diagram ITEM_ID ITEM_LABEL ROOM_NUMBER BLDG_CODE BLDG_MANAGER BLDG_NAME Transitive ITEM PK Relational Schema ITEM_ID ITEM_LABEL ROOM_NUMBER BLDG_CODE BLDG_NAME BLDG_MANAGER Dependency Diagram (3NF) ITEM_ID ITEM_LABEL ROOM_NUMBER BLDG_CODE BLDG_NAME EMP_CODE EMP_CODE EMP_LAST_NAME EMP_FIRST_NAME BLDG_CODE EMP_INITIAL Relational Schema (3NF) EMPLOYEE PK BUILDING EMP_CODE PK EMP_LAST_NAME ITEM BLDG_CODE PK ROOM_NUMBER EMP_FIRST_NAME FK ITEM_ID ITEM_LABEL EMP_CODE ROOM_NUMBER EMP_INITIAL FK BLDG_CODE ERD EMPLOYEE PK EMP_CODE BUILDING (1,1) (1,N) PK EMP_LAST_NAME EMP_FIRST_NAME EMP_INITIAL FK BLDG_CODE ITEM (1,1) (0,N) PK ITEM_ID BLDG_NAME ITEM_LABEL EMP_CODE ROOM_NUMBER FK BLDG_CODE

Related Documents

Normalize Table (Problem 6.5)

Normalize Table (Problem 6.5) - Page 1

Normalize Table (Problem 6.5) - Page 2

Normalize Table (Problem 6.5) - Page 3

of 3

Recommended Documents

Quiz 1 - Introduction to Database Systems

Quiz 1 - Introduction to Database Systems

California State University, Northridge COMP 440 | Database Design

Answer Key

Quiz 3 - The Relational Database Model

Quiz 3 - The Relational Database Model

California State University, Northridge COMP 440 | Database Design

Answer Key

Quiz 5 - Advanced Data Modeling

Quiz 5 - Advanced Data Modeling

California State University, Northridge COMP 440 | Database Design

Answer Key

Quiz 10 - Database Performance Tuning and Query Optimization

Quiz 10 - Database Performance Tuning and Query Optimization

California State University, Northridge COMP 440 | Database Design

Answer Key

CREATE TABLE & INSERT statement (Problems 8.16-8.19)

CREATE TABLE & INSERT statement (Problems 8.16-8.19)

California State University, Northridge COMP 440 | Database Design

Assignment

CREATE TRIGGER & PROCEDURE statement (8.26-8.30)

CREATE TRIGGER & PROCEDURE statement (8.26-8.30)

California State University, Northridge COMP 440 | Database Design

Assignment

Query optimization (Problems 11.11-11.14)

Query optimization (Problems 11.11-11.14)

California State University, Northridge COMP 440 | Database Design

Assignment

Quiz 8 - Advanced SQL

Quiz 8 - Advanced SQL

California State University, Northridge COMP 440 | Database Design

Answer Key

Transaction management (Problem 10.1)

Transaction management (Problem 10.1)

California State University, Northridge COMP 440 | Database Design

Assignment

Create ERD (Problem 5.3)

Create ERD (Problem 5.3)

California State University, Northridge COMP 440 | Database Design

Assignment

Quiz 7 - Introduction to SQL

Quiz 7 - Introduction to SQL

California State University, Northridge COMP 440 | Database Design

Answer Key