# Assignment

Computing Skills Assignment Help

### HND in Computing and Software Engineering

Rating:

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

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.

### Football 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.

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

 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

 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.

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 Highly detailed diagram Backed by relevant assumptions ERD with cardinality and attributes with proper standard symbols ·         Proper theories and techniques need to apply in ERD ·         Use Chen & Martin notations for ERD

 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

Criteria

#### Details

• Number of views:
82
• PRICE :
AU\$ 150.00

### Our Top Experts

Holding 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

HSC PREPARATION I specialise in English coaching programs for HSC students. My personalised and results-...

202 - Completed Orders