original assignment.
Assignment: Case # 11 from Chapter 4 of the textbook
This lab requires that you use Microsoft Visio to complete an Entity Relationship Diagram.
Microsoft Visio is available to you in VLABS or you may decide to obtain the software for your own personal use. Microsoft Visio software is available free of charge through Penn State’s membership in DREAMSPARK. If you are interested in obtaining your own free copy of Visio, please refer to the link Dreamspark under Lesson 01: Introduction Getting Started.
Complete Chapter 4 Case # 11 in the textbook. The case study is titled RC Charter2 Company.
In a Microsoft Word document, provide business rules for part A.
With the use of Microsoft Visio, provide an ERD to include:
1.A title block with a descriptive title, your name, and date.
2.The entities as outlined in the case.
3.Show relationships with crow’s foot.
4.Identify mandatory and optional dependencies
5.Show connectivity for each relationship
6.Show cardinalities
7.Resolve all many-to-many relationships
Attach your Microsoft Word and Visio files to a single submission to the Drop box for Lab # 2.
**Adjusted Assignment** //should be the focus
All —
I\’ve received a number of questions from people regarding the Lab 2 assignment. All IST 210 sections complete the same exercises — and thus this particular lab choice is used across all sections. This is a challenging first ERD experience.
Based on the questions that I have received, I have decided to make the following adjustments to this assignment:
1) Complete 11.a (Definition of business rules). Based on the scenario that you have been given, provide a set of business rules — i.e., what are the realities of the business as expressed in the scenario? See the scenario for a sample format.
2) Going through the scenario, identify the entity types that you feel would need to be modeled within this ERD. Remember that an entity is typically described using nouns, so for this scenario, one potential entity type might be \”Customers\”.
3) Model the relationship (i.e., create an ER diagram) between the following entity types ONLY (not shouting, just no access to italics :)): Customers, Charters, Aircraft, Payment. Make sure to identify appropriate attributes for each (including a PK), and to appropriately describe the cardinalities that exist between the entity types.
If you want to tackle additional relationships, you are welcome to do so — but (unless there are objections) I will primarily focus my grading on the items identified above.
Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]