You have learned some database components such as entities (tables) with attributes (columns/fields) and keys in previous lessons such as Relational Databases, Database Fields and Field Specifications, and Establishing Keys. Now based on the examples in those lessons, you will design a database for CTU, which includes three entities (tables): Students, Faculty, and Classes. Note a class refers to a particular class section. For example, the current CS251 you are taking is one class instance (i.e. CS251-01), and another CS251 section is another class instance (i.e. CS251-02). And it should also have session information (i.e. 1604A).

In summary, create a Word document for your design which includes:

Three entities and each entity should have at least three attributes.

Properly Identify all Primary (Use Solid Underlines) and Foreign Keys (Use Dotted Underlines)

Define all relationships between entities (See examples in Data Model and Database Entities and Relationship Modeling lessons)

Create an entity-relationship diagram (ERD) from the entities. You may use MS Access, SmartDraw, Visio, Erwin, or even PowerPoint or Word to draw the diagram. Take a screenshot (no need if you use Word) and insert it into the Word document.