Question: Designing a Database While designing a database system for a large enterprise is a highly complex task, designing a small relational database can be a

Designing a Database While designing a database system for a large enterprise is a highly complex task, designing a small relational database can be a fairly straightforward process.For this project, design a relational database to contain data about the students, instructors, and class offerings at your school. The database should consist of three tables (one each for students, classes, and instructors), 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 that 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 more than one table? If so, make sure that it is possible to do that, based on your table design and stated relationships. Be sure to include at least one sample record for each table in your design documentation. At the conclusion of this project, submit the completed database design to your instructor. (If you wish, you may imagine a University with ten students, four classes and three Professor and also submit two queries with your answers for the queries)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!