Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

While designing a database system for a large enterprise is a highly complex task, designing a small relation database can be fairly straightforward process. For

While designing a database system for a large enterprise is a highly complex task, designing a small relation database can be fairly straightforward process.

For this project, design a relation database to contain about the students, instructions, and class offerings at your school. The database should consist of three tables (one each for the students, class and instructor), and each table should have at least four fields. Select an appropriate primary key for each table and determine which of the tables will be related. On paper, design one input screen, one query screen and one report might be used with this system; annotate each design with the table and field names for each piece of information to be included. Did any of your three designs utilize data from one than one table? If so, make such that it is possible to do that, based on your table and stated relationships. Be sure to include at least one sample record for each table in your design documentation

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

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students also viewed these Databases questions