GGG University consists of a number of departments. Each department offers several courses. A number of modules make up each course. Students enroll in a particular course and take modules towards the completion of that course. Each module is taught by a lecturer from the appropriate department, and each lecturer tutors a group of students     Specify all needed tables from this case study   Determine for each table the requested attributes and the needed primary key

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter12: Queueing Models
Section: Chapter Questions
Problem 59P
icon
Related questions
icon
Concept explainers
Topic Video
Question

GGG University consists of a number of departments. Each department offers several courses. A number of modules make up each course. Students enroll in a particular course and take modules towards the completion of that course. Each module is taught by a lecturer from the appropriate department, and each lecturer tutors a group of students

 

 

Specify all needed tables from this case study

 

Determine for each table the requested attributes and the needed primary key

GGG University consists of a number
of departments. Each department offers
several courses. A number of modules make
up
each course. Students enroll in a particular
course and take modules towards the completion
of that course. Each module is taught by
a lecturer from the appropriate department, and
each lecturer tutors a group of students
Specify all needed tables from this case study
Determine for each table the requested attributes
and the needed primary key
Transcribed Image Text:GGG University consists of a number of departments. Each department offers several courses. A number of modules make up each course. Students enroll in a particular course and take modules towards the completion of that course. Each module is taught by a lecturer from the appropriate department, and each lecturer tutors a group of students Specify all needed tables from this case study Determine for each table the requested attributes and the needed primary key
GGG University consists of a number
of departments. Each department offers
several courses. A number of modules make
up
each course. Students enroll in a particular
course and take modules towards the completion
of that course. Each module is taught by
a lecturer from the appropriate department, and
each lecturer tutors a group of students
Specify all needed tables from this case study
Determine for each table the requested attributes
and the needed primary key
Transcribed Image Text:GGG University consists of a number of departments. Each department offers several courses. A number of modules make up each course. Students enroll in a particular course and take modules towards the completion of that course. Each module is taught by a lecturer from the appropriate department, and each lecturer tutors a group of students Specify all needed tables from this case study Determine for each table the requested attributes and the needed primary key
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Inventory management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
MARKETING 2018
MARKETING 2018
Marketing
ISBN:
9780357033753
Author:
Pride
Publisher:
CENGAGE L