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
|
|
|
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
