Reference no: EM133825160

Unit 04 Database Design & Development, Higher National Diploma in Computing

Assignment - Data base system for Quiet Attic Films

Part 1: The submission should be in the form of an individual written reportwritten in a concise, formal business style using single spacing and font size 12. You are required to make use of headings, paragraphs and subsections as appropriate, and all work must be supported with research and referenced using Harvard referencing system. Please also provide in-text citation and bibliography using Harvard referencing system. The recommended word limit is 3,000-3,500 words, although you will not be penalised for exceeding the total word limit.
Part 2: The submission should be in the form of a fully functional relational database system demonstrated to the Tutor; and an individual written report (please see details in Part 1 above).
Part 3: The submission should be in the form of a witness statement of the testing completed by the Tutor; technical documentation; and a written report (please see details in Part 1 above).

Learning Outcome 1: Use an appropriate design tool to design a relational database system for a substantial problem.
Learning Outcome 2: Develop a fully functional relational database system, based on an existing system design.
Learning Outcome 3: Test the system against user and system requirements.
Learning Outcome 4: Produce technical and user documentation.

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 scenarioand 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.

Activity 3

3.1 Provide a suitable test plan to test the system against user and system requirements. provide relevant test cases for the database you have implemented. Assess how the selected test data can be used to improve the effectiveness of testing. Get Assignment Help With Zero AI Now!

Note:- Learner needs to give expected results in a tabular format and screenshots of the actual results with the conclusion

3.2 Get independent feedback on your database solution from the non-technical users and some developers (use surveys, questioners, interviews or any other feedback collecting method) and make a separate conclusion from the feedbacks.

Activity 4

Produce technical and user documentation for a fully functional system, including data flow diagrams showing movement of data through the system, and flowcharts describing how the system works. Evaluate the developed database by suggesting future enhancements to ensure the effectiveness of the system.