Create a relational model with foreign and primary keys

Programming Logic & Design Comprehensive
9th Edition
ISBN:9781337669405
Author:FARRELL
Publisher:FARRELL
Chapter7: File Handling And Applications
Section: Chapter Questions
Problem 6PE
icon
Related questions
Question

Create a relational model with foreign and primary keys

Area Code
7 Digit Number
Telephone
Number
Sex
Title
SSN
Salary
Name
Professor
Department
Number
Chair person
College
Degrees
Address
Street Address
Student Adress
Department
Name
Department
Major
City
Student
Telephone
Number
N
Zip Code
Student Records
State
Office Location
Student Last
Name
Department
Telephone
Student Name
Taught
Offered
Contains
CWID
Section Number
N
Units
Student First
Name
Course Number
N
Sections
N
NI
Course Section
Section
Classroom
Course
M
(Course Textbook
Course Title
N
Contains
Enrollment
Records
(Number of Seats
Grade
Meeting Days
Beginning Time
End Time
Prerequisite
Courses
Transcribed Image Text:Area Code 7 Digit Number Telephone Number Sex Title SSN Salary Name Professor Department Number Chair person College Degrees Address Street Address Student Adress Department Name Department Major City Student Telephone Number N Zip Code Student Records State Office Location Student Last Name Department Telephone Student Name Taught Offered Contains CWID Section Number N Units Student First Name Course Number N Sections N NI Course Section Section Classroom Course M (Course Textbook Course Title N Contains Enrollment Records (Number of Seats Grade Meeting Days Beginning Time End Time Prerequisite Courses
Expert Solution
steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Database Development
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Programming Logic & Design Comprehensive
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Enhanced Discovering Computers 2017 (Shelly Cashm…
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning