Do the tables in figure 1 exhibit entity referential integrity? Why or why not? **Figure 1**This diagram represents a database structure with four tables: EMPLOYEE, BENEFIT, JOB, and PLAN.**Table: EMPLOYEE**- **Columns:** - EMP_CODE: Employee Code - EMP_LNAME: Employee Last Name - JOB_CODE: Job Code- **Rows:** 1. EMP_CODE: 14, EMP_LNAME: Rudell, JOB_CODE: 2 2. EMP_CODE: 15, EMP_LNAME: McDade, JOB_CODE: 1 3. EMP_CODE: 16, EMP_LNAME: Ruellardo, JOB_CODE: 1 4. EMP_CODE: 17, EMP_LNAME: Smith, JOB_CODE: 3 5. EMP_CODE: 20, EMP_LNAME: Smith, JOB_CODE: 2**Table: BENEFIT**- **Columns:** - EMP_CODE: Employee Code - PLAN_CODE: Plan Code- **Rows:** 1. EMP_CODE: 15, PLAN_CODE: 2 2. EMP_CODE: 15, PLAN_CODE: 3 3. EMP_CODE: 16, PLAN_CODE: 1 4. EMP_CODE: 17, PLAN_CODE: 3 5. EMP_CODE: 17, PLAN_CODE: 4 6. EMP_CODE: 20, PLAN_CODE: 3**Table: JOB**- **Columns:** - JOB_CODE: Job Code - JOB_DESCRIPTION: Job Description- **Rows:** 1. JOB_CODE: 1, JOB_DESCRIPTION: Clerical 2. JOB_CODE: 2, JOB_DESCRIPTION: Technical 3. JOB_CODE: 3, JOB_DESCRIPTION: Managerial**Table: PLAN**- **Columns:** - PLAN_CODE: Plan Code - PLAN_DESCRIPTION: Plan Description- **Rows:** 1. PLAN_CODE: 1, PLAN_DESCRIPTION: Term life 2. PLAN_CODE: 2, PLAN_DESCRIPTION: Stock purchase 3. PLAN_CODE: 3, PLAN_DESCRIPTION: Long-term disability 4. PLAN_CODE: 4, PLAN_DESCRIPTION: DentalThis database structure allows for the association of employees with their respective jobs and benefits.

Answered: Do the tables in figure 1 exhibit…

Engineering

Computer Science

Do the tables in figure 1 exhibit entity referential integrity? Why or why not?

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

Similar questions

Please anser this question. Thank you!
Why is the relational model important?
Create an Entity Relationship Diagram (ERD) of the normalized version of this table using Visio's crows-foot notation. The ERD should show the PK and FK columns, plus all of the appropriate column attributes (column name, data type/size, null/not null) plus the relationships (with minimum and maximum cardinality) between tables. Requirements: Show the results of the normalization as individual tables Show the FK and PK columns using Visio's notation You must solve the multi-column issue with grades (Hint: This will require a new column) Show the 3-part column definition as noted Show min/max cardinality Tables are attached
Use a suitable example to provide a thorough description of the relational model.
Describe the difference between how a 1:M unary relationship and an M:N unary relationship are implemented in a relational data model.
What are three reasons for replacing the primary key of a relation with a surrogate key?
What are the most notable differences between abstract classes and interfaces?
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.
Based on the following ER model and business rules, write an SQL statement to create COURSE and COURSE_PREREQ table. Be sure to implement all related data integrity constraint. For each column, use the data type as you think appropriate. Business rule • A course may have more than one prerequisites. The prerequisite courses may have their own prerequisite courses (more than one). COUSE entity • CourseNo is a UID (unique identifier). • Credit hours should be greater than 0 and less than 7. COURSE_PREREQ entity • UID is the composite of CourseNo and CourseNo (i.e., prerequisite courseNo). COURSE COURSE_PREREQ CourseNo: UID Title Description CourseNo: LCourseNo: UID CreditHours
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?
When should you use a surrogate key instead of the main key in a relation, and provide three examples?
Convert the M:N relationship below into 1:M relationships. List the relational schema for the entities (you can add attributes to each entity). For each entity, clearly indicate the primary key and foreign key, if any. An author may write several books, and a book may have several authors.