Reference no: EM131174200
Database Modelling - ERD Modelling Assignment
Rationale
This assignment has been designed to assess students' ability to model data, by constructing an entity-relationship diagram for a particular business scenario. This assignment addresses the following learning objectives for this subject:
- Perform conceptual modelling using Entity-Relationship Diagrams (ERDs)
- Discuss business assumptions which affect data modelling. Model a database using the entity-relationship (ER) model and understand the database development process
- Use the techniques of normalization
Tasks
1. You are to write a brief discussion of your solution, i.e. how you approached the modelling problem and any issues you may have encountered (maximum of ½ page).
2. You are to write all applicable business rules necessary to establish entities, relationships, optionalities, connectivities, cardinalities and constraints. If a many-to-many relationship is involved, state the business rules regarding the bridging entities after breaking down the many-to-many relationship. An example business rules format can be found in Appendix A of this document.
3. Based on these business rules,* draw a fully labelled and implementable Entity-Relationship Diagram (ERD). Include all entities, relationships, optionalities, connectivities, cardinalities and constraints. You must use Crow's foot notation and MS Visio to create the ERD (a hand-drawn ERD will NOT be accepted).
4. A summary to describe the major justifications, assumptions and limitations related to your database design. For example:
a. Assumption/justifications for optionalitiy, connectivities, constraints data type and data domain; and
b. Special cases or data integrity issues that cannot be handled.
Attachment:- Assignment.rar
|
What is the marginal benefit
: if the total benefit is 200 and total cost is 30. What is the marginal benefit, marginal cost and net benefit?
|
|
Write paper about unauthorized migration
: Write paper about unauthorized migration. - The first part is Introduction: The second part is background: - The third part is migration organization;- The fourth part is Policy Recommendation.
|
|
Compute the drag exerted on the vehicle
: Compute the drag exerted on the vehicle by the bar when the vehicle travels at 65 mph through still air at - 20°F
|
|
Market economies as economic systems
: 1. ‘Command economies will always be inferior to free market economies as economic systems'. To what extent do you agree with this statement? Elaborate.
|
|
Discuss business assumptions which affect data modelling
: Perform conceptual modelling using Entity-Relationship Diagrams (ERDs). Discuss business assumptions which affect data modelling. Model a database using the entity-relationship (ER) model and understand the database development process
|
|
Evaluate the likely economic effects for countries
: Evaluate the likely economic effects for countries, such as Poland and Russia, that have transformed their economies away from the command economy system towards a market economy.
|
|
Identify the career goals for which you are preparing
: Describe the most likely ways in which technological developments will affect those career goals, in both the short- and long-term future. Develop an educational plan to help you reach those goals.
|
|
National-level challenges can impact on local businesses
: List a few major challenges YOU THINK would impact the future economic well-being of the United States. Explain how these national-level challenges can impact on local businesses in your locality.
|
|
Author main point or argument
: Prepare a one to two page analysis of the economics article below. Be sure to include the topic as it relates to economics (elasticity, supply and demand), the author's main point or argument, and your analysis of the author's conclusions.
|