Figure 3.1 shows an example of book loans information in a secondary school library. BookLoans StulD S001 S002 5002 S003 5001 (a) BookCode StartDate EndDate (i) (ii) BC111 12/06/2022 22/06/2022 BC333 01/06/2022 11/06/2022 BC222 09/07/2022 19/07/2022 15/07/2022 25/007/2022 BC333 BC444 21/07/2022 01/08/2022 Book BookCode BC111 BC222 BC333 BC444 Student StudentID S001 S002 S003 BookName Quantity 12 Sejarah T3 Matematik 20 TS English TS Bahasa Melayu T3 studentName Jasmine Michael Brian 10 15 Classroom 3 Berlian 5 Intan 5 Delima Figure 3.1 Sample Records from Book Loans Figure 3.1 shows the tables in a book loans database that have been normalized to the Third Normal Form (3NF) with three entities namely BookLoans, Book and Student. Draw the original table in the First Normal Form (INF). Based on the answer in Q3(a)(i), identify the primary key of the relation. (iii) Based on the answer in Q3(a)(i), draw the dependency diagram showing all dependencies in the relation.

Draw the result after applying each of the relational algebra operations on the following table

IF POSSIBLE PLEASE TYPE OR WRITE ELIGIBLY illustrate the process of normalizing the data shown in this table to third normal form (3NF). officeNo officeAddress telNo mgrStaffNo name B001 8 Jefferson Way, Portland, ME 97201 503-555-3618 S1500 Tom Daniels B002 City Center Plaza, Seattle, WA 98122 206-555-6756 S0010 Mary Martinez B003 14 – 8th Avenue, New York, NY 10012 212-371-3000 S0145 Art Peters B004 16 – 14th Avenue, Seattle, WA 98128 206-555-3131 S2250 Sally Stern   Primary key: officeNo   Why the above table is not in 3NF? Describe and illustrate the process of normalizing the data shown in this table to third normal form (3NF). c) Identify the primary and foreign keys in your 3NF relations.

Use the table below to find the output PRODUCT_ID PRODUCT_NAME BRAND UNIT PRICE SUPPLIER_ID CATEGORY_ID 113 Note Book Atlas Pieces 5 S1 C1 114 Sticky Note Fanta Воx 4.3 S3 C1 117 Paper Clips Nizwa Packet .5 S4 C1 111 A4 Paper Double A Ream 2 S1 C2 112 Plastic envelope Atlas Packet 1.7 S2 C1 115 White Board Marker Pentel Вох 2.2 S3 C2 116 Stapler Small Nizwa Pieces S4 C1 Write the OUTPUT of the following SQL Statement: 1- SELECT brand FROM products WHERE price = 2.2; 2 - SELECT product_name FROM products WHERE product_name like "%Ma%' 3 - SELECT price * 2 FROM products WHERE product_id = 111 4 - SELECT unit FROM products WHERE supplier_id = 'S3' and Category_id ='C1'

Write a servlet to display a table that contains factorials for thenumbers from 0 to 10, as shown in Figure .

The following table shows the student grades for Q1 and Q2 assessment activities. Calculate the mean and mode for Q1 and Q2 grades Calculate the range and standard deviation for Q1 grades and Q2 grades Student Number Q1 Grade Q2 Grade Total student Grade 1 85 79 164 2 96 85 181 3 84 76 160 4 75 76 151 5 64 94 158 6 83 83 166 7 92 92 184 8 74 71 145 9 67 81 148 10 81 93 174 11 93 72 165

Normalize the following table to the 3rd Normal form:  Student  Student Phone  Course  Term  Grade  Instructor  Instructor  Phone  Lauren Fernell  555-7771  MIS 350  F12  A  Hess  555-2222  Lauren Fernell  555-7771  MIS 372  F12  B  Sarker  555-2224  Lauren Fernell  555-7771  MIS 426  F12  A  Fuller  555-2227  Lauren Fernell  555-7771  MIS 375  F12  B+  Wells  555-2228  Brigit Schnieder  555-2215  MIS 350  F12  A  Hess  555-2222  Brigit Schnieder  555-2215  MIS 375  F12  B+  Wells  555-2228  Brigit Schnieder  555-2215  MIS 372  F12  A  Sarker  555-2224  Brigit Schnieder  555-2215  MIS 374  F12  B  Clay  555-2221  Jackie Judson  555-1245  MIS 350  F12  A  Hess  555-2222  Jackie Judson  555-1245  MIS 372  F12  B+  Sarker  555-2224    How many tables did you create after normalizing the table?      List each of…

ERD:- PK CHECKOUT Check Num FK1 Book_Num FK2 Pat_ID Check Out Date Check_Due Date Check_In_Date PK BOOK Book Num Book Title Book_Year Book_Cost Book_Subject FK1 Pat_ID -H- PATRON PK Pat ID Pat_FName Pat_LName Pat_Type WRITES PK,FK1 Book Num PK,FK2 Au ID AUTHOR PK AU ID Au_FName Au_LName Au_BirthYear

Answer the following questions by referring to the tables below. COURSE Course_name Course_number Credit_hours Department Intro to Computer Science CS1310 4 CS Data Structures CS3320 4 CS Discrete Mathematics MATH2410 3 MATH Database CS3380 3 CS   SECTION Section_ID Course_number Semester Year Instructor 85 MATH2410 Fall 07 King 92 CS1310 Fall 07 Anderson 102 CS3320 Spring 08 Knuth 112 MATH2410 Fall 08 Chang 119 CS1310 Fall 08 Anderson 135 CS3380 Fall 08 Stone Retrieve a list of all the courses under the "CS" department, listed alphabetically by course name. Retrieve the section ID, course name, course number, semester, year, and Instructor of the courses taught by Instructor "Anderson". Insert a tuple for a new COURSE with the following information: 4.The course name is Computer networks, and the course number is CS3480. It belongs to the CS…