Some restaurants use a database and an efficient database management system for their administration, orders and point of sale - NSC Information Technology - Question 4 - 2018 - Paper 2
Question 4
Some restaurants use a database and an efficient database management system for their administration, orders and point of sale.
4.1 Name ONE possible role of a data... show full transcript
Worked Solution & Example Answer:Some restaurants use a database and an efficient database management system for their administration, orders and point of sale - NSC Information Technology - Question 4 - 2018 - Paper 2
Step 1
4.1 Name ONE possible role of a database in the POS system of a restaurant.
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
One possible role of a database in the POS system of a restaurant is to manage and update the inventory items as sales occur, ensuring that stock levels are accurate and current.
Step 2
4.2.1(a) Suggest a suitable data type for WaiterID.
99%
104 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The suitable data type for WaiterID would be a String, as it is typically represented as alphanumeric characters.
Step 3
4.2.1(b) Suggest a suitable data type for Permanent Appointment.
96%
101 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The suitable data type for Permanent Appointment would be Boolean, indicating whether a waiter has a permanent appointment or not.
Step 4
4.2.2 Evaluate the structure of the tblWaiter table.
98%
120 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The tblWaiter table has the field 'Initial and Surname' combined into one field, which could create issues for sorting. When generating a report sorted by surname, it would be challenging to separate surnames from initials without additional processing, as the table structure does not support sorting by surname directly.
Step 5
4.2.3(a) Identify and add the field name of a suitable primary key (PK).
97%
117 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The field name of a suitable primary key (PK) is 'JobCardNr'.
Step 6
4.2.3(b) List other field names that must appear in the tblJobCard table.
97%
121 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Other field names that must appear in the tblJobCard table include 'NormalHoursWorked', 'WeekStartDate', and 'HoursOvertime'.
Step 7
4.2.3(c) Identify and add an applicable foreign key (FK).
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
An applicable foreign key (FK) to add would be 'WaiterID', linking the job card to the specific waiter.
Step 8
4.2.4 Draw a simple entity-relationship diagram (ERD).
99%
104 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The ERD will show 'Waiter' as one entity linked to multiple 'Job_Card' entities, demonstrating a one-to-many relationship, indicating that one waiter can have multiple job cards.
Step 9
4.3.1 Identify ONE issue that could threaten the physical integrity of data.
96%
101 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
One issue that could threaten the physical integrity of data is a 'Power failure', which can result in data loss or corruption.
Step 10
4.3.2 State TWO database design aspects that will ensure logical integrity.
98%
120 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Two aspects that will ensure logical integrity are:
Data validation and validation rules: Ensuring that all data entered meets defined criteria.
Ensuring referential integrity: Foreign keys must refer to existing records in another table to maintain data accuracy.
Step 11
4.4 State THREE primary responsibilities of a database administrator.
97%
117 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Three primary responsibilities of a database administrator include:
Designing and maintaining the database.
Ensuring database security and access rights.
Backing up data and restoring when necessary.
Step 12
4.5 State TWO benefits of having a DBMS installed on a server.
97%
121 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Two benefits of having a DBMS installed on a server are:
Support for multiple user connections to execute transactions simultaneously.
Improved management of data and resources, leading to better performance.
Step 13
4.6.1 Suggest ONE reason why a distributed database system requires sophisticated security.
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
A distributed database system requires sophisticated security because data is transmitted across networks, increasing vulnerability to unauthorized access and attacks.
Step 14
4.6.2 What is the benefit of working on a distributed database from a user's perspective?
99%
104 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The benefit of working on a distributed database from a user's perspective includes faster access to data, as the database can be closer to the user’s location, reducing latency.
Step 15
4.6.3 Briefly explain how data synchronisation is done.
96%
101 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Data synchronization in a distributed database is achieved through scheduled data uploads and leveraging conflict resolution methods to ensure that all instances of the database reflect the same data while maintaining consistency.
