FIND A SOLUTION AT Academic Writers Bay
Edith Cowan UniversitySchool of Business and LawMAN6905 Database and Business Intelligence (Individual)Assignment 1 – Data ModellingSemester 2 2021
This individual assignment contributes 30% to your final grade.
Unit Learning Outcomes
ULO 1 Construct a data model using a standard methodology
Data ModellingYour task is to read your assigned case study carefully and create a Data Model that complies withReferential Integrity and being in Third Normal Form.Stage 1 – Requirement Gathering (Due Date: 12/8/2021, no later than 12:30pm)1• Read your assigned case study carefully.• Identify all possible “things” that are related to the construction of your ERD.• Examine the “things” and identify all possible entities.• Examine the remaining “things” and categorise them according to the entities identified.• Validate and remove all irrelevant entities and attributes.• Report the above findings by completing the following table.
1. All Possible Things
2. Possible Entities
3. Categorise attributes according to the entities identified
4. A list of entities and attributes after validation
1 You must schedule a 5 mins meeting with your lecturer (ideally during the consultation). During the meeting,your lecturer will comment on your submission.• Submit a single MS Word document to include the completed table via Blackboard by 12/8/2021(no later than 12:30pm).2Stage 2 – EDR Draft (Due Date: 19/8/2021, no later than 12:30pm)3• Based on the entities and attributes identified in Stage 1, develop an Entity Relationship Diagram(ERD)4, and a Relational Model that comply with Referential Integrity and being in Third NormalForm.• Submit a single MS Word document to include your ERD and Relationship Model via Blackboardby 19/8/2021 (no later than 12:30pm)5.Stage 3 – Research Report (Due Date: 29/8/2021, no later than 23:59:59)• Submit a single MS Word document (via Blackboard and Turnitin) to include the following by29/8/2021 (no later than 23:59:59)6.– Your refined ERD and Relational Model (based on the comments provided by your lecturer).– Appropriate Business Rules or Assumptions that you have made.2 No mark is allocated to Stage 1 submission but your Stage 3 submission will only be given 50% of the originalresult if you do not submit in Stage 1.3 You must schedule a 5 mins meeting with your lecturer (ideally during the consultation). During the meeting,your lecturer will comment on your submission.4 Your submitted ERD must use the notation specified in the lectures and labs, i.e., a combination of Chen andCrow’s foot notations.5 No mark is allocated to Stage 2 submission but your Stage 3 submission will only be given 50% of the originalresult if you do not submit in Stage 2.6 Your submitted ERD must use the notation specified in the lectures and labs, i.e., a combination of Chen andCrow’s foot notations.Marking Criteria
Entity– Entity mistakes includemissing an essentialentity, having anexcessive orunreasonable entity andusing incorrect namingconvention
Most entities areincorrect – make morethan 5 mistakes.
Some entities are correct– make 4-5 mistakes.
Some entities are correct– make 2-3 mistakes.
Most entities are correct– make only 1 mistake.
All entities are correct –make no mistake or onlyone minor mistake.
Attribute– Attribute mistakesinclude missing anessential attribute,having an attribute thatcause an anomaly, havingan excessive orunreasonable attributeand using incorrectnaming convention
Most attributes areincorrect – make morethan 9 mistakes
Some attributes arecorrect – make 7-9mistakes
Some attributes arecorrect – make 4-6mistakes.
Most attributes arecorrect – make 3-5mistakes.
All attributes are correct– make 0-2 mistakes.
Relationship– Relationship mistakesinclude having aredundant relationship,having an excessive orunreasonablerelationship, missing anoptional/mandatoryrelationship, havingincorrectoptional/mandatoryrelationship and havingincorrect cardinality
Most relationships areincorrect – make morethan 5 mistakes.
Some relationships arecorrect – make 4-5mistakes.
Some relationships arecorrect – make 2-3mistakes.
Most relationships arecorrect – make only 1mistake.
All relationships arecorrect – make nomistake or only oneminor mistake.
Mapping to RelationalModel
Most mappings areincorrect – make morethan 18 mistakes.
Some mappings arecorrect – make 13-18mistakes.
Some mappings arecorrect – make 7-12mistakes.
Most mappings arecorrect – make 3-6mistakes.
All mappings are correct– make less than 3mistakes.
- Assignment status: Already Solved By Our Experts
- (USA, AUS, UK & CA PhD. Writers)
- CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS
QUALITY: 100% ORIGINAL PAPER – NO PLAGIARISM – CUSTOM PAPER