Insert the following data into your database tables. STUDENTS STUDENT_ID STUDENT_NAME STUDENT_SURNAME S123456 Neo Petlele S246810 Derek Moore S369121 Pedro Ntaba S654321 Thabo Joe S987654 Dominique Woolridge MODULES MODULE_ID MODULE_NAME MODULE_CREDIT DATA6212 Database Intermediate 30 INPU221 Desktop Publishing 20 PROG6211 Programming 2A 15 PROG6212 Programming 2B 15 WEDE220 Web Development (Intermediate) STUDENT_MODULES STUDENT_ID MODULE_ID S123456 PROG6211 S123456 PROG6212 S246810 DATA6212 S369121 DATA6212 S369121 INPU221 S369121 WEDE220 S987654 PROG6211 S987654 PROG6212 S987654 WEDE220 LECTURERS LECTURER_ID LECTURER_NAME LECTURER_SURNAME L578963 Kwezi Mbete L876592 Julia Robins L916482 Trevor January LECTURER_MODULES MODULE_ID LECTURER_ID DATA6212 L578963 INPU221 L876592 PROG6211 L916482 PROG6212 L916482 WEDE220 L876592 Correct INSERT statements used and all data correctly inserted per table.

Q: Write a procedure to add a new invoice record to the INVOICE table. Use the following values in the…

A: Given a table INVOICE. To create a procedure prc_invoice_add to add a new invoice record with the…

Q: The relational database below contains two related tables - “Supplier” and “Product”:   “Product”…

A: A foreign key is used to joins a table to another table by referencing its primary key. A foreign…

Q: Observe the table ENROLLMENT: ENROLLMENT StudentName MajorID MajorName English StudentID 111 Joe E…

A: A deletion anomaly  is the accidental loss of  data because of cancellation of different  data.

Q: Make at least 10 sql statements from the table script given (try to make a little complex script)…

A: Query 1: To display table Books. SELECT * FROM Books;   Query 2: To count number of Readers. SELECT…

Q: Create the database that includes the following tables: Doctor : Phone# (int) Name (Varchar)…

A: Answer: I have written SQL query and also I have attached SQL query and screen shot

Q: Identify and describe the components of the table shown in Figure Q3.21, using correct terminology.…

A: The table comprises of following components which are :1) Entities - They are real-world objects…

Q: Jennífer Smith STUDENT ID: 2340999 EMAIL: jenny@gmail.com PHONE: (330) 902-1111 8400 Market Ave…

A: An XML document begins with the following syntax. <?xml version="1.0" encoding="UTF-8"?>…

Q: QUESTION 2 How many records are in the following table? EMPLOYEE EMPFNAME Robert EMPID EMPLNAME…

A: Answer for the question 2 is given below No of records is nothing but the count of number of rows

Q: Given the following table, COURSES, with the following rows, what values are generated by the query…

A: SUBSTRING will return the substring from specified start and ending indices So now we find the…

Q: Create the following table in your database with the following schema: Table: SalesPerson | Column…

A: The script is written in SQL. Please check the source code and output in the following steps.

Q: Table: Author Author_ID Author_Name DZN9010 J.K. Rowling VC8931 Arthur Conan Doyle STA7686 Suzanne…

A: Introduction: A transitive dependency in a database is a functional dependency where some non-prime…

Q: Create the following table in your database with the following schema: Table: Users I Column Name 1…

A: Note:- As per our guidelines we are supposed to answer only one question. Kindly repost other…

Q: FIGURE P8.31 CH08_SALECO2 DATABASE TABLES Database name: Ch08_SaleCo2 Table name: CUSTOMER Table…

A: Explanation : The trigger is created on the line table, before level trigger executed for each row.…

Q: ISBN(PK) Title Publisher Stock Price C Programming Database Systems 1123 Pearson 300 89 2111…

A: Structured Query Language is abbreviated as SQL or also pronounced as See-Qwell. It is developed for…

Q: Create the following table in your database with the following schema: Table: Patients | Column Name…

A: The code is given below.

Q: Q3. Create a Metadata for the following Database: Stu id Name Address Postal Code Gender Department…

A: Providing information about metadata means mentioning the details about all the fields and data that…

Q: Create the following table in your database with the following schema: Table: salesPerson | Column…

A: CREATE TABLE table_name  (  column1 data type;  column2 data type;  column3 date type;  ...  );…

Q: A database includes information on people and clubs. Each person identified by an integer and has…

A: TABLE PEOPLE: The name of the table is Person. Its attributes are Person-ID Person_name Person_phno…

Q: Answer All the questions: Consider the below Student table and write the appropriate relational…

A: In the problem, it is mentioned to write a relational query. Here I am using MySQL for this. In the…

Q: BNew Database Open Database Write Changes Revert Changes Open Project Save Project Attach Database X…

A: We need to write a sql query that display the student name, course number, credits, and grades by…

