This computer science problem involves algorithmic thinking and programming concepts. The solution below explains the approach, logic, and implementation step by step.
ScanSolve AI Answer
You're on a roll — Here are the answers to your database questions: 1. The table above is in First Normal Form (1NF). Reason 1: Each column contains atomic values, meaning each cell holds a single, indivisible piece of data. Reason 2: There are no repeating groups of columns. Each row represents a unique entity (a lab) without redundant columns for similar data. 2. Create a data dictionary for the table and save it in your candidate folder. A data dictionary for the LabsList table would describe each field (column) as follows: Lab No: Data Type: Integer Description: Unique identifier for each laboratory. Constraint: Primary Key, Not Null Lab Name: Data Type: Text (e.g., 10 characters) Description: Name of the laboratory. Constraint: Not Null, Unique Location: Data Type: Text (e.g., 10 characters) Description: Physical block where the lab is located. Capacity: Data Type: Integer Description: Maximum number of people the lab can accommodate. Supervisor: Data Type: Text (e.g., 10 characters) Description: Identifier or name of the supervisor assigned to the lab. 3. Import the spreadsheet file LabsList.xlsx and save it in your Microsoft Access book found in your candidate folder. Ensure the first row has the correct field names. To import the spreadsheet: Open Microsoft Access and create a new database or open an existing one. Go to the "External Data" tab on the Access ribbon. Select "New Data Source" -> "From File" -> "Excel". Browse to the LabsList.xlsx file and select it. In the import wizard, choose "Import the source data into a new table in the current database". On the next screen, ensure the checkbox "First Row Contains Column Headings" is selected. This will use Lab No, Lab Name, Location, Capacity, and Supervisor as your field names. Follow the remaining steps, specifying data types if necessary and setting Lab No as the primary key. Save the imported table (e.g., as LabsList). 4. Create a query on your imported table that will display all the male (M) students who carried out practicals in LAB 2 or LAB 5, sorted in ascending order according to subjects. Adjust the field width to fit the content. Assuming you have tables Students, Subjects, LabWorker, and LabsList (the imported table), the SQL query would be: `sql SELECT Students.FirstName, Students.Surname, Students.Gender, LabsList.LabName, Subjects.SubjectName FROM Students JOIN LabWorker ON Students.StudentNo = LabWorker.StudentNo JOIN LabsList ON LabWorker.LabNo = LabsList.LabNo JOIN Subjects ON LabWorker.SubjectID = Subjects.SubjectID WHERE Students.Gender = 'M' AND (LabsList.LabName = 'LAB 2' OR LabsList.LabName = 'LAB 5') ORDER BY Subjects.SubjectName ASC; ` To adjust field width, in Microsoft Access Query Design View, you would right-click on the column header in the datasheet view and select "Field Width" to adjust it, or simply double-click the boundary between column headers to auto-fit. 5. Give the two popular DBMS used on the Internet. Two popular Database Management Systems (DBMS) used on the Internet are: MySQL PostgreSQL 6. To normalize the table above to 2NF, create and draw three sub tables, Students, Subjects, and LabSupervisor. The original LabsList table is already in 2NF (and 3NF) because its primary key (Lab No) is a single attribute, and all other attributes are fully dependent on it. However, to create a more comprehensive normalized database structure that includes student and subject information, we would define the following tables as specified: Students Table: StudentNo (Primary Key) `