The data in flat files has been provided:   INVOICE TABLE INVOICE_NUM CUSTOMER_ID INVOICE_DATE EMPLOYEE_ID COIN_ID DELIVERY_ID 8111 11011 15 May 2021 emp103 7111 511 8112 11013 15 May 2021 emp101 7116 512 8113 11012 17 May 2021 emp101 7112 513 8114 11015 17 May 2021 emp102 7111 514 8115 11011 17 May 2021 emp102 7115 515 8116 11015 18 May 2021 emp103 7115 516 8117 11012 19 May 2021 emp105 7112 517 8118 11013 19 May 2021 emp105 7112 517     COIN_RETURNS TABLE RETURN_ID RETURN_DATE REASON CUSTOMER_ID COIN_ID EMPLOYEE_ID ret001 25 May 2021 Customer not satisfied with product 11011 7116 emp101 ret002 25 May 2021 Product missing part 11013 7114 emp103     COIN TABLE COIN_ID PRODUCT PRICE QTY 7111 1oz Gold Kruger Rand R 5 999 10 7112 1oz Silver Kruger Rand R 12 999 8 7113 Gold Big 5 Uncirculated R 15 999 8 7114 Silver Big 5 Pack R 7 999 5 7115 1oz Gold Palaeontology R 11 999 15 7116 1oz Silver Palaeontology R 7 999 12   COIN_DELIVERY TABLE DELIVERY_ID DELIVERY_NOTES DISPATCH_DATE DELIVERY_DATE 511 Double packaging requested 10 May 2021 15 May 2021 512 Delivery to work address 12 May 2021 15 May 2021 513 Signature required 12 May 2021 17 May 2021 514 No notes 12 May 2021 15 May 2021 515 Birthday present wrapping required 18 May 2021 19 May 2021 516 Delivery to work address 20 May 2021 25 May 2021 517 Double packaging requested 25 May 2021 27 May 2021   EMPLOYEE TABLE EMPLOYEE_ID FIRST_ NAME SURNAME CONTACT_ NUMBER DEPARTMENT ADDRESS EMAIL emp101 Xander Davis 0877277521 sales 10 Main Road xand@isat.com emp102 Steven Marks 0837377522 marketing 18 Water Road sm@isat.com emp103 Jessica Andrews 0817117523 sales 21 Circle Lane ja@isat.com emp104 Wayne Dryer 0797215244 sales 1 Sea Road dryer@isat.com emp105 Xolani Samson 0827122255 manager 12 Main Road xosam@isat.com   Customer Table CUSTOMER_ID FIRST_NAME SURNAME ADDRESS CONTACT_NUMBER EMAIL 11011 Mat Smith 18 Water Rd 0877277521 msmith@isat.com 11012 Julien Hendricks 22 Water Rd 0863257857 jh@mcom.co.za 11013 Sam Clark 101 Summer Lane 0834567891 sclark@mcom.co.za 11014 Kevin Jones 55 Mountain Wa 0612547895 kj@isat.co.za 11015 Lucy Williams 5 Main Rd 0827238521 lw@mcal.co.za   1) Management of COINS 4 AFRICA require an Entity Relationship Diagram (ERD) based on the flat files that have been supplied. Your ERD must incorporate all the entities and attributes supplied, as well as establishing the relationships between the entities.

Q: The table below lists customer/car hire data. Each customer may hire cars from various outlets. A…

