The File Store

So You Want To Be A Database Expert?

Database Course Notes

Ex3. Question 1 Worked Solution

Room Service Example Solution

Movies Database Worksheets

Movies Database Worked Solution

Puppies Data Dictionary and Entity Relationship Diagram

Hospital Database

2003 to 2005 SQA Database Questions (Amended)

2004 SQA Paper (Amended) Worked Solution

2005 SQA Paper (Amended) Worked Solution

 

Courseworks

Courseworks 2005 - 2011 : Database Section Only (One combined file)

The file above contains the instructions for carrying out the datbase section in each of the courseworks from 2005 to 2011. Completed data dictionaries can be found at the end of each section.

The links below contain the Filemaker Pro databases to carry out the tasks in the packs. Proformas to complete data dictionaries are also included. Each of these proformas allow you to edit them electronically.

• Database Files 0506
• Database Files 0607
• Database Files 0708
• Database Files 0809
• Database Files 0910
• Database Files 1011

Keen to get on with coursework tasks at home? Why not download a trial version of Filemaker Pro? This will give you 30 days to make some progress on the coursework tasks. Remember - You will NOT have time to comlete all coursework sets in class.

 

 

Question Time

*All Relational Database Questions*

Attributes

Data Anomalies

Data Dictionaries

Data Domain

Data Retrieval

Entity Relationships

Integrity

Keys

Normalisation