Reference no: EM132476971
CP2404 - Database Modelling - James Cook University
Conceptual Database Modelling
This assignment has been designed to assess students' ability to model a database, by constructing an entity-relationship diagram for a particular business scenario. This assignment addresses the following learning objectives for this subject:
• Develop a database model using the entity-relationship model
• Apply the techniques of normalisation
Assignment Task
Question 1) You are to write a brief discussion of your solution, i.e. how you approached the modeling problem and any issues you may have encountered (maximum of ½ page)
Question 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.
Question 3) Based on these business rules*, draw a fully labeled 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 (or other software) to create the ERD. A Hand-drawn ERD will NOT be accepted. A sample ERD can be found in Appendix A of this document. (Note: The ERD created using the drawing tool (e.g. Visio) will need to be saved as an image file and then be included in your document file to be submitted)
Question 4) A summary to describe the major justifications, assumptions and limitations related to your database design. For example:
• Assumption/justifications for optionalitiy, connectivities, constraints data type and data domain; and
• Special cases or data integrity issues that cannot be handled.
Attachment:- Conceptual Database Modelling.rar
IFN711 Industry Project Plan Assignment
: IFN711 Industry Project Plan Assignment help and solution, Queensland University of Technology - assessment writing service - Demonstrate project management
|
Record the transactions for June
: Using the appropriate window, record the following transactions for June 2019: Jun. 18 Provided 4 hours of Internet Consulting Services to the Singh Family
|
Career development services principles
: Cica Professional Standards - How does each of the 7 Standards apply to the following roles and Summarise the 8 guidelines
|
Record each adjusting journal entry separately
: Use the information below to prepare adjusting entries. Record each adjusting journal entry separately, and use June 30, 2019, for the date
|
CP2404 Database Modelling Assignment
: CP2404 Database Modelling Assignment help and solution, James Cook University - assessment writing service - write a brief discussion of your solution
|
CO7212 Game Theory in Computer Science Assignment
: CO7212 Game Theory in Computer Science Assignment help and solution, University of Leicester - assessment writing service - List the max-min strategies
|
Assignment - Financial Accounting Questions
: On June 30, 2015, Martin Co. has assets of $22,000 and owners' equity of $5,000. What is the total of its liabilities on that date
|
FIN 472 Fixed-Income Securities Assignment
: FIN 472 Fixed-Income Securities Assignment Help and Solution - Kogod School of Business, American University, USA. Term Structure of Interest Rates
|
CVE80016 Major Research Project Assignment
: CVE80016 Major Research Project Assignment help and solution, Swinburne University of Technology - assessment writing service - Geotechnical stabilization
|