You have learned some database components such as entities


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 the 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 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.

Request for Solution File

Ask an Expert for Answer!!
Database Management System: You have learned some database components such as entities
Reference No:- TGS02237551

Expected delivery within 24 Hours