BuyFindarrow_forward

Database Systems: Design, Implemen...

11th Edition
Steven + 8 others
Publisher: Cengage Learning
ISBN: 9781285196145

Solutions

Chapter
Section
BuyFindarrow_forward

Database Systems: Design, Implemen...

11th Edition
Steven + 8 others
Publisher: Cengage Learning
ISBN: 9781285196145
Chapter 3, Problem 11P
Textbook Problem
21 views

Create the ERD to show the relationship between EMPLOYEE and JOB.

Program Plan Intro

Primary Key:

A Primary Key in a database table is a field in the table that uniquely identifies every row or record present in the database table.

Example:

Students in Universities are assigned a unique registration number.

Therefore, in a STUDENT database table, the attribute “reg_no” acts as primary key.

Foreign Key:

Foreign Key is a column in a relational database table which provides a relation between two tables. It provides a cross reference between tables by pointing to primary key of another table.

Example:

In STUDENT database table, the attribute “reg_no” acts as primary key and in COURSE database table in which the student selects his or her course, the same “reg_no” acts as foreign key for the STUDENT table.

One to Many Relationship:

When one record in a database table is associated with more than one record in another table, the relationship between the two tables is referred as one to many relationship. It is also represented as1: M relationship. This is the opposite of many to one relationship.

ENTITY- RELATIONSHIP DIAGRAM (ERD):

Entity- Relationship Diagram is also known as ER Diagram. It is used to define the conceptual view of the database as viewed by the end user. It is used to depict the database’s main components: entities, relationships and attributes.

CROW FOOT ERD:

The Crow Foot ERD is an Entity Relationship Diagram which is used to represent the cardinalities present in the basic ER diagram. It is used to represent the relationships present between two tuples or tables present in the database.

Explanation of Solution

Given database tables:

Table Name: EMPLOYEE

EMP_CODE EMP_LNAME JOB_CODE
14 Rudell 2
15 McDade 1
16 Ruellardo 1
17 Smith 3
20 Smith 2

Table Name: JOB

JOB_CODE JOB_DESCRIPTION
1 Clerical
2 Technical
3 Managerial

Primary Key and Foreign Key in the above Tables:

For Table Name: EMPLOYEE:

Primary Key: EMP_CODE

“EMP_CODE” acts as primary key of the table because the attribute “EMP_CODE” is a unique ID that is assigned to every employee. It also uniquely identifies every other row present in the database table.

Foreign Key: JOB_CODE

“JOB_CODE” acts as foreign key for the table because the attribute “JOB_CODE” is also present in the table JOB as its primary key. It also provides a link between the two database tables “EMPLOYEE” and “JOB”.

For Table Name-JOB:

Primary Key: JOB_CODE

“JOB_CODE” acts as primary key of the table because the attribute “JOB_CODE” is a unique ID that is assigned to every employee present in the company. It also uniquely identifies every other row present in the database table.

Foreign Key: None

There is no Foreign Key attribute present in the JOB table because there is no attribute in the table except the primary key which is present in any other database table as a primary key...

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Chapter 3 Solutions

Database Systems: Design, Implementation, & Management
Show all chapter solutions
add
Ch. 3 - Create the table that results from applying a...Ch. 3 - Create the table that results from applying an...Ch. 3 - Using the tables in Figure Q3.13, create the table...Ch. 3 - Suppose you have the ERD shown in Figure Q3.18....Ch. 3 - What are homonyms and synonyms, and why should...Ch. 3 - How would you implement a l:M relationship in a...Ch. 3 - Identify and describe the components of the table...Ch. 3 - Identify the primary keys. FIGURE Q3.22 THE...Ch. 3 - Identify the foreign keys. FIGURE Q3.22 THE...Ch. 3 - Create the ERM. FIGURE Q3.22 THE CH03_THEATER...Ch. 3 - Create the relational diagram to show the...Ch. 3 - Suppose you wanted quick lookup capability to get...Ch. 3 - What would be the conceptual view of the INDEX...Ch. 3 - For each table, identify the primary key and the...Ch. 3 - Do the tables exhibit entity integrity? Answer yes...Ch. 3 - Do the tables exhibit referential integrity?...Ch. 3 - Describe the type(s) of relationship(s) between...Ch. 3 - Create the ERD to show the relationship between...Ch. 3 - Create the relational diagram to show the...Ch. 3 - Describe the type(s) of relationship(s) between...Ch. 3 - Create the ERD to show the relationships among...Ch. 3 - Create the relational diagram to show the...Ch. 3 - For each table in the database, identify the...Ch. 3 - Create the ERD to show the relationship between...Ch. 3 - Create the relational diagram to show the...Ch. 3 - Do the tables exhibit entity integrity? Answer yes...Ch. 3 - Do the tables exhibit referential integrity?...Ch. 3 - Create the ERD to show the relationships among...Ch. 3 - Create the relational diagram to show the...Ch. 3 - For each table, identify the primary key and the...Ch. 3 - Do the tables exhibit entity integrity? Answer yes...Ch. 3 - Do the tables exhibit referential integrity?...Ch. 3 - Identify the TRUCK tables candidate key(s). FIGURE...Ch. 3 - For each table, identify a superkey and a...Ch. 3 - Create the ERD for this database. FIGURE P3.17 THE...Ch. 3 - Create the relational diagram for this database....Ch. 3 - For each table, identify each of the following...Ch. 3 - Create the ERD. (Hint: Look at the table contents....Ch. 3 - Create the relational diagram. FIGURE P3.24 THE...Ch. 3 - Modify the ERD you created in Problem 25 to...Ch. 3 - Create the relational diagram for the design you...Ch. 3 - Create the table that would result from applying...Ch. 3 - Create the table that would result from applying...Ch. 3 - Create the table that would result from applying a...

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
Show solutions add
Explain why database design is important.

Database Systems: Design, Implementation, & Management

What design characteristics determine the voltage and the current capacity of a battery?

Automotive Technology: A Systems Approach (MindTap Course List)

For Problems 16.29 through 16.32, show the dimensions of the object on its orthographic views. 16.31 All dimens...

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

Define polymorphism, and provide three examples.

Systems Analysis and Design (Shelly Cashman Series) (MindTap Course List)

If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?

A+ Guide to Hardware (Standalone Book) (MindTap Course List)

scanner a. a type of 2-D bar code that stores information in both horizontal and vertical directions b. small, ...

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

What are some skills that entry-level welders need?

Welding: Principles and Applications (MindTap Course List)