So, here is what I would like you to do: 1. Click on Seligman on Flourishing(https://www.youtube.com/watch?v=e0LbwEVnfJA) and watch the video in which he gives you a short, but comprehensive explanat
MSIS-802 Assignment 2
Assignment Instructions
Assignment: Assignment 2 (cover chapter 4 to 6 topics). Instructions:
Some examples of plagiarism would be:
Copying from a source even with stating the reference.
Copying from a source without referencing it correctly.
Using a quote from another person's work without quotations marks and a reference.
Changing a few words from someone else's work and using it in your assignment without referencing it correctly.
Completely copying someone else's work and presenting it as your own assignment.
1
MSIS-802 Assignment 2
Assignment Questions Qustion 1: (12 marks)
Use the following scenario to create an ER diagram data model. Make your model by using any suitable tool. A handwritten design is also accepted. Your homework can be submitted either as jpeg, pdf or Word document.
Consider the following note:
Design an ER diagram to capture the requirements provided in the following scenarios.
Use the Crow’s Foot ERD.
Write all the business rules that are reflected in the scenario.
State any assumptions you have that affects your design.
Make sure that you design includes a well presented entities, attributes, primary keys, relationships, cardinalities.
Use a representative names for all elements of your ER diagram. Scenario: “Fun & Run” is a tour company. The company asks you to design its database. The company offers different tour packages for its customers in different cities. Each package involves different events. An event has a name, date, start time and last for a fixed duration of time. There are different types of events (e.g. historical, sport, attraction, ... etc.). Each type associated with age group and its suitability for family or individual. The customers can buy multiple tickets for any package they like. The ticket includes the total price. The company assigns one of its employee to manage and guide a package. The salary of the employee will be calculated based on the total hours he spent in guided his customers. The company keep records of the personal and communication information of all employees. “Fun & Run” provide an access to its club for the registered dependent of its employees.
2
MSIS-802 Assignment 2
Question 2: (12 marks)
Develop an ER diagram data model, Make your model by using any suitable tool. A handwritten design is also accepted. Your homework can be submitted either as jpeg, pdf or Word document.
The ER must cover the follwing concepts:
Specialization Hierarchy
Disjoint Constraints
Subtype Discriminator
Overlapping Constraints
Completeness Constraint o partial completeness o total completeness After developing the ER diagram data model using the using the Crow’s Foot ERD. specifiy all the business rules, relationships degrees and cardinalties. Please do not use any examples form the textbook. (end)
