During some weekends you run a small business at the regular local open market - NSC Information Technology - Question 4 - 2017 - Paper 2
Question 4
During some weekends you run a small business at the regular local open market. Your business involves selling second hand items that your friends and customers brin... show full transcript
Worked Solution & Example Answer:During some weekends you run a small business at the regular local open market - NSC Information Technology - Question 4 - 2017 - Paper 2
Step 1
List THREE duties that are carried out by a database administrator.
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
Management: Overseeing the entire database environment to ensure efficiency and reliability.
Maintenance: Performing regular updates and backups to maintain database performance.
Security Access Rights: Establishing and managing user permissions to safeguard the database.
Step 2
What is a relational database?
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
A relational database is a collection of data organized into tables that are linked together by relationships, enabling structured data management and querying.
Step 3
List TWO possible sources of data for your database.
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
Existing documents: Such as invoices and receipts containing sales data.
Existing workflows: Information from the processes used to manage sales and inventory.
Step 4
What is involved in data maintenance?
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
Data maintenance involves regularly updating and correcting database records to ensure accuracy and availability of data.
Step 5
What is the general aim of normalisation?
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 general aim of normalisation is to organize data in a database into separate tables to minimize redundancy and improve data integrity.
Step 6
Which field would you regard as redundant? Motivate your answer.
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
The field 'Owner's Name' is regarded as redundant because it can be derived from the 'Owner_ID', which links to a separate 'Owners' table that already contains name information.
Step 7
Clearly indicate the table names, primary and foreign keys as well as the relationship between the tables.
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
Table Names:
Owners Table
Clothes Table
Primary Keys:
Owners Table: Owner_ID
Clothes Table: Clothes_ID
Foreign Keys:
Clothes Table: Owner_ID (linking to Owner_ID in Owners Table)
Relationship:
One-to-Many: An owner can have multiple clothes items.
Step 8
Write a statement to show all the information from the table arranged in ascending order according to the price.
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
SELECT * FROM Stock_DetailsTB ORDER BY TotalValue;
Step 9
Write a statement that will delete the item in the old basket called Dress.
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
DELETE FROM Stock_DetailsTB WHERE Item='Dress';
Step 10
Update Malcolm Peter's phone number.
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
UPDATE Stock_DetailsTB SET Contact='0715624117' WHERE Owner's Name='Malcolm Peter';
