Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Design using Microsoft word - an ERD that can be implemented for a College System, using the following requirements The College database keeps track of

  1. Design using Microsoft word -an ERD that can be implemented for a College System, using the following requirements

The College database keeps track of colleges professors, Students, Classes, Rooms, and Courses. Suppose that, after the requirements collection and analysis phase, the database designers stated the following description of the "Tiny College", the part of the company to be represented in the database: Professors are identified by SSN, and their names, specialty, years of experience and also their permanent addresses. We should be able to search about the city, state, and zip code of the Professor's permanent address and by the professor's last or first name. Some Professors manage other Professors. A professor may teach classes, but each class is taught by one professor. We need to store a class code, time, and day. Student has a unique number, name, major, birth date, and hobbies. A class may contain many students, and each student may take many classes. Each course has a code, name, credit hours. Course may generate many classes, but each class references a single course. A class requires one room, each has a room number, single location, max capacity, and each room may also be scheduled for many classes.

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

Database Processing Fundamentals, Design, and Implementation

Authors: David M. Kroenke, David J. Auer

14th edition

133876705, 9781292107639, 1292107634, 978-0133876703

More Books

Students also viewed these Databases questions

Question

=+management system of the MNE?

Answered: 1 week ago