Choose the correct answerThe main task carried out in the __________ is to remove repeating attributes to separate tables.OptionsSecond Normal FormFirst Normal FormThird Normal FormFourth Normal Form

Select the correct answerWhich normal form ensures that there are no repeating groups of data and all non-key attributes are fully functionally dependent on the primary key?OptionsSecond Normal Form (2NF)First Normal Form (1NF)Third Normal Form (3NF)Boyce-Codd Normal Form (BCNF)

Select the correct answerIn SQL, which statement is used to remove a table definition and its data from the database?OptionsDROP TABLEDELETE TABLEREMOVE TABLEERASE TABLEFinish ClearPrev Next

Consider the school database, where the primary keys are underlined:student (student_id, name, address,gender)course (u, course_name, year)department (dept_number, date, department_name)                                 i.             Write an SQL statement to add a new record into the department table. (3 Marks)                           ii.            Write an SQL statement to delete all the records from the course table. (2 Marks)Answer text Question 4EditViewInsertFormatToolsTableHelp

Delete Query is used to ____________________________________________.Group of answer choicesCopies records from one table to anotherSelect records from a table and remove them from the tableAll the answers are correctSelect fields from tables and removes them from the table

Which condition must be met for a table to be considered in the First Normal Form?All attributes must be multi-valuedAll attributes must be composite