- Case StudyHelp.com
- Sample Questions
|Unit:||Data Analysis and Design|
All coursework must be submitted Coursework Regulations
Please check the submission date and time and ensure that coursework is submitted on time.
- Requests for an extension must be in accordance with the guidelines set out in the college regulations, with the necessary documentary evidence to support your request. Refer to The Student Handbook.
- General guidelines for submission of coursework:
- All work must be word-processed and must be of a “good” standard.
- Document margins should not be more than 2.5cm or less than 1.5cm.
- c) Font size in the range of 11 to 14 points distributed to including headings and body text. Preferred typeface to be of a common standard such as Arial, Calibri or Times New Roman for the main text.
- All work completed including any software constructedmay not be used for any purpose other than the purpose of intended study without prior written permission from St Patrick’s College.
Remember to keep evidence of your submitted coursework.
|LO||Learning outcome(LO)||AC||In this assessment you will have the opportunity to present evidence that shows you are able to:||Task no.||Evidence(Page no)|
|LO 1||Understand data models and Database technology||1.1||Provide evidence to support an understanding of different data models. Compare and contrast different data model structures and examine their contribution to database development||1|
|1.2||Examine case material that focuses on developments such as data mining and data warehousing||1|
|1.3||Analyse the different approaches to database design||1|
|LO 2||Design a relational database to meet user requirements||2.1||Apply data analysis and design techniques to develop a fully relational database with minimum of six tables||2|
|2.2||Verify that a design meets user requirements and provide justification of the database design||2|
|2.3||Use a range of database tools and techniques to demonstrate a more advanced level of understanding and application||2|
|LO 3||Use manipulation and query tools and techniques||3.1||Incorporate a query language/languages into the database design||3|
|3.2||Use a range of visual tools to enhance the database design||3|
|3.3||Demonstrate the extraction of meaningful data through the use of query tools||3|
|LO 4||Implement and test database design||4.1||Provide documentation to support the database implementation||4|
|4.2||Demonstrate ways in which the database has considered the areas of verification and validation||4|
|4.3||Evaluate a range of testing techniques and apply one to your own database design.||4|
|I certify that the work submitted for this assignment is my own and research sources are fully acknowledged.Student signature: Date:|
|In addition to the above PASS criteria, this assignment gives you the opportunity to submit evidence in order to achieve the following MERIT and DISTINCTION grades|
|Grade Descriptor||Indicative characteristic/s||Contextualisation|
|M1 Identify and apply strategies to find appropriate solutions||
||To achieve M1 learners need to consider example in the discussion of Task – 2 in 2.1 with source of information using Harvard reference system.|
|M2 Select/design and apply appropriate methods/techniques||
||Learner must range of methods and techniques to collect, analyse and process data and apply data analysis techniques to design the database solution. (Whole Task 2)|
|M3 Present and communicate appropriate findings||
||To achieve M3 you must produce documentation to set format i.e. coding with appropriate screen shots.With appropriate technical language has been used throughout (Whole Task 2 and 3.1)|
|D1 Use critical reflection to evaluate own work and justify valid conclusions||
||To achieve D1 Analysis and Design of the database solution should be robust with suggested improvement.(Whole Tasks 2, 3.1 and 4.1)|
|D2 Take responsibility for managing and organising data||
||To achieve D2 the similarity of the learners’ work should be minimum level. All the activities such as system analysis, design, implementation coding with screen shots and testing need to be carried out and presented according to the assignment deliverable.(Tasks 3 and 4.1)|
|D3 Demonstrate convergent/lateral/ creative thinking using SQL queries.||
||Database solution should be robust so that all the transaction query should produce meaningful data. Learners should critically evaluate the developed solution by mentioning the limitations and future improvements. (Task 4)|
|Assignment title||Data Analysis and Design|
Case Study: Developing a database for Sports Goods sale businessSporting Goods Direct (SGD) is a directly selling catalogue based retailer of Sporting Equipment. Customers select the items and complete an order form, which is processed by SGD. Recently SGD has seen a considerable growth in the business with lot more sales than the first quarter of the year 2015.Demand for their stock have grown, therefore they need a well-designed relational database for stock maintenance and customer record purposes.Sporting Goods Direct sells many Items under many Categories:· Men
The minimum details to be stored for each item are Item ID, Item Name, Category, Description, Price, Quantity, and Re-order Quantity.
The Customers need to register before being able to purchase an item. The information customers must provide are:
Many Suppliers can supply items sold in the store and one supplier can supply many items. Each item is supplied at a particular price. The store needs to record details of each supplier in the database. The respective details are: Supplier ID, Supplier Name, Address and Contact Number. All transactions between the store and the supplier need to be recorded.
Sporting Goods Direct needs to maintain and record all the Orders made with details like Item Ordered, Quantity Ordered, Order Date, and Total Amount. Their system later generates an order form, which contains Order Number, Item Code(s), and the Quantity Ordered.
Design a database for SGD indicating the necessary keys and relationships. Draw ER Diagram and map them to Relations ensuring that the database is in the third normal form.
You must design a database with the above mentioned specification indicating the necessary keys and relationships. Draw ERD diagram for the entities along with their attributes such that the database is in the third normal form (Apply 1NF, 2NF and 3NF).
Notice: Assignment must meet all requirements/learning outcomes specified in order to achieve Pass.
Task 1 (LO: 1.1, 1.2, 1.3, M1, D2) 1.1 Compare and contrast the integrated database environment with the traditional file processing environment. Analyse the different data model approaches to database design [Assessment Criteria: 1. 1, 1.3]
1.2 Illustrated with suitable examples from the given case study the meaning of data warehousing and data mining [Assessment Criteria: 1. 2]
Task 2 (LO: 2.1, 2.2, 2.3, M2, M3, D1 & D2) 2.1 Create a schema listing the attributes for each entity identified and show that your schema is normalised (at least in 3NF). Identify primary, foreign and composite keys if there are any. [Assessment Criteria: 2. 3]
2.2 Draw an entity relation diagram that will enable you to create a database for online sport items sales. Resolve “many to many” relationships if there are any. State any necessary assumptions. [Assessment Criteria: 2. 3]
Hint : Example of ER
2.3 Use query language (MySQL) to create the database with minimum six tables with necessary attributes and declare primary and foreign keys where necessary. Justify that the implementation meets the user requirements in the case study. [Assessment Criteria: 2. 1, 2.2]
Task 3 (LO: 3.1, 3.2, 3.3 M3, D2& D3)3.1 Insert at least 5 records into each table created. Also provide a screenshot of the records in each table. [Assessment Criteria: 3. 1]
3.2 Using MySQL as visual tool, demonstrate the extraction of meaningful data through the use of “Select” statement. Provide screenshots with MySQL code for the following Queries. [Assessment Criteria: 3.2 & 3. 3]
Task 4 (LO: 4.1, 4.2, 4.3, M1, M3, D1, D2) 4.1 Evaluate each query above, providing the SQL statement and show the output from the query. [Assessment Criteria: 4.1] 4.2 Using MySQL, implement and test the verification and validation process with above 8 queries from the database illustrating the understanding of the various features of SQL (update, sorting, joining tables, conditions using the where clause, grouping, set functions, sub-queries etc.). [Assessment Criteria: 4.2]
4.3 4.3 Explain different database testing techniques. Apply one of these techniques to your own database implementation. [Assessment Criteria: 4.3]
|Qualification||HND Diploma in Network Engineering and Telecommunications Systems||Assessor name||Tanveer Ahmad, Robert Chambers|
|Unit Number and title||Unit: Data Analysis and Design||Student name|
|LO||Learning outcome(LO)||AC||To achieve the criteria the evidence must show that the student is able to:||Achieved|
|LO 1||Understand data models andDatabase technology||1.1||Provide evidence to support an understanding of different data models. Compare and contrast different data model structures and examine their contribution to database development|
|1.2||Examine case material that focuses on developments such as data mining and data warehousing|
|1.3||Analyze the different approaches to database design|
|LO 2||Design a relational database to meet user requirements||2.1||Apply data analysis and design techniques to develop a fully relational database with minimum of six tables|
|2.2||Verify that a design meets user requirements and provide justification of the database design|
|2.3||Use a range of database tools and techniques to demonstrate a more advanced level of understanding and application|
|LO 3||Use manipulation and query tools and techniques||3.1||Incorporate a query language/languages into the database design|
|3.2||Use a range of visual tools to enhance the database design|
|3.3||Demonstrate the extraction of meaningful data through the use of query tools|
|LO 4||Implement and test database design||4.1||Provide documentation to support the database implementation|
|4.2||Demonstrate ways in which the database has considered the areas of verification and validation|
|4.3||Evaluate a range of testing techniques and apply one to your own database design.|
|Higher Grade Achievements|
|Grade descriptor||Achieved||Grade descriptor||Achieved|
|M1: Identify and apply strategies to find appropriate solutions||D1: Use critical reflection to evaluate own work and justify valid conclusions|
|M2: Select / design and apply appropriate methods / techniques||D2: Take responsibility for managing and organising data in a database|
|M3: Present and communicate appropriate findings||D3: Demonstrate convergent /lateral /creative thinking in using SQL queries|
Please CHAT WITH LIVE Assignment Advisor to know more about Referencing styles and Citations.
Chat with our 24 x 7 Online Agents CLICK CHAT NOW
Ask Your Assignment Question
Check out our Assignment Help Services
Find Your Assignment Experts