Docstoc

dad

Document Sample
dad Powered By Docstoc
					                                BTEC HIGHER NATIONAL DIPLOMA
                                                  Assignment



Institute Name                : IDM Computer Studies Pvt. Ltd.

Unit Name                     : Data Analysis and Design

Unit                          : Unit 13

Assignment Title              : Understanding and Analysis, Design and Implementation of
                                Database system.

Date given                    : 10th May 2010

Date to be submitted          : 20th July 2010

Lecturer                      : Mr. T. Shanakr



Rational

The objective of this assignment is to assure that the students have gained the relevant knowledge
according to the outcomes specified in the syllabus.



Assessment requirements to meet learning outcomes


   1. Understand data models and database technology
   2. Design a relational database to meet user requirements
   3. Use manipulation and query tools and techniques
   4. Implement and test database design.




                                          IDM/HND/Data Analysis and Design            Page 1 of 5
ASSESSMENT CRITERIA

                                                                                       Feedback
Criteria for PASS                        Possible evidence
                                                                                       Y N      Comments
P13.1.1 Provide evidence to support
an understanding of different data       Identify a range of data models and explain
models. Compare and contrast             their structure. (Task 1.1)
different data model structures and
examine their contribution to
database development
P13.1.2 Examine case material that       Analysis and Description about data mining
focuses on developments such as data     and where house. (Task 1.2)
mining and data warehousing
P13.1.3 Analyze the different            Discuss about different approaches and
approaches to database design            produce report (Task 1.3)

P13.2.1 Apply data analysis and
design techniques to develop a fully      Identify UNF data set and normalize up to
relational database with minimum of      3NF. (Task 2.1)
six tables

P13.2.2 Verify that a design meets       Design a logical database design minimum 6
user requirements and provide            tables. (Task 2.2)
justification of the database design
P13.2.3 Use a range of database tools
and techniques to demonstrate a more     Identification of user requirements and
advanced level of understanding and      description of achievement. (Task 2.3)
application

P13.3.1 Incorporate query
language/languages into the database     use of query languages and visual tools for
design                                   database maintenance. (Task 3.1)
P13.3.2 Use a range of visual tools to   Develop a sample interface system.
enhance the database design              (Task 3.2)
P13.3.3 Demonstrate the extraction
                                         Develop a fully working database system.
of meaningful data through the use of
                                         (Task 3.3)
query tools

P13.4.1 Provide documentation to         Identification of data requirements from
support the database implementation      different user view. (Task 4.1)
P13.4.2 Demonstrate ways in which        Look at issues such as verification and
the database has considered the areas    validation techniques. Look at different
of verification and validation           ways of testing. (Task 4.2)
P13.4.3 Evaluate a range of testing      Description about 3 types of anomalies
techniques and apply one to your         (Insertion, Deletion and pupation
own database design                      anomalies). (Task 4.3)




                                                 IDM/HND/Data Analysis and Design                     Page 2 of 5
                                                                                    Feedback
Grade Descriptors for MERIT
                                                                                    Y    N     Comments
M1 Identify and apply strategies to      Clear idea about Data models, Data
find appropriate solutions               mining and where house.
M2 Select / design appropriate           Clear understanding of logical database
methods / techniques                     design (Normalization).
M3 Present and communicate               Clear understanding about Query tools
appropriate findings                     and techniques.


                                                                                    Feedback
Grade Descriptors for DISTINCTION
                                                                                    Y    N     Comments
D1 Use critical reflection to            Clear idea about Data models, Data
evaluate own work and justify valid      mining and where house and use of
conclusions                              examples.
D2 Take responsibility for               Clear understanding of relational
managing and organising                  database, logical database design and
activities                               use of normalization technique.
D3 Demonstrate convergent / lateral /    Implementation of database system
creative thinking                        using query tools and techniques.




Task 01

1.1 Write a detail report on different data models that can be used for developing a database with their
    advantages and disadvantages (P13.1.1)
1.2 Large business organizations make use of Data warehouses with data mining techniques for business
   decision making. Explain what is a data warehouse and how data mining is used in the decision making
   process (P13.1.2)

1.3 Assume that you are the database designer for a bank database and discuss about the use of approach.

Outcome and Assessment Criteria
 Outcome                                Assessment Criteria
 Understand data models                 • Provide evidence to support an understanding of different data models.
 and                                    Compare and contrast different data model structures and examine their
 database technology                    contribution to database development. (1.1)

                                        • Examine case material that focuses on developments such as data
                                        mining and data warehousing. (1.2)

                                        • Analyze the different approaches to database design – (1.3)




                                                 IDM/HND/Data Analysis and Design                     Page 3 of 5
Task 02

Select any organization in real environment and analyze and develop a suitable logical database design for
the organization.

2.1 Apply data analysis and design techniques to develop a fully relational database with minimum of six
    Tables. (P13.2.1)

2.2 Verify that a design meets user requirements and provide justification of the database design. (P13.2.2)

2.3 Use a range of database tools and techniques to demonstrate a more advanced level of understanding and
    Application. (P13.2.3)

Outcome and Assessment Criteria
 Outcome                         Assessment Criteria
 Design a relational database    • Apply data analysis and design techniques to develop a fully relational
 to meet user requirements       database with minimum of six tables. (2.1)

                                 • Verify that a design meets user requirements and provide justification of
                                 the database design. (2.2)

                                 • Use a range of database tools and techniques to demonstrate a more
                                 advanced level of understanding and application. (2.3)

Task 03

3.1. Analyse and demonstrate the extraction of meaningful data through the use of query tools. (P13.3.1)

3.2. Incorporate query language/languages into the database design. (P13.3.2)

3.3. Use manipulation and query tools and techniques to implement the above (Task 02) logical design into
     a relational database system. (P13.3.3)

Outcome and Assessment Criteria
 Outcome                         Assessment Criteria
 Use manipulation and query      • Incorporate query language/languages into the database design (3.2)
 tools and techniques
                                 • Use a range of visual tools to enhance the database design. (3.2)

                                 • Demonstrate the extraction of meaningful data through the use of
                                   query tools. (3.1)




                                           IDM/HND/Data Analysis and Design                  Page 4 of 5
Task 04

Test the relational database using suitable tools and techniques and provide the testing reports.

4.1 Provide documentation to support the database implementation. (P13.4.1)

4.2 Demonstrate ways in which the database has considered the areas of verification and validation.
    (P13.4.2)

4.3 Evaluate a range of testing techniques and apply one to your own database design. (P13.4.3)

Outcome and Assessment Criteria
 Outcome                         Assessment Criteria
 Implement and test database     • Provide documentation to support the database implementation.(4.1)
 design
                                 • Demonstrate ways in which the database has considered the areas of
                                 verification and validation. (4.2)

                                 • Evaluate a range of testing techniques and apply one to your own
                                   database design. (4.3)




                                              End of Assignment




                                           IDM/HND/Data Analysis and Design                   Page 5 of 5

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:9
posted:2/22/2012
language:
pages:5