docx, 34.89 KB
docx, 34.89 KB

Learning Project created in the style of the exam for Pearson Level 3 Unit 2 Create a system to Manage Information (design, create Access database, build queries/report, test, and evaluate a relational database). Contains guidance/pointers and suggestions for gaining higher marks. Learning Project can be used to demonstrate to whole class or as a resource for learners to work through individually for practice. Templates are provided for learners to complete supporting practice for the final exam. Learning Project may be used for other level 3 courses covering relational databases concepts: ERD/normalisation/design/development/testing/evaluation.

Review

4

Something went wrong, please try again later.

ryan_tebble1

2 years ago
4

I am a novice, but how do you set up FlightNo as a primary key, when there are duplicate values? Don't Primary Keys have to be unique? But how do actual airlines manage this, as they constantly repeat flight numbers. All I get is errors when testing.

Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.