Download Database Design & Development: Assignment Brief for Quiet Attic Films and more Assignments Technology in PDF only on Docsity!
Higher Nationals Internal verification of assessment decisions – BTEC (RQF) INTERNAL VERIFICATION – ASSESSMENT DECISIONS Programme title BTEC HND in Computing Assessor Internal Verifier Unit(s) Unit 04: Database Design & Development Assignment title Database Solution for Quiet Attic Films Student’s name List which assessment criteria the Assessor has awarded. Pass Merit Distinction INTERNAL VERIFIER CHECKLIST Do the assessment criteria awarded match those shown in the assignment brief?
Y/N
Is the Pass/Merit/Distinction grade awarded justified by the assessor’s comments on the student work?
Y/N
Has the work been assessed accurately?
Y/N
Is the feedback to the student: Give details:
- Constructive?
- Linked to relevant assessment criteria?
- Identifying opportunities for improved performance?
- Agreeing actions?
Y/N
Y/N
Y/N
Y/N
Does the assessment decision need amending?
Y/N
Assessor signature Date Internal Verifier signature Date Programme Leader signature (if required) Date
Confirm action completed Remedial action taken Give details: Assessor signature Date Internal Verifier signature Date Programme Leader signature (if required) Date
Assignment Feedback Formative Feedback: Assessor to Student Action Plan Summative feedback Feedback: Student to Assessor
Assessor signature Date Student signature Date Pearson Higher Nationals in Computing Unit 04: Database Design & Development Assignment 01 General Guidelines
Student Declaration I hereby, declare that I know what plagiarism entails, namely to use another’s work and to present it as my own without attributing the sources in the correct form. I further understand what it means to copy another’s work.
- I know that plagiarism is a punishable offence because it constitutes theft.
- I understand the plagiarism and copying policy of Edexcel UK.
- I know what the consequences will be if I plagiarise or copy another’s work in any of the assignments for this program.
- I declare therefore that all work presented by me for every aspect of my program, will be my own, and where I have made use of another’s work, I will attribute the source in the correct way.
- I acknowledge that the attachment of this document signed or not, constitutes a binding agreement between myself and Pearson, UK.
- I understand that my assignment will not be considered as submitted if this document is not attached to the assignment. Student’s Signature: Date: ( Provide E-mail ID ) ( Provide Submission Date )
Assignment brief Quiet Attic Films is a film production company based in London, England who specialize in making short information films and advertisements for television. They want you to design and implement a database that meets the requirements for their data. These requirements are specified in this scenario and the examples of paper documents kept by the company shown below. Quiet Attic Films organize their data around the concept of a ‘production’. A production is specified as being for a particular client; but note that a client might have more than one production at any time. A production will take place at one or more locations. A production will also use a number of, what are called, properties, which might be anything from an actual property like a building, to costumes or small items of any sort. It is important to keep a record of which properties are required at which location. There should also be a record kept of the staff types that are assigned to productions Activity 1 Identify the user and system requirements to design a database for the above scenario and design a relational database system using conceptual design (ER Model) by including identifiers (primary Key) of entities and cardinalities, participations of relationships. Convert
the ER Model into logical database design using relational database model including primary keys foreign keys and referential Integrities. It should contain at least five interrelated tables. Check whether the provided logical design is normalised. If not, normalize the database by removing the anomalies. (Note:-It is allowed to have your own assumptions and related attributes within the scope of the case study given) Design set of simple interfaces to input and output for the above scenario using Wireframe or any interface-designing tool. Evaluate the effectiveness of the given design (ERD and Logical design) in terms of the identified user and system requirements. Activity 2 Develop a relational database system according to the ER diagram you have created (Use SQL DDL statements). Provide evidence of the use of a suitable IDE to create a simple interface to insert, update and delete data in the database. Implement proper security mechanisms in the developed database and evaluate the database solution developed in terms of its effectiveness with relevance to the user and system requirements identified, system security mechanisms (EX: -User groups, access permissions) and the maintenance of the database. Suggest improvements for any identified problems. Assess the usage of the below SQL statements with the examples from the developed database to prove that the data extracted through them are meaningful and relevant to the given scenario. Select/ Where / Update / Between / In / Group by / Order by / Having
Grading Criteria Achieved Feedback LO1 Use an appropriate design tool to design a relational database system for a substantial problem. P1 Design a relational database system using appropriate design tools and techniques, containing at least four interrelated tables, with clear statements of user and system requirements. M1 Produce a comprehensive design for a fully-functional system, which includes interface and output designs, data validations and data normalization. D1 Evaluate the effectiveness of the design in relation to user and system requirements.
LO2 Develop a fully-functional relational database system, based on an existing system design P2 Develop the database system with evidence of user interface, output and data validations, and querying across multiple tables. P3 Implement a query language into the relational database system . M2 Implement a fullyfunctional database system, which includes system security and database maintenance. M3 Assess whether meaningful data has been extracted through the use of query tools to produce appropriate management information LO3 Test the systems against user and system requirements P4 Test the system against user and system requirements. M4 Assess the effectiveness of the testing, including an explanation of the choice of test data used.
