Create a data dictionary for this receipt
Q: Indexing can clearly be very beneficial. Why should younot create an index for every column of every…
A: Indexes : 1. It will slow up inserts and updates because those changes will cause an update of every…
Q: The DBA LOBS Dictionary view provides a description of LOBS contained in all tables. What TABLE NAME…
A: Hey there, I am writing the required solution of the questin mentioned above. Please do find the…
Q: Count ROM Customer Given the following table TABLE CUSTOMER Column Null? Туре CUS_ID NOT NULL NUMBER…
A: SELECT COUNT(distinct name) FROM customer will return count of distinct customers in the table…
Q: What type do you use when fragmenting the table above? and give reasons. Describe how the table…
A: ANSWER: Fragmentation: Fragmentation is an information base waiter highlight that permits you to…
Q: What indices will be visited for the sorted data below?
A: i have provided the answer in step2.
Q: 2. Write a MySQL query to fetch records that are present in one table but not in another table.…
A: Q 2. Write a MySQL query to fetch records that are present in one table but not in another table.…
Q: Q3. Redraw with suitable modification in the same style given below after identifying errors in…
A: The given diagram shows a data flow for student registration for available courses. When there is no…
Q: __________ is a contiguous group of blocks allocated for use as part of a table, index, and so…
A: Task :- choose the correct option for given question.
Q: Identify the output based on the following query given below. Select TRUNC (55.926. 0) from dual: O…
A: SELECT TRUNC(55.926, 0) from dual; o/p Number of Records: 1 TRUNC(55.926, 0) 55 If instead…
Q: Vlew can be defined as one of the existing tables in the database O True False
A: FALSE
Q: Courseld CourseCode CourseName Capacity Instructorld 7994 CS168 125 HIST64 175 8914 5024 8367 8901…
A: Given Tabel1:- Course Table Table2:- Instructor SELECT CourseNameFROM CourseWHERE…
Q: (MySQL) The data tables were too long to post here. Q1. Use TopBabyNamesbyState.csv1 and write…
A: To count distinct names in table , we use select count(distiinct colName) from tableName I have used…
Q: ase to phpMyAdmin, you should be able to view it’s four tables. 1) From the countrylanguage table,…
A: Import the “world.sql” database to phpMyAdmin, you should be able to view it’s four tables. 1) From…
Q: The pg2.np_2016traffic table contains monthly traffic statistics from the National Park Service for…
A: Given : we have to create a new table which will contain monthly traffic statistics with park names.…
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: What indices will be visited for the unsorted data below?
A: Related to the Java. Target = -3 a) 0 1 2 3 4 5 6 7 8 b) 0 c) 0 1 2 3 4 5 6 7 8 9 d) None of these…
Q: a) Insert a new record in the course table with the following data values course number = 'COSC4390'…
A:
Q: Please write SQL codes to create a sequence and name it member_seq and use it to populate below data…
A: Given: Write SQL codes to create a sequence and name it member_seq and use it to populate below data…
Q: The data in flat files has been provided: INVOICE TABLE INVOICE_NUM CUSTOMER_ID INVOICE_DATE…
A: Answer :-
Q: Problem 20.a Using MySQL, create a table named CUST_MYSQL with the same fields as in Problem 16,…
A: Note:please don't post more than 1 question in 1 post. we are only allowed to solve one question.…
Q: Design and Implement “To do list” app same as shown below, save data in local database (SQLite) and…
A: To Do List Android App: Android is a mobile operating system. As we know the demand for Android…
Q: Which of the following is a pre-condition for binary search? sequence size must be an even number…
A: In binary search the sequence must be ordered.
Q: The query provided is giving me errors (see below). Can you assist? Msg 4104, Level 16, State 1,…
A: yes , given query is wrong because x2,id is not present any where in table .nso i am writing new…
Q: Find a Pandas function that can be used to remove columns based on the column name. Store the…
A: Given: # Removing columns# Remove the 'cubicinches', 'weight lbs', 'brand ' columns#Store the…
Q: Create the BusinessdB database using MSSQL with the two given table. Create a stored procedure name…
A: Databases are a collection of objects like tables, views, stored procedures, functions, etc. In MS…
Q: Write a PHP script to insert employee data (Id, Name, Department, Salary) into emp_data table.
A: Create and initialize variables for host, username, password and database. Then create connection…
Q: 11. Which of the following statements is true with regard to BCNF tables, i.e. Boyce-Codd Normal…
A: The given question are multiple choice selected question.So can I explained in detail.
Q: Xn+1 = X + 0.25 Based on the relation above, write a code that calculates the values of Xn+1 for…
A: Program approach:- Import a package to standard I/O. Define a class. Define the main function.
Q: create oracle code to add, modify and remove detail
A: oracle code to add, modify and remove detail:
Q: Which of the following can contain repeating groups?a. unnormalized datab. 1NFc. 2NFd. 3NF
A: "Unnormalized data" can contain repeating groups. Hence, correct answer is option (a).
Q: Which of the following has no repeating groups but can contain partial or transitive dependencies?a.…
A: First-Normal Form (1NF): If a table does not contain any replicate fields or groups of fields,…
Q: If a column has high selectivity or cardinality, which index type is most appropriate?a. IOTb.…
A: B-Tree: The indexes of the B-Tree are appropriate for high selectivity or cardinality. By sorting…
Q: Using MySQL, create a table named CUST_MYSQL with the same fields as in Problem 16, except, use the…
A: Creating a table Here the column name is taken as column1, column2 and so on. The auto increment…
Q: Choose all of the correct superkeys.) Find all superkeys of the DEPARTMENT relation. Its primary key…
A: Super key means a set of one or more attributes which uniquely represents a tuple. Given primary key…
Q: Create MySQL tables and fill it with any data (that you need to use ROLLUP and CUBE) and use ROLLUP…
A: Note:- CUBE is not yet supported in mysql , it is supported in other databases like oracle.
Q: Problem 2: Create a Dataframe whose index is winery and whose values is the maximum number of points…
A: The solution to the given question is: import csv import pandas as pd with…
Q: 17. Update the salary of the instructors by making it 50000 if it is less than 50000 and 90000 if it…
A: SQL query Information on integrity constraint
Q: Update the name of the student to "John Doe" where its id is 10. Enter your answer 5. Modify the…
A: The SQL queries are given below: Note: In the second query I have not added the NULL keyword because…
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: There are two tables holding twenty data whose starting address is 3000H and 3020H respectively. WAP…
A: Answer: LXI B,3000H // Load register pair immediate, 3000H is stored in BC pair LXI H,3020H…
Q: A __________ connects to a data source and can retrieve and update data from a table in a data…
A: Table adapter: It gives communication between the application and a database. The database is…
Q: "natural join" in a relational database takes two tables of lnformation and combines entries from…
A: C = [ {A38182818,Spring2021,Math230,01,Su,A38182818},…
Q: What is the name of the table adapter method that uses a current copy of the data to populate the…
A: Introduction: \The table adapter's Fill() function populates the dataset with a current copy of the…
Q: A summarize table can be edited in Transform Data? True False
A: Defined the given statement true or false
Q: Populate the tables with the following data, Save and print a copy of each table.
A: Query to populate the tables with the given data is as follows, create table BOOK(bookID…
Q: Which of the following is a pre-condition for binary search? sequence must consist of binary numbers…
A: Binary search- It is an algorithm to search for an item in a sorted list of items.…
Q: Identify the output based on the following query given below. Select ROUND(55.926, -1) from dual: O…
A: Please find the answer below :
Create a data dictionary for this receipt
Step by step
Solved in 2 steps with 3 images
- An agency called Resourcecover supplies part-time/temporary staff to hotels throughout Mauritius. The table shown in Figure 1 lists the time spent by agency staff working at two hotels. The National Insurance Number (NIN) is unique for each employee. NIN contractNo HrsPerWeek empName HotelNo HotelLocation 125WD C1024 16 Samuel Н25 Grandbay Fody 142XA C1024 24 Dev Samy Н25 Grandbay 169YD C1025 28 Sara Ally H4 Tamarin 125WD C1025 16 Samuel Н4 Tamarin Fody Figure 1: Resourcecover i. The table shown in Figure 1 is susceptible to update anomalies. Provide examples of insertion, deletion, and update anomalies. i. Describe and illustrate the process of normalising the table shown in Figure 1 to 3NF. State any assumptions you make about the data shown in this table.Supplier PK PK Id FK CompanyName ContactName Contact Title City Country Phone Product Fax Id ProductName Supplierld UnitPrice Package IsDiscontinued Northwind Traders (Simplified) Order Johan | April 14, 2020 PK Id FK OrderDate OrderNumber Customerld TotalAmount Orderltem PK FK Orderld FK Productld UnitPrice Quantity ld Customer PK Id FirstName LastName City Country PhoneTable 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 level
- Q Normalize the following table up to 3 NF Ono Odate CustCN CustName City Phone PCode Pname CatId CatName Qty UPrice 1/12/2017 6893692 Amani Ruwi Marker Stationary Hardware Stationary Sports Stationary Stationary Sports 196 95251456 M1 150 1.2 R1 Printer 10 35 Pencil Football P3 173 1 190 1/11/2019 6893692 Amani Ruwi 95251456 P1 1 4 Pencil Marker Football P3 2 173 1 200 2/12/2020 1232345 Ahmed Salalah 898989980 M1 200 1.2 P1 1 5 4Member ID 1582 2587 3549 9536 2567 2154 3265 8765 3259 6540 First Name Mara Philip Kathleen Sau Shanice Chase Tommie Dorcas Angel Weston BookingID 1 2 3 4 5 6 7 8 Table 1: Member Last Name Gender Age Female 25 Male 36 Female 25 United States Female 25 United States Hashimoto Gent Hanner Pfau Mccrystal Karner Jia Darity Sanor Martina Room Room 15 Room 25 Room 1 Room 15 Room 5 Room 21 Room 3 Room 8 Date 29-Dec-2020 9-Dec-2021 3-Mar-2019 4-Sep-2021 13-Feb-2021 6-May-2021 10-Nov-2020 4-Apr-2022 Table 2: Booking Days 2 4 6 5 10 6 5 Female 36 Male 37 Male 26 Female 37 Male 24 Male 23 4 Table 3: Make MemberID 3549 9536 6540 2154 2567 2154 3265 1582 $150.00 $80.00 $120.00 $300.00 Country Uganda France 3 4 China Australia United States United States Cost per day $200.00 $80.00 $80.00 $150.00 5 6 7 8 France China BookingID 1 2 Joined Date 16-Aug-2020 21-May-2015 12-Dec-2017 16-Aug-2019 16-Aug-2020 1-Jan-2021 29-Dec-2018 21-May-2019 4-Mar-2019 1-Feb-2022 Status Paid Paid Pending Paid Pending Paid…CUSTOMER CID CNAME CITY Smith London Jones Paris Clark London Adams Athens 1. 1 C1 2 C2 3 C4 4 C5 RENT RDATE 1 C5 F2 02-OCT-14 2 C5 F3 04-SEP-14 3 C5 F5 16-APR-17 4 C1 F5 16-APR-17 5 C1 F2 02-OCT-14 6 C1 F3 04-SEP-14 7 C2 F2 01-APR-14 8 C4 F2 01-JAN-14 CID FID Create three tables a. Customer b. Rent c. Film 2. Define appropriate data type and data size 3. Define column constraints FILM FID 1 F2 2 F3 3 F4 4 F5 5 F7 FNAME The Others Senseless Dragon Heart 007 Sweetheart PRICE TYPE 1.44 HORROR 5.99 COMEDY 6 DRAMA 5 ACTION 5 COMEDY 4. Specify Integrity/Domain/Primary Key/Referential Integrity constraints a. Primary key b. Foreign key E.g.) CONSTRAINT rent_fk_c FOREIGN KEY cid REFERENCES customer ON DELETE CASCADE c. The price of a film ranges from 0.50 to 19.99 d. A film can only have the type of Action, Horror, Comedy, Drama, and Education
- SALESREP SalesRepNo 654 734 345 434 RepName Jones Smith Chen Johnson HireDate 01/02/2005 02/03/2007 01/25/2004 11/23/2004 CUSTOMER CustNo 9870 8590 7840 4870 CustName Winston Gonzales Harris Miles Balance 500 350 800 100 SalesRepNo 345 434 654 345Customers customer_id address_id first_name PK Addresses FK address_id city PK last_name phone state country note note Factors Рayment Factor_id customer_id PK FK peyment_method_id PK payment_method_id FK payment_name date note note Factor_items goods Good_groups good_id good_code good_name PK factor_id good_id quantity FK good_group_id PK FK name taxrate good_group_id good_cost FK Price note note ***Use Oracle SQL* • Write a trigger to save all modification on table Goods. (Update and Delete).Table 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…
- TABLE 4-6 Parking Tickets at Millennium College Parking Ticket Table St ID L Name F Name Phone No St Lic Lic No Ticket # Date Code Fine 38249 Brown Thomas 111-7804 FL BRY 123 15634 10/17/12 2 $25 16017 11/13/12 1 $15 82453 Green Sally 391-1689 AL TRE 141 14987 10/05/12 $100 16293 11/18/12 1 $15 17892 12/13/12 2 $25 1. Convert to INF Relation 2. Draw dependency diagram showing all functional dependencies 3. Identify anomalies 4. Convert to 3NF Relations 5. Develop EER Diagram with appropriate cardinalitiesQ9. Write an SQL statement to answer the question: 'Are there any bookings not driven by qualified drivers, i.e. driver tvpe not matching vehicle type?’ The resulting table is as follows. BOOK ID VEH_DESC YEH_TYPE 1 8728 Volvo FM12 Medium Truck Vincent Ma LGV DRIVER_MAME DRIVER_TYPE BOOK_DATE BOOK_TIME BOOK_HRS |2022/3/4 14:30 2 Q10. In view of the possible problem as per Q9, suggest a way to prevent such booking. You may consider running query to highlight this or changing the data model to prevent so. Explain your suggestion.estion Completion Status: AIRPORT FLIGHT AIRPORTCODE FLIGHTNUM FK AIRPORT1 CUSTOMER AIRPOR NAME DTIME CUSTOMERNUM CITY DDATE FIRSTNAME ATIME ADATE DESTINATIONAIRPORT PRICE AIRPLANENUM(FK) AIRPORTCODE(FK) STATE MIDDLENAME LASTNAME 3. STREETNUMBER STREETNAME CITY FK AIRPORT I STATE PHONE 1. FK AIRPLANE FK_FLIGHT FK CUSTOMER AIRPLANE AIRPLANENUM PAYMENT FLIGHTNUM(FK AIRPLANENAME CUSTOMERNUM(FK) CAPACITY CREDITCARDTYPE AIRPORTCODE(FK) CREDITCARDNUM BOOKDATE HOLDDATE EXPIREDHOLDDATE A. 1 How many primary key in the Flight entity? B.5 How many tables in the system can Customer table retrieve data from? C. 4 How many attributes in the Airport Table? D.5 How many tables in the system? E. 5 How many relationships shown in the system? Click Save and Submit to save and submit. Click Save All Answers to save all ansuwers.