+91-9519066910
USA: +1(585)6662225, IN: +91-7503070001, IN:+91-9519066910

Assignment

Computing Skills Assignment Help

Matlab Assignment Help

HND in Computing and Software Engineering

Rating:
HND in Computing and Software Engineering

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. 

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.

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

  • 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

 

 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

Details

  • Number of views:
    59
  • PRICE :
    AU$ 150.00
Security Code  
Urgent Assignment Help

Our Top Experts


Karen Betty

Holding a PhD degree in Finance, Dr. John Adams is experienced in assisting students who are in dire need...

55 - Completed Orders


Daphne Lip

Canada, Toronto I have acquired my degree from Campion College at the University of Regina Occuption/Desi...

52 - Completed Orders


Mr Roberto Tuzii

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


Harsh Gupta

To work with an organization where I can optimally utilize my knowledge and skills for meeting challenges...

109 - Completed Orders


ARNAB BANERJEE

JOB OBJECTIVE Seeking entry level assignments in Marketing & Business Development with an organization...

202 - Completed Orders


KARAN BHANDARI

Current work profile Project manager- The Researchers Hub (2nd Jan 2016 to presently working) Researc...

20 - Completed Orders


Tan Kumar Ali

Sales Assistant, Mito Marina Assigned to the Stationery dept – assisted in merchandising, stock taking...

100 - Completed Orders


Wesenu Irko

Personal Profile Dedicated and highly experienced private chauffeur. High energy, hardworking, punctua...

200 - Completed Orders


Lizzy Darley

I'm Lizzy, full time education specialist in English, Essay Writing, Economics and Maths. Having Assi...

109 - Completed Orders


CRYSTAL

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

202 - Completed Orders