Unit 33 Data Analysis and Design Distinction Copy

Unit 33 Data Analysis and Design Distinction Copy

Case Study:

Dominican College is situated 15 miles northwest of New York City. The college provides Bachelor of Science programs in Accounting, Computer Information Systems (CIS), and Management programs. Each course contains various types of units and the final project. The College contains three campuses: North Campus offers computing programs; South Campus offers Accounting Programs; West Campus offers Management Programs.  There are lecturers who are capable of teaching various types of units of programs offered by the College. However, the Academic Manager allocates units for all the lecturers based on their skills and competencies. When the students are registered for the course, the admin of the College assigns appropriate courses for each learner. Once the course is assigned, the students are able to find out the lecturers who deliver the respective units and the campus, which they need to attend classes.  

Unit 33 Data Analysis and Design Distinction Copy

Task 1: You are required to carry out research by using supportive materials like books, websites, etc., and give feedback on the findings on A.C 1.1, A.C1.2, and A.C1.3. The answers need to be reflected in the general Data Analysis and Design Concepts.

You have to select any organization to recognize and understand how database models and database technologies have been implemented with their business processes. Answers without application to an organization or without examples will be marked as Resubmission.

Buy assignments from UKEssays London.

LO1 Understand data models and database technologies

  • A.C.1.1 Critically compare different data models
  • A.C.1.2 Critically discuss the benefits and limitations of different database technologies
  • A.C.1.3 Analyse different approaches to database design

Task 2: You are required to carry out research by using supportive materials like books, websites, etc., and give feedback on the findings on A.C2.1, A.C2.2, and A.C 2.3. The answers need to be reflected to the given case study above. Answers without application to the given case study organization or without examples will be marked as Resubmission.

LO 2. Be able to design and implement relational database systems

  • A.C.2.1 Design a relational database system to meet the given requirements provided in the given case study.
  • A.C.2.2- Build a relational database system for the database design in A.C 2.1 using an appropriate database software application.
  • A.C.2.3 Apply a range of database tools and techniques to enhance the user interface to meet the given case study requirements.

Task 3:  You are required to carry out research by using supportive materials like books, websites, etc., and give feedback on the findings on A.C 3.1, A.C 3.2, A.C 3.3. The answers need to be reflected in the case study given above. Answers without application to the given case study organization or without examples will be marked as Resubmission.

LO 3. Be able to use manipulation and querying tools

  • A.C. 3.1Explain the benefits of using manipulation and query tools in a relational database system as per the requirements given in the case study.
  • A.C.3.2 Implement a query language into the relational database system that has been implemented in task 2.2
  • A.C. 3.3Critically evaluate how meaningful data has been extracted through the use of query tools for the given case study.  

Unit 33 Data Analysis and Design Distinction Copy

Task 4:  You are required to carry out research by using supportive materials like books, websites, etc., and give feedback on the findings on A.C 4.1, A.C 4.2, A.C 4.3, A.C 4.4, and A.C 4.5. The answers need to be reflected on the case study given above. Answers without application to the given case study organization or without examples will be marked as Resubmission.

LO 4. Be able to test and document relational database systems 

  • A.C. 4.1Critically review and test the implemented relational database system
  • A.C. 4.2Create documentation to support the implementation and testing of the relational database system that has been implemented in Task 2.2
  • A.C. 4.3Create user documentation for the developed relational database system in task 2.2
  • A.C. 4.4Explain how verification and validation have been addressed in the developed relational database system.
  • A.C. 4.5Explain how control mechanisms have been used in the developed relational database system.