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, or 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. File 'Student-courses' contains a list of courses, and term taken, professor for each course that a student has taken File: Student-grades: This file contains a grade for each course that a student has e zotakenong Auong 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

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

Related questions

Question

Liking your tables together

Transcribed Image Text:Review: Linking Data Tables to Answer an Inquirv 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. numbe Dept. name Manager SSN 257 Accounting 005-10-6321 632 Manufacturing 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, or 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 © 20taKeuong 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

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions