Student_Grade Student ID Course Code Semester Mark Grade 20195605 A0313401 1-2019-2020 87 20195606 A0313402 1-2019-2020 81 A0312305 A0313401 20191200 3-2018-2019 77 20205305 1-2019-2020 91 20205306 A0313402 1-2019-2020 78 20201202 A0312305 3-2018-2019 81 1) Create the table 2) Insert the data 3) Assign a letter grade to the "Grade" according to the following rules: a. If the mark is greater or equal to 90, assign "A" b. If the mark is between 80 and 89, assign "B" c. If the mark is less than 80, assign "C"
Q: State # letters in name Year entered the Union Rank for entering the Union Area (square miles)…
A: Regression analysis We do the problem in Excel. Going Data > Data Analysis > Regression we get…
Q: Databases and Database Users exercise: Cite some examples of integrity constraints that you think…
A: Some of the constraints that can be imposed on database: Each section must belongs to any “Course”…
Q: - Create a new table called CLERKS based on EMP table so that it contains all the clerks in EMP
A: PROGRAM INSTRUCTIONS:Create two database tables ‘EMP’ and ‘DEPT’ and declare all required…
Q: Using Match function, under Remarks column, put a remark “FOUND” if invoice on record exists in…
A: The given problem is related to excel program where the given excel data will use Invoice submitted…
Q: regions countries locations REGION_ID REGION_NAME VARCHAR2(25) CHAR(2) COUNTRY_ID COUNTRY_NAME…
A: For queries Please find the respective SQL statements : I'm using aggregate functions like count and…
Q: Problem Solving Flowcharts and Pseudocodes BMI table for adults' This is the World Health…
A: Below is the required python program: - Approach: - Store the file name in the variable. Use the…
Q: Number the following terms from 1 to 9 to indicate their size from smallest to largest. a.…
A: Here we need to indicate the given terms, which are basically the data storage units of measurement,…
Q: EmployeelD Last Name First Name Address City Province PostalCode Phone BirthDate 507 - 20th Ave.…
A: 1- A trigger is created for AFTER insert situation. 2- When a row is inserted, a copy of the row is…
Q: Grade Calculation at CoTs Student ID J123458 Student Name Someshvar Course ID ITDB201 Course Name…
A: <!DOCTYPE html><html><head> <meta charset="utf-8"> <meta…
Q: INVOICE LINE INVOICES INVOICE NUM ITEM ID QUANTITY QUOTED PRICE INVOICE NUM INVOICE DATE CUST ID 125…
A: ITEM_ID which is unique and primary key in ITEM table can act as a identifier for ITEM. Using…
Q: Student Enrollment nationality US studentNr courseNr section 100 CS 1713 100 ENG1043 100 HIS1033…
A: Relational algebra
Q: Give an example of one or more anomalies that can result in using this relation.
A: Database management: The process of managing the database is known as database management. Each and…
Q: INVOICES INVOICE LINE INVOICE NUM ITEM ID QUANTITY QUOTED PRICE 14216 INVOICE NUM INVOICE DATE CUST…
A: The complete solution is given below:-
Q: - For all the employees supervised by KING, give them a salary increase, which is equal to the 2% of…
A: Programming Instructions:Create two database tables ‘EMP’ and ‘DEPT’ and declare all required…
Q: Car Car Dealership PK Car ID Serial Number Make Model | (0,1) (1,1) Colour Year Sales Invoice Car…
A: Create an ERD for a car dealership. The dealership sells both new and used cars, and it operates a…
Q: Item Item ID Name Price In Stock 10 Scanner 25 12 Printer 39 2 14 Mouse 7 15 Keyboard 7 18 Camera 12…
A: Microsoft Excel is a spreadsheet developed by Microsoft. It's used to create a software program that…
Q: Table name: ADVISORS ADVISORID A102 A103 ADVISORNAME Sami Alice A104 Suad A105 A101 Tamil Arun Table…
A: ON clause is used to implement Joins between 2 tables.
Q: FIGURE P1.5 The File Structure PROJ_NUM PROJ_NAME EMP NUM 1 Hurricane 1 Hurricane JOB CODE JOB_CHG…
A: Given table contains 8 columns that are Proj_num, Proj_name, Emp_num, Emp_name, Job_code,…
Q: Students Courses Stu_Id Stu_Name Age GPA Course_Code Course_Name Cr_Hrs 201912346 Ali 20 2.5…
A: The problem is based on writing the statement to display the student details based on a particular…
Q: Patient table PATIENTNUM NAME SURNAME APPOINTMENTDATE APPOINTMENTTIME SURGEONID W220 TONY JONES 12…
A: Hello Student, hope you are doing well, I will be trying my best to explain and fulfill your query.…
Q: Student ID 1011 1012 1013 1015 Course MIS ACT MKT FIN Student Name Salem Ali Ayman Ahmad Rana Omar…
A: Data Dictionary in database is defined as a structure which defines and catalogue the content of…
Q: BookLoan ISBN copyNo dateOut dateDue borrowerNo 2220000002 2 9/12/2018 10/3/2018 B023 5550000005 1…
A: Question: Identify the relational keys for each table. List each relational key in a separate line.
Q: The table shown below displays the details of the roles played by actors/actresses in films. filmNo…
A: A:- Because in this table there is no primary key. In order to identify the table solely and…
Q: Marks Roll No. Name Date of Birth Max. Marks Obtained Marks 500 500 500 1851 K 456 12-Jul-1998 1852…
A: This question is based on Hypertext Markup language (HTML). For answering this question i am using…
Q: on student's rating. Use the table below: Rating Rating Range Grade Range Grade 81-83 78-80 75-77…
A: Their lot of sub-attributes I will write a code based upon that you can illustrate I have given the…
Q: esperson ID Name Salary Com_Rate Hire date 1 John 100000 2 Amy 120000 3 Mark | 65000 4 Pam 5 Alex…
A: SQL commands are instructions. It is used to communicate with the database. It is also used to…
Q: SQL List location name, owner first name, owner last name, state, unit number, bedrooms, baths, and…
A: Given 3 data base tables location, owner and condo_unit. The SQL only include condos from Solmaris…
Q: Enter student number 1: 2018-0004 Enter first name 1: Mark Enter student number 2: 2018-0017 Enter…
A: 1. StudentList.java…
Q: Create a query for each of the following, save and print a copy: Books on a loan, using only…
A: It is based on the Relational Database Management System(RDBMS) having executed through…
Q: Results Messages id emp_name emp_age emp_salary join_date phone id emp_name emp_age emp_salary…
A: An entity in a real world object and can be described by using set of attributes. An entity store…
Q: Employee ID 001 001 002 002 002 002 003 003 Year 2018 2019 2017 2018 2019 2020 |Salary 50000 55000…
A: Introduction: SQL (Structured Query Language) is a programming language that is used to conduct…
Q: PROJ_NAME PROJ_VALUE PROJ_BALANCE EMP_LNAME EMP_FNAME EMP_INITIAL JOB_CODE JOB_DESCRIPTION…
A: The SQL code for the above table is /* Create a table called PROJECT */CREATE TABLE PROJECT…
Q: Table name: ADVISORS ADVISORID ADVISORNAME A102 Sami A103 Alice A104 Suad A105 Tamil A101 Arun Table…
A: 1)Display name for name: Get all Student names who are in CSE dept.πSnameσDname=”CSE”(Student…
Q: $ cat students.txt SID: 12345678 Name: Vicky Miller Degree: BSc SID: 23456789 Name: Vincent Park…
A: It is defined as a widely used general-purpose, high level programming language. Python can be used…
Q: Letter Criteria 90 < numeric grade < 100 80 < numeric grade < 90 70 < numeric grade < 80 60 <…
A: Grading in education is the attempt to apply standardized measurements of varying levels of…
Q: OWNER_NUM LAST_NAME FIRST_NAME ADDRESS CITY STATE ZIP_CODE AK102 Aksoy Ceyda 411 Griffin Rd. Seattle…
A: CREATE TABLE TABLE_NAME ( column1 datatype, column2 datatype, column3 datatype, column4 datatype, );…
Q: xplain the difference between ISO 27001 and 27002
A: 1) Certification 2) Security 3) ISMS 4) Managerial Difference
Q: 15:41 Done STUDENTS STUDENT_ID STUDENT_NAME S123456 S246810 S369121 S654321 S987654 MODULES…
A: CREATE TABLE STUDENTS(STUDENT_ID VARCHAR(20) PRIMARY KEY, STUDENT_NAME CHAR,STUDENT_SURNAME CHAR);…
Q: FINAL.LOCATONS FINAL.COUNTRIES FINAL.REGIONS P LOCATION_ID STREET ADORESS * CITY NUMBER * COUNTRY_ID…
A: Below we use for the database scripts 1) CREATE TABLE ==> here we use the constraint scripts to…
Q: GRADE_REPORT Student number 17 17 788 88 8 PREREQUISITE Course_number CS3380 CS3380 CS3320…
A: Here's the solution:
Q: QTR4 TR3 TRZ TR1 14500 10000 16500 22000 14900 15000 18475 11400 40000 85000 42000 52000 60000 KPT…
A: According to the information given:- We have define brief analysis of the data found in KPT…
Q: Using KNN algorithm to find the 05 similar movies from the movies below. Movie ID Movie Name IMDB…
A: import numpy as np import pandas as pd from sklearn.model_selection import train_test_split
Q: 1. Find: NINT (7.6) FLOOR (5.75) NINT (-8,66) FLOOR (-6.48)
A: As per our guidelines we are supposed to answer only one question. Kindly repost the remaining…
Q: INVOICE_LINE INVOICES INVOICE NUM INVOICE DATE CUST ID 125 INVOICE NUM ITEM ID QUANTITY QUOTED PRICE…
A: Given databases are INVOICES, INVOICE_LINE, ITEM are representing the required details of the KimTay…
Q: Normalize the following table to the 3rd Normal form: Student Student Phone Course…
A: The Table has : Student, Student_Phone, Course , Term, Grade , Instructor, Instructor_Phone We need…
Q: Using the table structures you created (in first attachment called "Table Stucture", remove all…
A:
Q: ldentify 7 errors ! cat least)
A: In this question we are asked to find atleast 7 errors in given C programming language.
Q: CustomerID TotalPurchaseAmount NumberOfTransactions AveragePurchas 12431 105.60 3 35.20000 1 12583…
A: Hi. Let's move on to the code in the next step. I have included comments in the code that will…
Q: Answer the following questions, depending on the attached tables: Table: Boxoffice Table: Movies…
A: Answer: Code Snippet: 1. Procedure to display few column data. CREATE OR REPLACE PROCEDURE…
Step by step
Solved in 3 steps
- INVOICES INVOICE LINE INVOICE NUM INVOICE DATE CUST ID 11/15/2021 INVOICE NUM ITEM ID QUANTITY 14216 QUOTED PRICE 14216 125 CA75 $37.99 14219 11/15/2021 227 14219 AD72 $79.99 14222 11/16/2021 294 14219 DT12 4. $39.99 14224 11/16/2021 182 14222 LD14 $47.99 14228 11/18/2021 435 14224 KH81 4. $18.99 14231 14233 14237 11/18/2021 11/18/2021 125 14228 FS42 $124.99 435 14228 PF19 1. $74.99 11/19/2021 616 14231 UF39 2. S189.99 14233 KH81 $19.99 QB92 WB49 LP73 14233 $109.95 14233 $74.95 14237 $54.95 ТЕМ ITEM ID DESCRIPTION ON HAND CATEGORY LOCATION PRICE Dog Feeding Station Fenthers Bird Cage (12x24x18) AD72 12 DOG B. $79.99 10 BRD B $79.99 CA75 Enclosed Cat Litter Station 15 CAT $39.99 Dog Toy Gift Set Fly Mask with FRars Folding Saddle Stand Aquarium (55 Gallon) DT12 27 DOG B $39.99 FM23 41 HOR $24.95 FS39 12 HOR $39.99 FS42 FSH A. $124.99 KHS1 LD14 Wild Bird Food (25 Ib) 24 BRD $19.99 Locking Small Dog Door 14 DOG $49.99 LP73 Lange Pot Carrier 23 DOG $59.99 Pump & Filter Kit Quilted Stable…Table name: ADVISORS ADVISORID ADVISORNAME A102 Sami A103 Alice A104 Suad A105 Tamil A101 Arun Table name: DEPARTMENTS DEPTID DEPTNAME ELC D102 D101 IT D103 BSD D104 ENG Table name: STUDENTS STUDENTID STUDENTNAME DOB GENDER ALLOWANCE DEPTID ADVISORID STUDENTLEVEL AGE 6/1/1999 Male 12/30/1994 Female 6/1/1999 Male 5/6/1995 Male 10/15/1992 Male S103 Hisham 90 D102 A102 Level 1 22 S102 Sara 45 D103 A104 Diploma 27 S101 Salim 45 D103 A104 Diploma 22 S107 Khalil 45 D101 A101 BTech 26 S109 Said 45 D104 A101 Advanced Diploma 29 s100 Ahmad 5/1/1995 Male 45 D101 A103 BTech 26 S104 Faisal 4/5/1998 Male 90 D104 A101 Advanced Diploma 23 S105 Fatima 2/23/1992 Female 90 D102 A102 Level 2 29 9/12/1999 Female 8/13/1991 Female S106 Arwa 45 D102 A102 Level 3 22 S108 Ibtisam 90 D103 A104 Diploma 30 Write the SQL statement for the following: 1. Using the ON clause, display the advisor name and student name for all students in the BTech levelTable name: ADVISORS ADVISORID ADVISORNAME A102 Sami A103 Alice A104 Suad A105 Tamil A101 Arun Table name: DEPARTMENTS DEPTID DEPTNAME D102 ELC D101 IT D103 BSD D104 ENG Table name: STUDENTS STUDENTID STUDENTNAME DOB GENDER ALLOWANCE DEPTID ADVISORID STUDENTLEVEL AGE Hisham 6/1/1999 Male 90 D102 S103 A102 Level 1 22 12/30/1994 Female 45 D103 S102 Sara A104 Diploma 27 S101 Salim 6/1/1999 Male 45 | D103 A104 Diploma 22 5107 Khalil 5/6/1995 Male 45 D101 A101 Blech 26 45 | D104 Advanced Diploma S109 Said 10/15/1992 Male A101 29 5/1/1995 Male 45 D101 90 D104 5100 Ahmad BTech Advanced Diploma A103 26 4/5/1998 Male 2/23/1992 Female 9/12/1999 Female S104 Faisal A101 23 0 D102 45 D102 S105 Fatima 90 A102 Level 2 29 S106 Arwa A102 Level 3 22 S108 Ibtisam 8/13/1991 Female 90 D103 A104 Diploma 30 Write the SQL statement for the following: 1. Using the ON clause, display the advisor name and student name for all students in the BTech level 2. Display the student name, gender and department name of…
- SUPPLIER PRODUCT ProductCode ProductnName unitPrice SupCode supCode (Number, 3) SupName (text, 20) АВC LLC (Number, 10) [Char(10)] (>0) 1111111 Calculator 10 111 111 2222222 Notebook 2.5 777 222 ХҮX LLC 3333333 Book-AI 20 222 3333 PQR LLC 4444444 Pen -2.0 222 222 AXL LLC 5555555 Pencil .500 111 Eraser .500 2221. Write a database description for each of the relations shown, using SQL DDL (shorten, abbreviate, or change any data names, as needed for your SQL version). Assume the following attribute data types: StudentID (integer, primary key) StudentName (25 characters) FacultylD (integer, primary key) FacultyName (25 characters) CourselD (8 characters, primary key)PET ID PET NAME PET TYPE PET AGE OWNER VISIT DATE PROCEDURE 246 ROVER DOG 12 SAM COOK JAN 13/2002MAR 27/2002APR 02/2002 01 - RABIES VACCINATION10 - EXAMINE and TREAT WOUND05 - HEART WORM TEST 298 SPOT DOG 2 TERRY KIM JAN 21/2002MAR 10/2002 08 - TETANUS VACCINATION05 - HEART WORM TEST 341 MORRIS CAT 4 SAM COOK JAN 23/2001JAN 13/2002 01 - RABIES VACCINATION01 - RABIES VACCINATION 519 TWEEDY BIRD 2 TERRY KIM APR 30/2002APR 30/2002 20 - ANNUALCHECK UP12 - EYE WASH The functional dependencies that I note are as follows: Pet ID --> Pet Name, Pet Type, Pet Age, Owner Pet ID, Visit Date --> {Visit Procedure} (the set of visit procedures), note the use of procedure codes that repeat, but are listed in their own column So, Is there are other functional dependencies? If so, what are they? If not, why not? Do you believe it would help to create additional attributes during normalization? If so, what are they? If not, justify why it's not needed. Please help me understand this.
- List the department IDs for those departments that have less than 5 employees: Employee Did Salarycode Ename Eid Ephone Samer 15 23 2345 70092485 Sarah 13 12 5088 71092246 Ahmad 4 26 7712 03099348 Jalal 15 22 9664 76093148 Elie 8 23 3054 70092729 Fadi 24 2976 03091945 Layal 9 21 4490 71099380 Select one: a. SELECT Did FROM Employee GROUP BY Did HAVING SUM(Eid) < 5; O b. SELECT Did, COUNT(Eid) FROM Employee GROUP BY Did; O c. None of these d. SELECT Did FROM Employee GROUP BY Did HAVING COUNT(Eid) < 5;Indicate the changes you need to make to the KimTay Pet Supplies database to support the following additional requirement. Each location has a manager who is identified by a manager ID, a manager first name, and a manager last name.Table EMP Column name Column type Integer Up to 10 characters Example entry EMPNO ENAME Description Employee ID number Employee surname 7369 SMITH Integer Integer Employee's job title No ID no. of employee's JOBNO 10 MGR 7566 manager HIREDATE Date 17/12/1980 Date employment started Monthly salary SAL Integer 1600 Table JOB Column name Column type Integer Up to 15 characters Example entry Description job title No Employee's job title JOBNO 10 JOB TITLE SALESMAN a) Write SQL statements to create EMP and JOB tables. Define appropriate data types and check constraints for the tables' fields. Write SQL statements to populate these tables with 3 rows of sample data.
- Typed answer please fassssttttNormalize 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…Attribute Name Sample Value Sample Value Sample Value Sample Value Sample Value INV_NUM 211347 211347 211347 211348 211349 PROD NUM SALE_DATE PROD LABEL VEND_CODE VEND NAME AA-E3422QW QD-300932X 15-Jan-2018 15-Jan-2018 Rotary sander 211 QUANT_SOLD PROD PRICE $49.95 1 NeverFail, Inc. NeverFail, Inc. BeGood, Inc. RU-995748G 15-Jan-2018 0.25-in. drill Band saw 211 309 8 $3.45 1 $39.99 AA-E3422QW 15-Jan-2018 Rotary sander 211 Power drill 157 NeverFail, Inc. ToughGo, Inc. 2 GH-778345P 16-Jan-2018 $49.95 1 $87.75 b) Remove all partial dependencies, write the relational schema, and draw the new dependency diagrams. Identify the normal forms for each table structure you created.