1- Given the following three tables: a) For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. b) Do the tables exhibit entity integrity? Answer yes or no, and then explain your answer. c) Do the tables exhibit referential integrity? Answer yes or no, and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key. d) Identify all the relationships between the tables and describe their type. Table1: Mentee MenteelD Mentee_FN Mentee_Lidate_joined preferred_spec mentee_status 1 John 2 Jane Doe Doe 2022-01-01 Software Development Active 2022-02-01 Web Design Active 3 Alice Smith 2022-03-01 Data Analysis Active 4 Bob Smith 2022-04-01 Project Management Active 5 Maggie Jackson 2022-05-01 Graphic Design Active 6 Alex Williams 2022-06-01 Marketing Active 7 Samantha Jones 2022-07-01 Finance Active 8 Jessica Davis 2022-08-01 Human Resources Active 9 Emily 10 Daniel Wilson 2022-09-01 Business Development Active Moore 2022-10-01 Accounting Active Table2: Booking SessionID MenteelD 1 1 2 4 2 5 2 6 5 5 3 1 3 7 8 8 8 11 10 10 Table3: Session SessionID Date Duration 1 2022-01-01 10:00:00 2 2022-02-01 11:00:00 Sess_Title 01:00:00.0000 Introduction to Software Development Yes 01:30:00.0000 Web Design Fundamentals 3 2022-03-01 12:00:00 01:15:00.0000 Introduction to Data Analysis 4 2022-04-01 13:00:00 01:45:00.0000 Project Management Best Practices 5 2022-05-01 14:00:00 02:00:00.0000 Graphic Design for Beginners 6 2022-06-01 15:00:00 01:30:00.0000 Marketing Strategy 101 7 2022-07-01 16:00:00 01:45:00.0000 Sess Yes No Sess_Rating 3 Yes 4 Yes 5 No 5 Yes 2 Yes 4 Finance for Non-Finance Professionals Yes 8 2022-08-01 17:00:00 01:30:00.0000 Introduction to Human Resources 3 No 4 9 2022-09-01 18:00:00 02:00:00.0000 Business Development Techniques 10 2022-10-01 19:00:00 01:45:00.0000 Accounting Basics Yes 5 Yes 4
1- Given the following three tables: a) For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. b) Do the tables exhibit entity integrity? Answer yes or no, and then explain your answer. c) Do the tables exhibit referential integrity? Answer yes or no, and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key. d) Identify all the relationships between the tables and describe their type. Table1: Mentee MenteelD Mentee_FN Mentee_Lidate_joined preferred_spec mentee_status 1 John 2 Jane Doe Doe 2022-01-01 Software Development Active 2022-02-01 Web Design Active 3 Alice Smith 2022-03-01 Data Analysis Active 4 Bob Smith 2022-04-01 Project Management Active 5 Maggie Jackson 2022-05-01 Graphic Design Active 6 Alex Williams 2022-06-01 Marketing Active 7 Samantha Jones 2022-07-01 Finance Active 8 Jessica Davis 2022-08-01 Human Resources Active 9 Emily 10 Daniel Wilson 2022-09-01 Business Development Active Moore 2022-10-01 Accounting Active Table2: Booking SessionID MenteelD 1 1 2 4 2 5 2 6 5 5 3 1 3 7 8 8 8 11 10 10 Table3: Session SessionID Date Duration 1 2022-01-01 10:00:00 2 2022-02-01 11:00:00 Sess_Title 01:00:00.0000 Introduction to Software Development Yes 01:30:00.0000 Web Design Fundamentals 3 2022-03-01 12:00:00 01:15:00.0000 Introduction to Data Analysis 4 2022-04-01 13:00:00 01:45:00.0000 Project Management Best Practices 5 2022-05-01 14:00:00 02:00:00.0000 Graphic Design for Beginners 6 2022-06-01 15:00:00 01:30:00.0000 Marketing Strategy 101 7 2022-07-01 16:00:00 01:45:00.0000 Sess Yes No Sess_Rating 3 Yes 4 Yes 5 No 5 Yes 2 Yes 4 Finance for Non-Finance Professionals Yes 8 2022-08-01 17:00:00 01:30:00.0000 Introduction to Human Resources 3 No 4 9 2022-09-01 18:00:00 02:00:00.0000 Business Development Techniques 10 2022-10-01 19:00:00 01:45:00.0000 Accounting Basics Yes 5 Yes 4
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
Transcribed Image Text:1- Given the following three tables:
a) For each table, identify the primary key and the foreign key(s). If a table does not have
a foreign key, write None.
b) Do the tables exhibit entity integrity? Answer yes or no, and then explain your answer.
c) Do the tables exhibit referential integrity? Answer yes or no, and then explain your
answer. Write NA (Not Applicable) if the table does not have a foreign key.
d) Identify all the relationships between the tables and describe their type.
Table1: Mentee
MenteelD Mentee_FN Mentee_Lidate_joined preferred_spec
mentee_status
1 John
2 Jane
Doe
Doe
2022-01-01 Software Development Active
2022-02-01 Web Design
Active
3 Alice
Smith
2022-03-01 Data Analysis
Active
4 Bob
Smith
2022-04-01
Project Management
Active
5 Maggie
Jackson
2022-05-01 Graphic Design
Active
6 Alex
Williams
2022-06-01 Marketing
Active
7 Samantha Jones
2022-07-01 Finance
Active
8 Jessica
Davis
2022-08-01 Human Resources
Active
9 Emily
10 Daniel
Wilson
2022-09-01 Business Development Active
Moore
2022-10-01 Accounting
Active
Table2: Booking
SessionID
MenteelD
1
1
2
4
2
5
2
6
5
5
3
1
3
7
8
8
8
11
10
10
Table3: Session
SessionID
Date
Duration
1 2022-01-01 10:00:00
2 2022-02-01 11:00:00
Sess_Title
01:00:00.0000 Introduction to Software Development Yes
01:30:00.0000 Web Design Fundamentals
3 2022-03-01 12:00:00 01:15:00.0000 Introduction to Data Analysis
4 2022-04-01 13:00:00 01:45:00.0000 Project Management Best Practices
5 2022-05-01 14:00:00 02:00:00.0000 Graphic Design for Beginners
6 2022-06-01 15:00:00 01:30:00.0000 Marketing Strategy 101
7 2022-07-01 16:00:00 01:45:00.0000
Sess Yes No Sess_Rating
3
Yes
4
Yes
5
No
5
Yes
2
Yes
4
Finance for Non-Finance Professionals Yes
8 2022-08-01 17:00:00 01:30:00.0000 Introduction to Human Resources
3
No
4
9 2022-09-01 18:00:00 02:00:00.0000 Business Development Techniques
10 2022-10-01 19:00:00 01:45:00.0000 Accounting Basics
Yes
5
Yes
4
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.