Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Answer these questions please. 1-Draw the Relational Schema for the relationship(s) between STORE and REGION. 2-Draw the Relational Schema for the relationship(s) between EMPLOYEE and STORE 3-Draw the Full Entity Relationship diagram showing the relationships among EMPLOYEE, STORE, and REGION

Answer these questions please. 1-Draw the Relational Schema for the relationship(s) between STORE and REGION. 2-Draw the Relational Schema for the relationship(s) between EMPLOYEE and STORE 3-Draw the Full Entity Relationship diagram showing the relationships among EMPLOYEE, STORE, and REGION

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

Answer these questions please.

1-Draw the Relational Schema for the relationship(s) between STORE and REGION.

2-Draw the Relational Schema for the relationship(s) between EMPLOYEE and STORE

3-Draw the Full Entity Relationship diagram showing the relationships among EMPLOYEE, STORE, and REGION

Table name: EMPLOYEE EMP_CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP DOB STORE_CODE Mr. Viliamson John 21-May-64 2 Ms. Ratula Nancy 09-Feb-69 3 Ms. Greenboro Lottie 02-Oct-61 4 4 Mrs. Rumperstro Jennie 01-Jun-71 5 5 Mr. 6 Mr. 7 Mr. 8 Ms. 9 Mr. Smth Robert 23-Nov-59 3 Cary Roberto Renselaer A 25-Dec-65 1 Ogalo IS 31--62 Johnsson Eizabeth 10-Sep-68 Eindsmar Jack 19-Apr-55 2 10 Mrs. Jones Rose R 06-Mar-66 4 11 Mr. Broderick Tom 21-Oct-72 12 Mr. Washington Alan 08-Sep-74 25-Aug-64 25-May-66 13 Mr. Smth Peter 14 Ms. Smth Sherry Howard H 4 15 Mr. Olenko 24-May-64 5 16 Mr Archialo Borry 03-Sep-60 17 Ms. Grimaldo Jeanine K 12-Nov-70 4 18 Mr. Rosenberg Andrew D 24-Jan-71 4 19 Mr. Rosten Peter 03-Oct-68 4 20 Mr Mckee Robert 06-Mar-70 21 Ms. Baumann Jennifer A 11-Dec-74 Table name: STORE STORE CODE STORE NAME STORE_YTD_SALES REGION_CODE EMP_CODE Access Junction $1,003,455.76 $1,421,987.39 $986,783.22 $944,568.56 $2,930,098.45 8 2 Database Corner 2 12 3 Tuple Charge 7 4 Attribute Alley 2 3 5 Primary Key Point 15 Table name: REGION REGION_CODE REGION_DESCRIPT East 2 West Figure 1.1 Question 1 Tables
Transcribed Image Text:Table name: EMPLOYEE EMP_CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP DOB STORE_CODE Mr. Viliamson John 21-May-64 2 Ms. Ratula Nancy 09-Feb-69 3 Ms. Greenboro Lottie 02-Oct-61 4 4 Mrs. Rumperstro Jennie 01-Jun-71 5 5 Mr. 6 Mr. 7 Mr. 8 Ms. 9 Mr. Smth Robert 23-Nov-59 3 Cary Roberto Renselaer A 25-Dec-65 1 Ogalo IS 31--62 Johnsson Eizabeth 10-Sep-68 Eindsmar Jack 19-Apr-55 2 10 Mrs. Jones Rose R 06-Mar-66 4 11 Mr. Broderick Tom 21-Oct-72 12 Mr. Washington Alan 08-Sep-74 25-Aug-64 25-May-66 13 Mr. Smth Peter 14 Ms. Smth Sherry Howard H 4 15 Mr. Olenko 24-May-64 5 16 Mr Archialo Borry 03-Sep-60 17 Ms. Grimaldo Jeanine K 12-Nov-70 4 18 Mr. Rosenberg Andrew D 24-Jan-71 4 19 Mr. Rosten Peter 03-Oct-68 4 20 Mr Mckee Robert 06-Mar-70 21 Ms. Baumann Jennifer A 11-Dec-74 Table name: STORE STORE CODE STORE NAME STORE_YTD_SALES REGION_CODE EMP_CODE Access Junction $1,003,455.76 $1,421,987.39 $986,783.22 $944,568.56 $2,930,098.45 8 2 Database Corner 2 12 3 Tuple Charge 7 4 Attribute Alley 2 3 5 Primary Key Point 15 Table name: REGION REGION_CODE REGION_DESCRIPT East 2 West Figure 1.1 Question 1 Tables
Expert Solution
steps

Step by step

Solved in 2 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS