Question

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 CS253 you are taking is one class instance (i.e. CS253-01), and another CS253 section is another class instance (i.e. CS253-02). And it should also have session information (i.e. 1801A). 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.

Answer 1

For the above-given question following is the Entity-relationship diagram has been made considering the following things.

1. The student,faculty, class/ course has been added
2. Additional subject is also added.

That was a nice question to answer
Friend, If you have any doubts in understanding do let me know in the comment section. I will be happy to help you further.
Thanks