Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →Using Microsoft Visio. Create an ERD schema based on the following requirements for a simple college database.
Identify all the entities, relationships and attributes. State the cardinality of the relationship in each case. If you don’t think enough information is available to define either of these, state an assumption that makes it clear.
Problem Statement:
A college wants to track its departments, majors, faculty members, and students. The college has many departments. Each department has many faculty members, but each faculty is affiliated with one and only one department. A department has a department name. A faculty member has last name, first name, highest degree earned, title and email.
Each major has a name and description. Some departments do not offer any major, but some departments offer multiple majors.
Each student needs to declare at least one major at the beginning of the first year. A student has last name, first name, email, and class year. Additionally, each student is advised by a faculty member, but not all faculty members advise students.
Task:
Draw all entities with their attributes into Tables. Draw relationships, cardinality and finish the ERD.
*Help Getting Started: Identify the entities and attributes
Submission Status
| Attempt number |
This is attempt 1. |
| Submission status |
No attempt |
| Grading status |
Not graded |
| Grading criteria |
| Professionalism |
| Diagram presents a professional appearance. It could be shared with a “real-world” customer without changes.
3points
|
Diagram largely presents a professional tone. It could be shared with a “realworld” customer with minor revisions.
2points
|
Diagram is unprofessional. Major revisions would be necessary before sharing the document with a “realworld” customer.
1points
|
Not professionally completed or work not submitted.
0points
|
|
| Entity Sets |
|
Diagram captures all entity sets necessary for a database that would satisfy the initial problem statement.
3points
|
Diagram captures most entity sets necessary for a database that would satisfy the initial problem statement.
2points
|
Diagram captures few or none of the entity sets necessary for a database that would satisfy the initial problem statement.
1points
|
Not completed correctly or work not submitted.
0points
|
|
| Attributes and Keys |
|
Diagram captures all attributes and primary keys necessary for a database that would satisfy the initial problem statement.
3points
|
Diagram captures most attributes and primary keys necessary for a database that would satisfy the initial problem statement.
2points
|
Diagram captures none or few of the attributes and primary keys necessary for a database that would satisfy the initial problem statement.
1points
|
Not completed correctly or work not submitted.
0points
|
|
| Notation |
|
Diagram uses an appropriate E-R notation. The notation is used correctly for all elements of the diagram.
3points
|
Diagram uses an appropriate E-R notation. The notation is used correctly for most elements of the diagram.
2points
|
Diagram does not use an appropriate E-R notation or uses a notation incorrectly for most or all elements.
1points
|
No notation or work not submitted.
0points
|
|
| Relationships |
|
Diagram captures all relationships necessary for a database that would satisfy the initial problem statement.
4points
|
Diagram captures most relationships necessary for a database that would satisfy the initial problem statement.
3points
|
Diagram captures none or few of the relationships necessary for a database that would satisfy the initial problem statement.
1points
|
Not completed correctly or work not submitted.
0points
|
|
| Constraints |
|
Diagram captures all cardinality and participation constraints necessary for a database that would satisfy the initial problem statement.
4points
|
Diagram captures most of the cardinality and participation constraints necessary for a database that would satisfy the initial problem statement.
3points
|
Diagram captures none or few of the cardinality and participation constraints necessary for a database that would satisfy the initial problem statement.
1points
|
Not completed correctly or work not submitted.
0points
|
|
|
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds