Sql script and front-end microsoft access

Dr. Leonardo Stella

Assessment Type: Databases Project

Assessment weighting: 60%

Submission Date: 17/01/2022, 23:59

Description of the assessment
The students will design, implement, test and evaluate a database system designed to support an enterprise scenario using industry-standard techniques, tools, technologies and best practices.

The project consists of three main parts:

- A data-entry front-end in MS Access, which meets the requirements of the scenario, with prompts and labels correctly spelled and easy-to-read, and allows non-technical users to update all relevant database tables.

We will explore the content of the coursework together in a synchronous session on Week 1 and again when the scenario will be announced.

Please note:
Submission in any form other than a single zip file (e.g. rar, multiple files, etc) for the database project will NOT be accepted and you will automatically fail this assessment. If you fail to include all the mandatory files, your final grade will be reduced by 20% for each missing part.

VERY IMPORTANT NOTE:
The database must be built on Microsoft SQL Server and the front-end in MS Access. If this is not the case, the highest grade you can receive on this assignment will be 30%. If your MS Access is not saved in the Desktop on your personal VM, you will get 0 on this component.

– has been commissioned by a research institute (which shall remain nameless), and it is intended to be open source, and therefore available to anyone.1

Basically, it is a machine learning application that would run on a database with the aim to identify the correlation between different aspects of the sector, including funding opportunities and development of new production companies or studios.2

1 This scenario is purely hypothetical. It is not real; in case you are worried that students are being

exploited for free database development labour.

for each movie the following information is recorded: a universal unique movie code (similar to the ISBN for books), the title of the movie, the year and the first release date (different release dates are not important and should NOT be recorded).

Also, the database records each member of the crew that is part of the movie, and the role they have in the movie: each crew member can play a single role or multiple roles in the same movie, and each role has a description associated with it. For example, in each movie there can be a single protagonist or more than one, the same actor can play one or several roles, or even have a cameo.

Requirements

In the spec, the requirements are numerated from 1 to 5, as the scenario was not

telephone number has a description associated with it (e.g., personal, or work).

3.Each production company is registered only once but can have many shareholders.

Anonymous Marking
You must submit your work using your student number to identify yourself, not your name. You must not use your name in the text of the work at any point. When you submit your work in classter you must submit your student number within the assignment document and in the Submission title field. For example, if your student number is 100123456, you should name your file 5CC507-100123456.zip when submitting it.

Assessment Regulations
The University’s regulations, policies and procedures for students define the framework within which teaching and assessment are conducted. Please make sure you are familiar with these regulations, policies and procedures.