Learning outcomes covered
LO1. Understand the database concepts and components
LO2 Develop a logical database design.
LO3 Implement a physical database for a given requirement
LO4 Test and document databases
Scenario and the Tasks
Read the following Scenario and assume that you have assigned to design and implement a robust Database System forFootball or Soccer Team Players and Fixtures scenario.
The following data model is designed to hold information relating to Teams, Players and Fixtures for a Football or Soccer Team. For this scenario we need to define the following facts:
These facts define the requirements which the Database must meet and should be agreed between the Database User and the Database Designer prior to physical creation.
The draft facts have been defined as:
The Entities required should include:
§ Teams
§ Players
§ Fixtures
§ Player Positions
§ Competitions
The Entities are related as follows:
§ One Team can have Many Players
§ One Player can play in Many Fixtures
§ One Fixture has Many Players
With this design, One Team has many Players; however a Player can only play for One Team at any one time. The relationship between Players and Fixtures in a Many-To-Many relationship. One Player can play in zero, one or Many Fixtures, and the Fixture involves Many Players. The link table between this relationships also allows you to record whether a Player scored any Goals in that particular Fixture.
Note: Mention your valid assumptions clearly.
Tasks:
Design the database with the constraint that the available technology is relational.
1. Explain what is data model, critically compare different data models and explain why older data models are being replaced by new data models. (LO1)(10 Marks)
2. Critically explain the benefits and limitations of different database technologies
.(LO1)(5 Marks)
3. Analyze and briefly explain the different approaches to database design.(LO1)(5 Marks)
4. Draw an entity relationship diagram for given scenario with proper standards. Identify important keys and represent different types of attributes and relationships. (LO2)(10 Marks)
5. Draw Relational Schemas. Effectively map conceptual data models with relational database schema according to the mapping algorithm. All the steps should be clearly mentioned. (LO2)(10 Marks)
6. Create the database using SQL server. (LO3)Practical submission and Demonstration(10 Marks)-Demonstration
7. Write 10 SQL queries for given requirements using SELECT Statements. (LO3)Practical submission and Demonstration(5 Marks) Demonstration
8. Generate the suitable management reports for database by using graphical format. (LO3)(5 Marks) -Demonstration
9. Explain the purpose and benefits of having queries in the database for the Tourist industry with the examples. (LO3) (10 Marks)
10. Provide the Test plan, test strategy and proper test cases and provide all the test documents. (LO4)(10 Marks)
11. Create the user manual for the database. (LO4)(5 Marks)
12. Explain how verification and validation has addressed in your data base and the access rights to various types of users.(LO4)(5 Marks)
13. Provide a well-structured documentation including proper academic style and Referencing and in-text citation using Harvard Referencing System. (10 Marks)
Criteria | Marks |
Out of 10 | |
Fail Not explained the data model. Not compared enough data models. Not given proper reasons for the replacement.
| 0-4 |
Pass Explained the data model. Compared minimum 3 data models. Not provided enough/Proper reasons to replace the older data models
| 4-6 |
Good Explained the data model. Compared minimum 5 data models. Provided proper reasons to replace the older data models | 6-7 |
Excellent Well explained about the data model. Critically compared different 5 data models.Well explained why the older data models are being replaced by new data models |
Task-2contains 5 marks
Criteria | Marks |
Out of 5 | |
Fail Provided a poor explanation. Not provided the enough examples
| 0-1 |
Pass Provided a brief explanation of different database technologies
| 1-3 |
Average Design/ Good
Provided a brief explanation of different database technologies with the evaluation also.
| 3-4 |
Excellent Design Critically explained the benefits and limitations of different database technologies with proper examples |
Task-3contains 5 marks
Criteria | Marks |
Out of 5 | |
Fail Not analyse properly the different approaches. Not explain the different approaches
| 0-1 |
Pass Analysed the different approaches. Not provided the proper explanation.
| 1-3 |
Average / Good Analysed the different approaches using enough features. Provided the proper explanation with examples
| 3-4 |
Excellent Design WellAnalyzed and briefly explained the different approaches to database design with proper examples and figures also. |
Task-4contains 10 marks
Diagram should be evaluated according to the following criteria.
Criteria | Marks |
Out of 10 | |
Fail Poor logical database design. · Include incorrect Entities · Include incorrect Attributes and Relationships · Not used proper /standard symbols
| 0-4 |
Pass Develop a logical database design. Entity Relationship Diagram · Identification of correct Entities · Identification of correct Attributes and Relationships
| 4-6 |
Average Design/ Good
· Clear identification of Entities, Attributes and Relationships · Correct use of ERD notations with minor mistakes
| 6-7 |
Excellent Design
standard symbols · Proper theories and techniques need to apply in ERD · Use Chen & Martin notations for ERD |
Task-5contains 10 marks
Criteria | Marks |
Out of 10 | |
Fail In correct Relational Schema · Not identified the correctEntities Attributes and Relationships
| 0-4 |
Pass Relational Schema · Identification of correct Entities · Identification of correct Attributes and Relationships
| 4-6 |
Average Design/Good
· Clear identification of Entities, Attributes and Relationships · Correct use of Relational Schema notations with minor mistakes
| 6-7 |
Excellent Design · Relational Schemawith proper standard symbols · Proper theories and techniques need to apply in Relational schema · Relational Schema for ERD state the primary key foreign key concept correctly
| 7-10 |
Task-6contains 10 marks
Criteria | Submit WorksAll SamplesLatest SolutionLatest AssignemntsLatest ReviewsOur Top ExpertsHolding a PhD degree in Finance, Dr. John Adams is experienced in assisting students who are in dire need... 55 - Completed Orders Canada, Toronto I have acquired my degree from Campion College at the University of Regina Occuption/Desi... 52 - Completed Orders Even since I was a student in Italy I had a passion for languages, in fact I love teaching Italian, and I... 102 - Completed Orders To work with an organization where I can optimally utilize my knowledge and skills for meeting challenges... 109 - Completed Orders JOB OBJECTIVE Seeking entry level assignments in Marketing & Business Development with an organization... 202 - Completed Orders Current work profile Project manager- The Researchers Hub (2nd Jan 2016 to presently working) Researc... 20 - Completed Orders Sales Assistant, Mito Marina Assigned to the Stationery dept – assisted in merchandising, stock taking... 100 - Completed Orders Personal Profile Dedicated and highly experienced private chauffeur. High energy, hardworking, punctua... 200 - Completed Orders I'm Lizzy, full time education specialist in English, Essay Writing, Economics and Maths. Having Assi... 109 - Completed Orders |