·On slide #34, describe and draw a diagram to illustrate how you link the three tables: File: Student-profile contains your first name, last name, first-enrolled-date, social- security-number, and student-id. File 'Student-courses' contains a list of courses, and term taken, professor for each course that a student has taken 1. 2. File: Student-grades: This file contains a grade for each course that a student has 3. 20takenuong Pham. All Rights Reserved. May not be scanned, copied
·On slide #34, describe and draw a diagram to illustrate how you link the three tables: File: Student-profile contains your first name, last name, first-enrolled-date, social- security-number, and student-id. File 'Student-courses' contains a list of courses, and term taken, professor for each course that a student has taken 1. 2. File: Student-grades: This file contains a grade for each course that a student has 3. 20takenuong Pham. All Rights Reserved. May not be scanned, copied
Principles of Information Systems (MindTap Course List)
13th Edition
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter12: System Acquisition And Development
Section: Chapter Questions
Problem 3PSE: A new sales ordering system needs a relational database that contains a customer table, a product...
Related questions
Question
Transcribed Image Text:Review: Linking Data Tables to
Answer an Inquiry
Data Table 1: Project Table
Project number Description
Dept. number
155
Payroll
257
498
Widgets
632
226
Sales manual
598
Data Table 2: Department Table
Dept. number Dept. name
Manager SSN
257
Accounting
005-10-6321
632
Manufacturingl 549-77-1001
598
Marketing
098-40-1370
Data Table 3: Manager Table
SSN
Last name
First name
Hire date
Dept. number
005-10-6321
Johns
Francine
10-07-2013
257
549-77-1001
Buckley
Bill
02-17-1995
632
098-40-1370
Fiske
Steven
01-05-2001
598
© 2013-2019 Cengage learning. All Rights Reserved. May not be copied, scanned,
duplicated, in whole or in part, except for use as
permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
32
TBC – Instructions:
Linking your tables together
On slide #34, describe and draw a diagram
to illustrate how you link the three tables:
File: Student-profile contains your first
name, last name, first-enrolled-date, social-
security-number, and student-id.
1.
2.
File 'Student-courses' contains a list of
courses, and term taken, professor for each
course that a student has taken
3.
File: Student-grades: This file contains a
grade for each course that a student has
e 20takenuong Pham. All Rights Reserved. May not be scanned, copied
or duplicated, or posted to a publicly accessible website, in whole or in part.
33
TBC – Linking your tables together
Put your answer here
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning