Include UI + technical/ user documentation
Create db _with results
Create tables(PK;FK; Validation: Null,NotNull,PK,FK,Unique,Constaint,NVARCHAR()…
Insert,Update,Delete _with illustrations of final result
Select ... from Table1,Table2... _with illustrations of final result (querying across multiple tables)
Select ... from Tables where/join /group by/having/count
Pass Merit Distinction
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.
P4 Test the system against user and system requirements/ Flowchart
P5 Produce technical/ user documentation.
------
M2 Implement a fully functional 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.
M4 Assess the effectiveness of the testing, including an explanation of the choice of test data used.
M5 Produce technical and user documentation for a fully functional system, including ER Diagram and
normalization statements and describing how the system works.
----------------
D2 Evaluate the effectiveness of the database solution in relation to user and system requirements, and
suggest improvements.
D3 Assess any future improvements that may be required to ensure the continued effectiveness of the
database system.
