A database management system is required for a digital media company that specialises in creating and distributing online video content - NSC Information Technology - Question 2 - 2024 - Paper 1

To select creators' details who have an email not ending with '@gmail.com' and are located in South Africa, execute:

SELECT CreatorName, Email, Country
FROM tblCreators
WHERE Email NOT LIKE '%@gmail.com' AND Country = 'South Africa';

To get the top 3 latest uploaded videos, use:

SELECT TOP 3 UploadDate, VideoID, Title
FROM tblVideos
ORDER BY UploadDate DESC;

To find the number of videos uploaded by each creator, the SQL statement would be:

SELECT CreatorID, Count(*) AS NumberUploaded
FROM tblVideos
GROUP BY CreatorID
HAVING Count(*) > 5;

As an alternative, you can also express:

Count(field_name);

When adding a new creator to the tblCreators table, the SQL command would be:

INSERT INTO tblCreators
VALUES ('C01', 'TRISHAKOL', 'trish@marketing.co.za', 'South Africa');

To remove a creator and their associated videos, follow these steps:

• Start with the first record in the tblCreators table.
• Use a loop to iterate through tblCreators.
• If the CreatorID matches:
  • Delete from tblVideos using:

tblVideos.Delete;

- Move to the next record in tblVideos.
- End the loop once all creators have been processed.

To change the upload date of a video, access the tblVideos table and execute:

tblVideos.Edit;

tblVideos['UploadDate'] := Date;

tblVideos.Post;