OPTION #2: COLLEGE DATABASE ERD
A small college needs a database system designed. The design starts with e visualized conceptualization carried by an entity-relationship diagram (ERD). Create this ERD by completing the following steps:
- Identify all involved in the database system so your ERD accurately “captures” the entire process, actors, and relationships (e.g., faculty, students, staff, courses, facilities, etc.
- Identify and list entities and attributes for each entity.
- Make sure you designate an attribute to serve as a primary key per each entity. Explain why that attribute “deserves” to be designated a primary key.
- Briefly define business rules. (Example: One instructor can’t teach more than one class at a time.)
It is important that you have a clear understanding of key concepts such as entity, attribute, primary key, foreign key, referential integrity, relationships, ERD, etc., before starting to work on the assignment.
Entity – Room
Attributes: Room Number (Primary Key), Capacity, Building, Accessibility, etc.
The ERD should be created using one of the following options:
- Draw using a free drawing tool available online, such as SmartDraw or Lucid Chart
- Draw using software you already own, such as Visio or Argo UML .
- Draw by hand and take a snapshot with a camera.
It is not important how you draw the diagram, as long as it effectively conceptualizes the database system design and “captures” the system accurately. The diagram must be imported or inserted into a Word document and accompanied by an APA-formatted cover page. Review the rubric in the Module 3 folder for specific grading criteria.
Do you need help with this assignment? Or a different one? We got you covered.