07 Jun Database System Assignment 1
Question
Read the attached set of user requirements and create an Entity Relationship diagram using UML notation. To receive full credit for this assignment, your diagram must be well organized and include:
- Each main entity type, labeled with an appropriate name and a designated primary key
- Attributes of each entity type
- All relationships between entities, each labeled with an appropriate name
- Multiplicity constraints clearly identified for each relationship
- All assumptions made when interpreting the requirements
You may use any software with drawing capabilities (e.g., Microsoft Word, LucidChart, or Visio) to complete this assignment
Below are the criteria that will be used to evaluate the performance of your work on Assignment 1 (Entity Relationship Model). Level 4 indicates that all requirements have been met and that you have demonstrated a strong understanding of the Entity Relationship Model. Level 1 indicates that many requirements are missing or incomplete and that you lack a general understanding of the major concepts. Directly below each requirement and the evaluation criteria is the point value awarded for the performance level. For each requirement, the criteria that most closely matches your work product will be the performance level (and points) awarded. The maximum score for this assignment is 90 points. Late submission of assignments will be assessed a penalty of 10% per day. Assignments more than two days late will not be accepted and will receive 0 points.
| Requirement | Level 4 | Level 3 | Level 2 | Level 1 |
| Entities | Every entity is labeled with an appropriate name and a primary key. There are no missing and/or extra entities that are not stated in the requirements. | Every entity is accurately labeled and has a primary key defined. However, there are 1-2 missing and/or extra entities relative to the requirements. | There are several missing and/or extra entities relative to the requirements. Several entities lack a primary key or have been labeled inappropriately. | Most entities, their labels, and primary keys listed in the diagram do not correspond to the requirements. |
| 18 Points | 18 | 16 | 14 | 12 |
| Relationships | Every relationship is named. There are no missing or extra relationships that do not fit either the requirements or assumptions made. | There are several missing and/or extra relationships. Several relationships are poorly labeled. | There are many missing and/or extra relationships. Many relationships are poorly labeled. | Most relationships are missing or there are an unusual number of extra relationships. |
| 18 Points | 18 | 16 | 14 | 12 |
| Multiplicity (Cardinality and Participation) | Multiplicity is provided for every relationship, on both sides of the relationship. | There is more than one multiplicity that is either missing or wrong. This includes cardinalities that are labeled backwards. | There are many multiplicities that are wrong or missing. | Most multiplicities are missing or do not match requirements. |
| 18 Points | 18 | 16 | 14 | 12 |
| Assumptions | All assumptions are clearly stated and implemented. No assumptions conflict with requirements. | Assumptions have been made about the requirements, but not explicitly stated. | Assumptions are stated, but not implemented in the design. | Unnecessary assumptions are made that do not fit the requirements or implementation. |
| 18 Points | 18 | 16 | 14 | 12 |
| Clarity of Presentation | The diagram uses UML notation, is easy to read, and the designer’s intent is made clear. | The diagram uses UML notation but is difficult to read due to the poor organization of entities. | UML notation is not correctly used and the diagram is difficult to read. | The diagram is unreadable or illegible. |
| 18 Points | 18 | 16 | 14 | 12 |
| Total Points | 90 | 80 | 70 | 60 |
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.