Data Analysis And Design
BTEC HIGHER NATIONAL DIPLOMA
: IDM Computer Studies Pvt. Ltd.
: Data Analysis and Design
: Unit 13
: Understanding and Analysis, Design and Implementation of Database system.
: 10th May 2010
Date to be submitted
: 20th July 2010
: Mr. T. Shanakr
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.
|Criteria for PASS |Possible evidence |Feedback | | | |Y |N |Comments | |P13.1.1 Provide evidence to support an | | | | | |understanding of different data models. Compare|Identify a range of data models and explain their | | | | |and contrast different data model structures |structure. (Task 1.1) | | | | |and examine their contribution to database | | | | | |development | | | | | |P13.1.2 Examine case material that focuses on |Analysis and Description about data mining and where | | | | |developments such as data mining and data |house. (Task 1.2) | | | | |warehousing | | | | | |P13.1.3 Analyze the different approaches to |Discuss about different approaches and produce report | | | | |database design |(Task 1.3) | | | |
|P13.2.1 Apply data analysis and design | | | | | |techniques to develop a fully relational |Identify UNF data set and normalize up to 3NF. (Task | | | | |database with minimum of six tables |2.1) | | | | | | | | | | |P13.2.2 Verify that a design meets user |Design a logical database design minimum 6 tables. (Task| | | | |requirements and provide justification of the |2.2) | | | | |database design | | | | | |P13.2.3 Use a range of database tools and |...
Please join StudyMode to read the full document