Convert this table to 2NF if it is not in 2NF. Course_Name Course_Fee Prof_ID P_01 Physics $5000 P_03 Law $7800 P_02 Economics $6500 P_03 Politics $4500 P_01 Chemistry $5000 P_02 Statistics $6500 P_05 Economics $6500 P_04 Physics $5000 In the above table {Prof_ID, Course_Name} is a candidate key.

Draw the Mapping for the following diagram

Use the university schema for the following questions student takes ID ID course id sec id name dept_name tot ged semester vear grade section course course id sec id department course id advisor title dept_name credits dept name s id semester Year building room number time slot id building budget time_slot time slot id day start time end time prereq instructor classroom couTse id grereg id ID building room_number name dept_name salary сараcity teaches ID course id sec id semester year Figure 2.9 Schema diagram for the university database. Use the online SQLite tool from db-book.com to write SQL statements for each of the questions below. Paste your solution SQL statement under each question and upload the document to Canvas. 1. Display the name and total institution credits taken (not tot_cred which includes transfer credits) of students that do not have an assigned advisor (across all years). a. Hint: link takes with courses and student, for students not in advisor, project the name…

Normalized 3nf int.

Please use the following three tables to answer the following question Table name: student student id first name last name ss number major gpa 1239 Robert Lee 234654569 IS 3.5 2596 Mary Smith 409889923 MKT 2.8 Table name: take take id student id course id grade 10043 1239 Is300 A 10056 1239 Acct300 B 10067 2596 Is300 A Table name: course course id instructor classroom Is300 John Doe CBA236 Acct300 Ann Lee CBA139 Fin350 Mary Jones CBA240 The relationship between the "take" table and "course" table is Many to many O Many to one One to one One to many

Course • Courseld CourseCode CourseName Capacity Instructorld 3815 ENGL862 American Literature 75 2 2213 CS8 Computer Graphics 25 1 4093 PHIL26 Intro to Philosophy 150 3 8131 CS58 Databases 50 7152 PHIL276 Ethics 100 3 • Instructorld 123 Instructor InstructorName Rank Ben Love Associate Professor Pat Wade Mai Wood Associate Professor Professor Department Computer Science English Philosophy Note: Both tables may not be necessary to complete this level. Complete the following correlated subquery to find instructors who teach fewer than 2 courses. The query should return the row containing Pat Wade. SELECT * FROM Instructor I WHERE 2 > (SELECT *Type your code here */ FROM Course WHERE InstructorId =

SQL FOR THERES TABLES

1. The data type for Borrower_name in Borrowers Table is: A. Short text C. Currency B. Long text D. Yes/No Borrowers Field Name Borrower ID Borrower Name Phone num Membership_activation Data Type AutoNumber Short Text Short Text Yes/No

candidate key only branchNo and postcode

Question 11. Write the SQL statement that will implement the relational algebra expressions in the following relational algebra expressions O(discount_percent-30)(PRODUCTS) E RESULT1xproduct_id=product_idORDER_ITEMS RESULT2Morder_id=order_idORDERS RESULT3Mcustomer id=customer idCUSTOMERS RESULTI RESULT2 RESULT3 RESULT4 RESULT E Tfirst_name last name,product_name(RESULT4)