Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SQL class : Desperate need of homework assistance and explanation A database at a college must support the following requirements: For a department, store its

SQL class : Desperate need of homework assistance and explanation

A database at a college must support the following requirements:

For a department, store its number and name.

For an advisor, store his ID number, last name, first name, the department number to which he is assigned. (We will assume an advisor works for only one department, not two or more.)

For a course, store its code and description (for example, MTH110, Algebra and our course CIS452, Structured Query Language).

For a student, store his ID number, first name, and last name.

For each course the student takes, store the course code, the year and semester enrolled, and the grade earned.

Also assume that a student has a single advisor. Advisors each have several students whom they advise, but a student only has one advisor. Be sure to design this relationship into your solution.

Design the database for the preceding set of requirements. Use your own experience as a student to determine and functional dependencies. You will likely have some questions that arise about this fictitious scenario. You can MAKE YOUR OWN ASSUMPTIONS as the answers to these questions, but document these assumptions in writing. For example, lets pretend you have this question burning in your mind Is the StudentID number just like the FacultyID number or are they different? My response to such a question is, You decide and then list the decision as an ASSUMPTION. You can continue making assumptions and documenting them in the space provided. In the real word, a database designer would go visit with the actual people who would be users of the database and ask them about the validity of each item in the ASSUMPTIONS list.

ASSUMPTIONS

StudentID and AdvisorID are similar in structure. For example 000056723 and 884027634 could belong to a student or to an advisor.

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

Knowledge Discovery In Databases

Authors: Gregory Piatetsky-Shapiro, William Frawley

1st Edition

0262660709, 978-0262660709

More Books

Students also viewed these Databases questions

Question

What are the four main financial objectives of a firm?

Answered: 1 week ago

Question

3. Outline the four major approaches to informative speeches

Answered: 1 week ago

Question

4. Employ strategies to make your audience hungry for information

Answered: 1 week ago