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: Q1\ if your database has the nformation in figure below make the database easy to update and…

A: The table is not normalized as some cells are holding multiple values.  Break the tables to…

Q: Create a Java Database GUI application to create an application about books (title, author name,…

A: ANSWER: Java Database GUI Carry out a data set GUI in java interface with the database,show…

Q: Convert to normalization

A: Given that, The given database tables are: Person, Employee, Department, Invoice, Customer, Supplier…

Q: What is the result of the following query? SELECT AVG(Number_Of Children)) AS "Avg",…

A: Basic knowledge of SQL is needed to solve this problem.

Q: simple retrieval queries using 2group by, 2having clause, 2aggregation functions related to your…

A: Group by is a SQL clause used to group rows with similar values into summary rows. The having clause…

Q: 2.1 In Tables A,B,C identify the primary key(s), secondary key(s) and the foreign key(s). If a table…

A: 2.1 In Tables A,B,C identify the primary key(s), secondary key(s) and the foreign key(s). If a table…

Q: name of table 1  Staff_info:  Staffid (pk) Fname Lname Dob Genderid Course_code (fk)…

A: We need to create the mentioned database using MYSQL.

Q: Dete Adess Year of_death Purchase date Number_of entais Nane Year of Jath Code Times eted Number…

A: we need to convert given E-R diagram to Relational schema. For N: M relation we have created a New…

Q: Cust_id (NOT NULL) Txn_date (Not NULL) Txn_type (NOT NULL) Txn_amount (NOT NULL) 1 2020-01-21…

A: The CREATE TABLE statement is used to create a new table. Syntax: CREATE TABLE table_name (column1…

Q: Add the four maintenance types to the MAINTENANCE_TYPES table. Create tire maintenance tasks for…

A: The first three questions are answered as part of the Expert Bartleby Guidelines. To get the answers…

Q: te view_admin.php for this tab

A: Program Approach:   1- As mentioned in the assignment create the table as admin and store the…

Q: Given the default schema of a database: EB Orders 123 Orderld OrderDate ADC OrderNumber 123…

A: The question has been answered in step2

Q: cify all the relationships among the records of the database  shown in Figure 1.

A: Accprding to question The detailed answer to the above-mentioned question is given below :-

Q: Observe the table ENROLLMENT: StudentID StudentName MajorlD MajorName 111 222 333 Joe Bob Lisa…

A: Anomalies refer to inconsistencies, errors, or unintended consequences that can arise in a database…

Q: 4. Show the result of the following queries as it would apply to the database state given above. 1.…

A: All distinct student names from Student table whose Major is CS are displayed Name Smith…

Q: What is the output of the following SQL statement? SELECT name, hCity, pcity, population FROM…

A: Answer: Output 3

Q: Write the query finding the team name of employees whose salary is equal to 1/5 of the total amount…

A: Here we need to join table Teams and Salaries using NATURAL JOIN operator since they have a common…

Q: 1. Use the following table to answer the questions below. Table name: Products Column Role Data Type…

A: We have to extract year from the Date filed and then the year has to be 2021  Now, we have to count…

Q: Convert the following ER diagram into relational schema

A:

Q: lter table product so that column productlype is an integer instead of a varchar, not null should be…

A: Lets see the solution.

Q: Database management system lab project: Project topic-Hall manage system  [N.B: use sql language…

A: Based on the requirements of the Hall manage system project, here is an overview of the questions…

Q: Question : Map the following ERD to relational schema (show primary and Foreign keys) CPR Supervise…

A:

Q: Question 9  Metadata is data about data.

A: Thank you  __________   True    Metadata summarizes basic information about data, making finding…

Q: Given the default schema of a database: EB Customers 123 Customerld noc FirstName noc LastName noc…

A: SQL stands for Structured Query Language.

Q: Create the ERM. FIGURE Q3.22 THE CH03_THEATER DATABASE TABLES Database name: Ch03_Theater Table…

A: The  ER model has been designed using crow's foot model below . Since the question does not specify…

Q: data SCORE gam P-namet-ID clescription guest captain nost TEAM PLA YER Contains エNJURY RE CORDS…

A: SQL Statements to create the database : TEAM(T_ID, CAPTAIN,T_NAME,CITY,COACH)…

Q: Given the default schema of a database: Orders 123 Orderld OrderDate ADC OrderNumber 123 Customerld…

A: Please refer to the following step for the complete solution to the problem above.

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: a Write in SQL a command that creates the table Products according to the above description a. Write…

A: Given :

Q: View 3 Seneca Courses Inc. Employee Forms All employee information for SCI is maintained on file…

A: Actually, the answer has given below:

Q: Using SQL, insert at least 2 rows for each table. CourseCodes-SCI1 and SCI2 and one section each in…

A: Please check the step 2 for solution

Q: Create a database with five (5) tables based on the attributes boxes below. Set the appropriate data…

A: 1) Create a database college. (change database name as per the requirement) 2)Add Five Tables to the…

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: CREATE INDEX ItemIndex1 ON Orderline (TaskID)   What is the SQL query to display the index that I…

A: Here, The query is given to create an index.

Q: Publisher Books Wagon Blackwell Pub Orion Orion Visual For Dummies ISBN Book Title 9788184122077…

A: Answer: We need to draw the ER diagram to for the given Table information. so we will see in the…

Q: Consider the following Database Schema. CUSTOMLR PK CUS CODE DVOICE LNC PK HY MUMBER PKFKI YNUMRER…

A: we assume that product table attributes P_INDATE used for incoming of product and P_descript contain…

Q: SUBJECT_CO DE SUBJECT_ NAME TEACHING HOUR_PER_SU BJECT LECTURER_ID LECTURER_NAME DEPT ID DEPT NAME…

A: Dependency is a constraint that describes the relationship between attributes. It also describes as…

Q: Salesforce / SOQL Design a SOQL Query to fetch the activity hisoty corressponding to a object.…

A: SOQL query to track the activity history of any object is below:

Q: Normalise the data :

A: Q

Q: CCCCC Business Administration 3333 DDDDD Education 4444 EEEEE Physics 5555 FFFFF History…

A: here from Given the Student and  Student_Courses relations shown above, discuss when Union, Inner…

Q: The Car Maintenance team wants to add Tire Change (ID: 1) maintenance task for all cars with the due…

A: Answer: We have given answer in SQL you can see below. And you can update as per you requirement.

Q: the table using design view. Item ItemlD ItemName Section Price Sol Garments Accessories TI01 Tshirt…

A: I have written queries below: