Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A college wants to store data about students completed courses. Students may complete more than 1 course. Some students may complete the same course. Include

A college wants to store data about students completed courses. Students may complete more than 1 course. Some students may complete the same course. Include the following facts in the database:

Student name

Course instructor

Phone number

Date of birth Email

Student number

Course number

Date Completed

Course name

Date Started

Design a set of relational databases to store these data. Identify the primary key, any needed foreign keys, and non-key attributes.

Table Name

Primary Key

Foreign Keys

Other Attributes

Students

Courses

Students-Courses

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

Computerized Accounting Using QuickBooks Pro 2020

Authors: Alvin A. Arens, D. Dewey Ward, Carol J. Borsum

6th Edition

0912503793, 9780912503790

More Books

Students also viewed these Accounting questions