Q: Given the following MYSQL table: persons (The Primary key in the first column and it is an automatic…

A: saveData.php <?php $name=$_POST['pNm']; $salary=$_POST['pSalary']; $dob=$_POST['pDob'];…

Q: SALES Customer ID (primary key) Date of purchase Item code(foreign key) 001 2/05/2021 A-1 002…

A: Logical view : represents the functionality of the particular database to users.

Q: HELP IN DATABASE THIS DID NOT WORK CREATE OR REPLACE PROCEDURE PRC_INV_DELETE (W_IN IN NUMBER)…

A: The following is the snippet with the modifications done.

Q: Create the following table in your database with the following schema: Table: Products I Column Name…

A: Create table syntax :  CREATE TABLE TABLE_NAME(  column_name  data_type,   column_name  data_type,…

Q: FIGURE Q3.18 The Ch03_Theater Database Tables Table name: DIRECTOR DIR_NUM DIR LNAME DIR DOB 100…

A: We solve the answer : Answer 5) we make simple ERD :

Q: A database includes information on people and clubs. Each person is identified by an integer and…

A: To create a SQL statement for the table given in the problem statement. Statement: A database…

Q: The following query would correctly show the average donation amount per state for dogs. query…

A: Below is the answer with explanation:

Q: Make at least 20 sql statements from the table script given (try to make a little complex script)…

A: Answer: SQL Source Code: Category C: 1. select Email from reader where First_name = 'Kapil' or…

Q: Instruction Part 2: Create a relationship between the common field (Technician Number) of the two…

A: 1. SELECT *FROM CLIENT cINNER JOIN TECHNICIAN tON c.TechnicianNumber = t.TechnicianNumber2. SELECT…

Q: Convert the following record to a normalized data structure up to 3NF showing all attributes…

A: The ask is to normalize the data structure to 3NF for the following data: Grade-Report Number…

Q: CSC1100 Products ProductID ProdName 614 Sprinkler HG15 Humming bird feeder 620 Garden hose 625…

A: Hello student Greetings Hope you are doing great. Thank You!!!

Q: Normalization is a process of organizing the data in the database to avoid data redundancy,…

A: Normalization: it is the process of data organization in the data base to avoid redundancy in data.…

Q: Problem: JMS TechWizards is a local company that provides technical services to several small…

A: Note: - As per our guidelines we can only answer one question at a time. Please resubmit the other…

Q: The relational database below contains details about Keretapi Tanah Melayu Berhad (KTMB) train…

A: As per company guidelines I am solving 1st 3 subparts. Please repost other parts.  As I dont know…

Q: Create the table that would result from Astu_code (student). FIGURE Q3.8 THE CH03_COLLEGEQUE…

A: This question is from relational algebra and below is the solution.

Q: Create the following tables in your database with the following schema: Table: Countries | Column…

A: As per our guidelines, only 3 sub parts will be answered. So, please repost the remaining questions…

Q: Figure Q3.16b The CUSTOMER and CAR Tables Database name: Ch03_Questions Table name: CUSTOMER Table…

A: Attributes are the properties or characteristics of entities. Relationships describe how entities…

Q: FIGURE P8.31 CH08_SALECO2 DATABASE TABLES Database name: Ch08_SaleCo2 Table name: CUSTOMER Dcoor…

A: OBJECTIVE: Here a trigger would be written to insert the values for the column LINE_TOTAL that would…

Q: Jump to level 1 Courseld CourseCode 1034 BUS739 6237 4074 2888 3587 BUS9 ENGL997 CS98 CS29 Course…

A: Given  Table  Course SELECT CourseCodeFROM CourseWHERE Capacity <=(SELECT Capacity FROM Course…

Q: Insert the following records into Library table: Bookid Bname Price Publisher 101 Database Systems…

A: INSERT command is used to insert data in MySql database.

Q: Create the following table in your database with the following schema: Table: Sales | Column Name |…

A: create table query- create table sales(sale_id int primary key ,product_name varchar(200),sale_date…

Q: The database has three tables for tracking horse- riding lessons: 1. Horse with columns: o ID -…

A: Answer: Create table Horse with below attributes, respective data types, and primary key create…

Q: The relational database below contains details about Keretapi Tanah Melayu Berhad (KTMB) train…

A: The count( ) is used to get the count of unique station distinct keyword is used to return unique…

Q: 4-22. Benjamin Department Store (Data Validation Using a DBMS) The payroll department at the…

A: We have to create a table to store the given data with its appropriate datatype in a single table…

Q: Display the name of supplier(s) that supplied the most expensive computer?       2. Display the…

A: As per Bartleby guidelines: “Since you have posted a question with multiple sub-parts, we will solve…

Q: Q2. EMP_ID FIRST_NAME | LAST_NAME SALARY DEPARTMENT 100000 HR 80000 0011 Preeti Raheja 0023 Geetika…

A: As per our guidelines only 3 sub parts will be answered. So, please repost the remaining questions…

Q: ISBN(PK) Title Publisher Stock Price C Programming Database Systems 1123 Pearson 300 89 2111…

A: SQL statement screenshot: : SQL statement:  SELECT * FROM book WHERE title LIKE 'A%'; Output:

Q: Create a MYSQL database table named Employees as the following. ID Frist_name Last_name Department…

A: Database CREATE TABLE EMPLOYEES (ID INT, FIRST_NAME VARCHAR(10) , LAST_NAME VATCHAR(10), DEPARTMENT…

Q: The relational database below contains two related tables - “Supplier” and “Product”:   “Product”…

A: The above two tables (Supplier - Product) have One-to-many relationships.  As one value from the…