A: The SQL statement to insert a record in the table is - INSERT INTO table_nameVALUES (val1, val2,…

Q: How many records are in the following table? EMPLOYEE EMPID EMPLNAME EMPINIT EMPFNAME EMPJOBCODE…

A: Refer to step 2 for the answer.

Q: SALES ORDER Order Customer · Order ID • Order Date Customer ID · Customer_RefNo Char(25) Int (PK)…

A: import java.awt.*;        public class AWTCounter extends Frame implements ActionListener {…

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: The table shown in figure below lists some sample records of dentist/patient appointment data. A…

A: Actually, given information: StaffNo DentistName Pat. No Pat. Name App. Date App. Time…

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

A: Normalization

Q: Q1\ if your database has the information in figure below make the database easy to update and…

A: Primary key for the given relation is (S-ID, Code_No) Partial Functional dependency possible on the…

Q: Q1\ if your database has the information in figure below make the database easy to update and…

A: Primary key for the given relation {S-ID, CodeNo} The FD's possible are Partial Functional…

Q: Please answer the following questions based on the given data model: Customer Customer_stock stock…

A: The syntax for update statement is as follows.   UPDATE table1 SET column1 = value1 WHERE column2 =…

Q: IF POSSIBLE PLEASE TYPE OR WRITE ELIGIBLY illustrate the process of normalizing the data shown in…

A: ANSWER:-

Q: Doctor id Doctor_name Degree Join year Salary D550 Saleh Khalil DM 2001 1700 D551 Osama Ahmad DPM…

A: Given: To write a query to show the doctor name and degree in the following format; Example: Saleh…

Q: Attention : Your answer file name will be your school number-Q1.cpp (ex: 190201231-Q1.cpp)…

A: The source code is attached below in C language.Please refer the code. I have defined the Structure…

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: STU_NUM STU_LNAME STU_MAJOR DEPT_CODE DEPT NAME DEPT PHONE 211343 Sanders Finance, Statistics ACCT…

A: 1) Anomalies are a kind of situations which lead to uncertainity in the database. Data will not be…

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: Name the candidate keys in the following table: Student L number Student_Name Student SS Number…

A: a candidate key is a super key which has no redundant attribute.

Q: The following table stores details of tutors, students and dates of lectures. The Primary Key is…

A: Rules regarding 2nd NF:-  tables must be in 1st NF.  No non-prime is functionally dependent on part…

Q: Write a procedure named prc_inv_add to add a new invoice record to the INV_MYSQL table. Use the…

A: Stored procedures: A procedure is a collection of procedural and SQL statements. A procedure may…

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: upleads wp d Has med title med id wp name med name upid date img desc img id img type ven database…

A: Syntax for creating table: CREATE TABLE (Attribute1 datatype1(size1), Attribute2 datatype2(size2),…

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: Insert the following data into your database tables. STUDENTS STUDENT_ID STUDENT_NAME…

A: Solution:--   1)The given data in the question are all those things that must be included in     the…

Q: GRADE REPORT STUDENT Name Student number Class Student_number Section_identifior Grade Major CS…

A: Given Database:-

Q: Finally, the transactions of the rides are stored in the TRAVELS table. For each travel, start and…

A: Structured Query Language : SQL is a space explicit language utilized in programming and intended…

Q: here are thousands of customers in an ABC Bank who use ATM services. The ABC Bank stores its ATM…

A: The searching technique most suitable in Binary Search The given array A is sorted so the…

Q: 1. Create a dataframe named employee using data.frame() function that consists of all information in…

A: Since you have asked multiple questions in a single request, we will be answering only the first…

Q: Which one is correct Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of…

A: Tables are database objects that contain all the data in a database. In tables, the data is…

Q: The following three tables make up a simple reservation system for a small campground. The database…

A: ER Diagram: ER  diagram is defined as the interconnection of entities and attributes how they are…

Q: The following three tables make up a simple reservation system for a small campground. The database…

A: A primary key is a key whichever uniquely identifies. Foreign key is column or group of columns that…

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: Consider the advisor relation shown in the schema diagram in Figure 2.9, withs_id as the primary key…

A: Primary keys The primary key comprises one or more columns (or attribute names) whose values stored…

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: INVOICES INVOICE LINE INVOICE NUM ITEM ID QUANTITY QUOTED PRICE 14216 INVOICE NUM INVOICE DATE CUST…

A: The complete solution is given below:-

Q: ber BD ID USER ID *SQL Query Required* Display schedule_id, source, destination and travel_time…

A: As per the given question we are given the task to develop a SQL query to display schedule_id,…

Q: Customers customer_id address_id PK Addresses FK address_id city PK first_name last_name phone state…

A: We need to write a trigger for all modification on table named Goods for U;pdate and Delete…

Q: What happens when I click OK?

A: Solution: Given: As per the given details

Q: Q1. Count number of patients examined by doctor using SQL function. Take screenshot and paste on…

A: BEGIN TRANSACTION; /* Create a table Patient */CREATE TABLE Patient(Id integer PRIMARY KEY, Name…

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…

Q: 1. a) Create a table bank_master Column Name Datatype Varchar2(4) Varchar2(30) Varchar2(30) Number…

A: The given problem is related to Oracle data base SQL where the requirement is to make tables named…

Q: Create the appropriate USE Case diagrams to model at least three (3) operations within your…

A: Actors: Student Course Project Use Case: Enrolls in a course Confirms Enrollment Starts Approved

Q: Write a to display user name and password. Password should be generated by concatenating first three…

A: As per the given problem statement we have to develop SQL query to display user name and password.…

Q: Write a to display user name and password. Password should be generated by concatenating first three…

A: Given in the above question we have to develop a SQL query to display list of student ids and…

Q: 's job titles, called EMP and JOB respectively, which have the follow IP umn name PNO AME Column…

A: According to the question we have to design a query which uses the where, group by, having and order…

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: O nbea)lDisCOUNT_ID *SQL Query Required* Display schedule_id, source, destination and travel_time…

A: As per the given question we are given the task to develop a SQL query to display schedule_id,…

Q: Develop SQL Query Display schedule jd, source, destination and travel_time which has minimum travel…

A: As per the given problem statement we have to develop a SQL query Display schedule_id, source,…

Q: Instructions: Based from the given data dictionary below, answer the following questions: DATABASE…

A: Entities are the real world objects. Attributes are the characteristics. Constraints are the…

Q: Normalize the relations into 3NF ORDERS ORDER_ ID DATE CUST_ ID CUST_ NAME STATE ITEM ITEM_ _NUM…

A: Below i have made tables:

Q: 4. Make the below un-normalized data into appropriate normalized form. Un-normalized data Donorid…

A: When converting an unnormalized table (i.e., one containing repeated groups) to table that is in…