AS91902 - Database Marking Scheme

[bradley-grover]

This contains a list of the database marking scheme items and all places that items are found.

[bradley-grover]

Achieved: The student has used complex techniques (any two from the Ct list below) to develop a database

• [x] designed the structure of the data (see https://github.com/Duo2023/Tech2023/tree/main/src/Tech2023.DAL)
• [x] used appropriate tools and appropriate techniques to organize, query and present data for a purpose and end-users (MVC Patttern)
• [x] applied appropriate data integrity and testing procedures (see db schemas in writeup)
• [x] addressed relevant implications (Examples include: social, cultural, legal, ethical, intellectual property, privacy, accessibility, usability, functionality, aesthetics, sustainability and future proofing, end-user requirements, health and safety.) (See writeup for these)

[bradley-grover]

Merit: The student has used complex techniques (any three from the Ct list below) to develop an informed database:

• [x] used information from testing procedures to improve the quality of the outcome (debugging)
• [x] structured, organized and queried the data logically (See DAL library and for queries https://github.com/Duo2023/Tech2023/tree/main/src/Tech2023.DAL.Queries the majority of queries are here)
• [x] presented the results of queries in a professional context. (See views and controllers)

[bradley-grover]

Excellence: The student has used complex techniques (all from the Ct list below) to develop a refined database:

• [x] demonstrated iterative improvement throughout the design, development and testing process (Entity Relationship Diagrams (ERDs) screen shots, wireframe, annotations and for the entire development stages) (see ERD and Screenshots on writeup)
• [x] used efficient tools and techniques in the outcome’s production (EF Core & Compiled Static Queries)
• [x] presented the data effectively for the purpose and end-users (these include user friendly design, responsive and robust against unauthorized access and erroneous input, applies proper naming conventions, and error messages.) (see views and controllers)

Complex Techniques:

• [x] structured the data using multiple tables or nodes (applied up to 2nd normal form and decomposed tables appropriately: at least three) (see https://github.com/Duo2023/Tech2023/blob/main/src/Tech2023.DAL/ApplicationDbContext.cs multiple table properties and links)
• [x] created queries which insert, update or delete to modify data (Used LINQ and or Stored Procedures within SQL Server, at least three (see https://github.com/Duo2023/Tech2023/tree/main/src/Tech2023.DAL/Queries folder) (Folder contains Linq queries in pre-compiled form: https://medium.com/@M-B-A-R-K/ef-core-compiled-queries-aea9f98c1d17)
• [x] created customized data displays from multiple tables or nodes (e.g., reports, PDFs, webpages, dashboards, program interfaces) (see views and controllers, subject dashboard)
• [ ] dynamically linked data between the database and a front-end display (return Queries results or implemented fully functional search functionality) [needs work]
• [ ] applied data access permissions as appropriate to the outcome. (Applied appropriate roles and or user permissions correctly or implemented role/user-based authorization and authentication) [work is done; needs writeup work]