Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(50 points) Question2. Consider the university system described below: A course has a unique id, credits, title, and syllabus. Each course can have zero or

image text in transcribed

(50 points) Question2. Consider the university system described below: A course has a unique id, credits, title, and syllabus. Each course can have zero or several courses as pre-requisites. A student has a unique id, name, GPA. A student can be graduate or under- or grad students we store advisor and program. For under-grad students we store year. A student can have several email addresses and each email belongs to one student. Students can enroll in several courses in a semester. A grad student can be the TA of at most one course. A course can have several TAs. A. Design an ER model to capture the above information. B. Change the ER model to include the following: a. Instructors have id-number, name, department, and title. b. Store information about class-sections of a course. We store section- number, year, semester, schedule, and classroom for each class- section. c. Each class-section belongs to only one course, and can be taught by only one instructor. Every course can have zero or several class- sections. Students enroll in class-sections and grades that they received must be stored

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Implementing Ai And Machine Learning For Business Optimization

Authors: Robert K Wiley

1st Edition

B0CPQJW72N, 979-8870675855

More Books

Students also viewed these Databases questions

Question

Good ___________ provides a consistency of message among employees

Answered: 1 week ago

Question

3. Identify cultural universals in nonverbal communication.

Answered: 1 week ago