You are required to create the following tables in a database
Q: A major issue in recent presidential campaigns has been whether the income tax on high income earner...
A: The answer is given below for the above-given question:
Q: Give a CFL for the language L (over the alphabet {a, b}), where L = {w | w has exactly the same numb...
A: Below i have drawn:
Q: f deploying repeaters, gateways and a DMZ in installing a secured IT network. Also, justify the plac...
A: given - Demonstrate the significance of deploying repeaters, gateways and a DMZ in installing a secu...
Q: Is anybody familiar with John von Neumann's basic schooling?
A: John von Neumann was former mathematician and computer scientist . He presented von Neumann architec...
Q: 1. The "coupled tank" problem is described as a set of two differentlal equations as follows: A1. (d...
A: The tank above is filled at a stream pace of Qin m3/sec which is the contribution to the framework....
Q: The goal of the maximal flow problem is to maximize the amount of flow of items from an origin to a ...
A: your question is about Discuss The goal of the maximal flow problem is to maximize the amount of flo...
Q: Is a monochrome printer able to produce colour?
A: THE ABOVE QUESTION THAT IS MONO CHROME PRINTER THAT ABLE TO PRODUCE COLOUR IS ANSWERED BELOW
Q: Alice and Bob use the ElGamal scheme with a common prime q= 131 and a primitive root a = 6. Let Bob’...
A: The answer is
Q: What is the difference between a motherboard and a CPU?
A: ALU: The ALU, or arithmetic logic unit, located inside the CPU, or central processing unit, executes...
Q: Complexity The function accumulate operates on a list of n integers where each element was chosen in...
A: Answer: I have given answered in the handwritten format in brief explanation.
Q: Tell me about the internet camera. In your opinion, what are the benefits and drawbacks of each?
A: Answer: Digital video cameras that broadcast and receive data through a network or the internet are ...
Q: In Java Determine the output of the following code. Place a box around your answer. int i = 30, j...
A: Given condition is : while(i>=j) Here i = 30 , j = 10 if(i>j+10) Print no Here 30> 20 Hen...
Q: In what university did John von Neumann attend?
A: Answer John Neumann attended ETH Zurich and Eotvos Lorand University
Q: Q10: If the coordinates of a vector W in xyz axis is : W 50x +35y +20z. Wha its distance from the or...
A: According to the information given:- We have to find the distance from the origin of vector coordina...
Q: Convert the following NFA to a DFA and then to a minimal DFA. Please show all steps. a 3 start 9. 8....
A:
Q: In what year did John von Neumann create the computer, and how?
A: Introduction: John von Neumann: Hungarian-born mathematician and chemical engineer John von Neumann ...
Q: Defintion: What is a workstation keyboard, and how does it work?
A: workstation keyboard is an electronic sound playing device which contains white and black keys .
Q: Without using truth tables, show that (p→q) ^ (q → r) → (p→ r) is a tautology. Show supporting evide...
A: Proved given preposition is tautology
Q: IN PYTHON Design a program that has the following: Inputs: Last Name, First Name, Middle Name, Birth...
A: Given The answer is given below.
Q: Design a program that gives simple math quizzes. The program should display two random numbers that ...
A: NOTE - I have used the Python programing language. Here I have created 2 random numbers and then pri...
Q: What is personal cloud storage, and what is the difference between it and other cloud storage option...
A: We need to discuss personal cloud storage, and the difference between it and other cloud storage opt...
Q: How to convert tableau data (multivariate data) into image data ? I know how to apply the machine le...
A: Tableau is a Business Intelligence tool for data analytics. Users can create and distribute a collab...
Q: Please code in python Being tired of the challenging assignments given by the MCS Professors, stu...
A: According to the information given:- We have to follow the instruction mentioned to get desired outp...
Q: The following terms are synonymous: O a. Block and line
A: Q1)The following terms are synonymous: Answer: Option 4 -Row and block Direct mapped cache has each...
Q: (c) Find the sum-of-products expansion of the following Boolean function: f(a, b,c) = a(b + č) + ab ...
A:
Q: We are given a binary tree T and two external nodes u and v. write an algorithm to find the length o...
A: The solution to the given problem is below.
Q: Write a program to perform non-preemptive SJF scheduling. Consider four processes. The digits of you...
A: Actually, program is an executable software that runs on a computer.
Q: Is there an online service that offers computer users hard drive storage?
A: An Internet-based data center that provides data storage as a service and administers it as a cloud ...
Q: Write the code for adding new elements dynamically.
A: Your solution is here with an output .
Q: You have a user who uses a laptop running Windows 10 Enterprise. When the user uses his work compute...
A: Answer is in step 2
Q: Program9.java Two files are required, a data class named Car and an executable class named CarsTest...
A: Step 1 The answer is given in the below step
Q: Connecting more peripherals to a computer is made possible by the .
A: Peripheral Device: A peripheral device is a computer device, such as a keyboard or printer, that is ...
Q: Alice and Bob use the ElGamal scheme with a common prime q= 131 and a primitive root a = 6. Let Bob’...
A: Answers Step 1 : Key generation Common prime q=131 primary root αα = 6 Bob's public key YBYB =3 R...
Q: What is an example of the differences in using precision and recall compared to the confusion matrix...
A: answer is
Q: Show the {(p V q ) ^ not p} implies (q V not q)
A: Logic of implies says that If A is true then B must be true, if A is not true then B can be anythin...
Q: Create a program to input the quantity and price of 5 products named P1, P2, P3, P4, and P5. Then di...
A: Create a JAVA program to input the quantity and price of 5 products named P1, P2, P3, P4, and P5. Th...
Q: WEB DEVELOPER EXERCISE 1) Write a Javascript program to validate an email assuming it is taken from ...
A: The solution to the given problem is below.
Q: What is the definition of a gaming laptop computer?
A: Introduction: A gaming laptop is a tiny and portable personal computer with an integrated display. A...
Q: 1. Compare the-chemical reactivity of calcium and magnesium.
A: We are required to answer the first one in cases with many questions.
Q: I Need to write a program based on the following Java program PercolationEstimation.java that uses b...
A: PercolationEstimation.java:- Solution is given below:-
Q: hello你好阿很高興可以認識你呢,不知道有沒有機會可以交個朋友呢
A: The solution to the given problem is below.
Q: Imagine you are in a directory with a lot of image files (.jpg, .jpeg, .png, .gif). Write a script t...
A: Below i have answered:
Q: QIA) Using asterisk (*) pattern to write a program in C++ to display such below style:
A: Answer is giving below-
Q: What is iCloud storage, and how does it differ from other cloud storage services?
A: The iCloud is a cloud storage and cloud computing service provided by Apple Incorporation.
Q: achieve performance improvement by using system engineering? What is the benefit of using modeling a...
A: given - What is the purpose of system engineering? How to achieve performance improvement by using s...
Q: Which portion of the CPU is responsible for processing
A: The brains of computers, also known as processors, are responsible for carrying out the millions of ...
Q: What is the process used to compute the general average? 2. What programming structure is used, enab...
A: The answers are given as per the page number 51.
Q: 1. Create a program that will get the square and sum of a series of number (13) + (2²) + (3²) + (42)...
A: Here is your solution with source code and output.
Q: python" Call the function tourism with the arguments 1 and 4 (in that order) and print the value the...
A: 0.30959752321981426
Q: In what year did the keyboard first come to be known as?
A: Keyboards: Today's computer keyboard is referred to as the QWERTY keyboard. It is called after the f...
This question relates to creating and altering tables, as well as implementing constraints and referential integrity.
Q.1.1 You are required to create the following tables in a
EMPLOYEES
EMPLOYEE_ID VARCHAR(5) NOT NULL PRIMARY KEY
EMPLOYEE_NAME VARCHAR(30) NOT NULL
EMPLOYEE_SURNAME VARCHAR(30) NOT NULL
DATE_OF_BIRTH DATE NOT NULL
DOCTORS
DOCTOR_ID VARCHAR(5) NOT NULL PRIMARY KEY
DOCTOR_NAME VARCHAR(30) NOT NULL
EMPLOYEE_SICKLEAVE
EMPLOYEE_ID VARCHAR(5) NOT NULL PRIMARY KEY
FOREIGN KEY REFERENCES
EMPLOYEES(EMPLOYEE_ID)
START_DATE DATE NOT NULL PRIMARY KEY
DOCTOR_ID VARCHAR(5) NOT NULL
NUMBER_OF_DAYS SMALLINT NOT NULL
Q.1.2 Populate the tables created in Q.1.1 with the following data:
EMPLOYEES
EMPLOYEE_ ID EMPLOYEE_NAME EMPLOYEE_
SURNAME
DATE_OF_BIRTH
I0001 Dominique Woolridge 1993-04-19
I0002 Nico Baird 1991-11-19
I0003 Derek Moore 1992-06-24
I0004 Neo Petlele 1993-12-29
I0005 Andrew Crouch 1994-01-30
DOCTORS
DOCTOR_ID DOCTOR_NAME
D0001 Thabo Ntlali
D0002 Deon Coetzee
D0003 Kwezi Mbete
D0004 Trevor January
D0005 Julia Robins
EMPLOYEE_SICKLEAVE
EMPLOYEE_ID DOCTOR_ID START_DATE NUMBER_OF_DAYS
I0001 D0004 2019-01-25 2
I0002 D0001 2019-05-14 1
I0003 D0003 2019-06-07 5
I0003 D0002 2019-06-29 15
I0004 D0001 2019-08-01 3
I0005 D0004 2019-10-22 9
I0005 D0001 2019-12-28 4
Step by step
Solved in 2 steps
- You are given the following database schema:Sailors(sid, sname, rating, age)Boats(bid, bname, color)Reserves(sid, bid, day)Consider the join on Sailors ▷◁ Reserves and assume that you have the following statistics andlimitations: * You have available 9 pages in main memory.* Sailors: 100000 tuples, 1000 pages; Boats: 2000 tuples, 10 pages; Reserves: 110000 tuples,550 pages 1. Calculate the I/O cost of this join using the Block Nested Loop algorithm?This is my attempt at DBDL statements trying to plan a database in MySQL. Employers: CREATE TABLE Employers ( EmployerID INT PRIMARY KEY, CompanyName VARCHAR(255), Location VARCHAR(255), ContactInfo VARCHAR(255), ); Customers: CREATE TABLE Customers ( CustomerID INT PRIMARY KEY, Name VARCHAR(255), ContactInfo VARCHAR(255), Education VARCHAR(255), Experience INT ); Reference: CREATE TABLE References ( ReferenceID INT PRIMARY KEY, Name VARCHAR(255), ContactInfo VARCHAR(255), RelationshipToCustomer VARCHAR(255) ); Skills: CREATE TABLE Skills ( SkillID INT PRIMARY KEY, SkillName VARCHAR(255), ProficiencyLevel VARCHAR(255) ); EmploymentPositions: CREATE TABLE EmploymentPositions ( PositionID INT PRIMARY KEY, PostionTitle VARCHAR(255), EmployerID INT, Duration VARCHAR(255), FOREIGN KEY (EmployerID) REFERENCES Employers(EmployerID) ); Interviews: CREATE TABLE Interviews ( InterviewID INT PRIMARY KEY, InterviewDate DATE, Interviewer VARCHAR(255), Feedback VARCHAR(255) ); HiringStatus:…You are given the following database schema:Sailors(sid, sname, rating, age)Boats(bid, bname, color)Reserves(sid, bid, day)Consider the join on Sailors ▷◁ Reserves and assume that you have the following statistics andlimitations: * You have available 9 pages in main memory.* Sailors: 100000 tuples, 1000 pages; Boats: 2000 tuples, 10 pages; Reserves: 110000 tuples,550 pages 1. Calculate the I/O cost of this join using the Block Nested Loop algorithm? 2. Calculate the I/O cost of sorting the Sailors relation?
- Consider the following database in Prolog:birthday(tom).birthday(fred).birthday(helen),birthday(jack).happy(mary).happy(jane).happy(helen).happy(albert).attendparty(jane).attendparty(helen).hold_party(X): - birthday(X), happy(X) What would be the answer to the following query??- hold party(Who) a. Who = jane.b. Who = mary.c. Who = helen.d. All of the above.e. Who cannot be unified / instantiated.A database has 4 transactions, shown below.TID Date items_boughtT100 10/15/04 {K, A, D, B}T200 10/15/04 {D, A, C, E, B}T300 10/19/04 {C, A, B, E}T400 10/22/04 {B, A, D}Assuming a minimum level of support min_sup = 60% and a minimum level ofconfidencemin_conf = 80%:(a) Find all frequent itemsets (not just the ones with the maximum width/length) using the Apriori algorithm. Show your work—just showing the final answer is not acceptable. For each iteration show the candidate and acceptable frequent itemsets. You should show your work similar to the way the example was done in thePowerPoint slides.(b)List all of the strong association rules, along with their support and confidence values, whichmatch the following metarule, where X is a variable representing customers and itemi denotes variables representing items (e.g., “A”, “B”, etc.).x transaction, buys(X, item1) buys(X, item2) buys(X, item3)Hint: don’t worry about the fact that the statement above uses relations. The point of the…We have the following functional dependency A -> B. The following is a well-formed database design. MYTABLE (TheKey, A, B, C) True False
- Which of the following database operations should be handled with extra care?Think about a student database with the StudentID as the main key and the Major, Age, MaritalStatus, and HomeZipCode indexes (all secondary keys). If the institution requested a list of MIS or computer science majors who were over 25, married, and from the 45462 zip code OR computer engineering majors who were single and from the 45462 zip code, then let's pretend they were both over 25 and from the 45462 postcode. How can indexes be used to guarantee that only the data that satisfies this criteria is accessible to users?We need to create a database for the Circulation Department of a public library. The database will store information about the patrons, books, and circulation. It contains the following: 4 tables for the database: PATRON, BOOK_COPY, BOOK, and CHECKOUT. (Since a book may have multiple copies that may be purchased by the library at different time, it is better to have a BOOK_COPY table to avoid unnecessary data redundancy.) The data in the tables are as follows: PATRON table records a patron’s ID, name, address, phone number, and email address. BOOK table contains information such as author, title, publication date, subject, language, and a unique identifier (It can be the ISBN of the book) for each book. BOOK_COPY table records a unique identifier for each copy of a book, the date of purchase, and the identifier of the book from the BOOK table. CHECKOUT table records the date of check-out, patron’s ID, the…
- We need to create a database for the Circulation Department of a public library. The database will store information about the patrons, books, and circulation. It contains the following: 4 tables for the database: PATRON, BOOK_COPY, BOOK, and CHECKOUT. (Since a book may have multiple copies that may be purchased by the library at different time, it is better to have a BOOK_COPY table to avoid unnecessary data redundancy.) The data in the tables are as follows: PATRON table records a patron’s ID, name, address, phone number, and email address. BOOK table contains information such as author, title, publication date, subject, language, and a unique identifier (It can be the ISBN of the book) for each book. BOOK_COPY table records a unique identifier for each copy of a book, the date of purchase, and the identifier of the book from the BOOK table. CHECKOUT table records the date of check-out, patron’s ID, the…We need to create a database for the Circulation Department of a public library. The database will store information about the patrons, books, and circulation. It contains the following: 4 tables for the database: PATRON, BOOK_COPY, BOOK, and CHECKOUT. (Since a book may have multiple copies that may be purchased by the library at different time, it is better to have a BOOK_COPY table to avoid unnecessary data redundancy.) The data in the tables are as follows: PATRON table records a patron’s ID, name, address, phone number, and email address. BOOK table contains information such as author, title, publication date, subject, language, and a unique identifier (It can be the ISBN of the book) for each book. BOOK_COPY table records a unique identifier for each copy of a book, the date of purchase, and the identifier of the book from the BOOK table. CHECKOUT table records the date of check-out, patron’s ID, the…I can't get the coding right on this one, I think I'm missing something here. Can anyone help please? 1.11 LAB - Query execution plans (Sakila) This lab illustrates how minor changes in a query may have a significant impact on the execution plan. MySQL Workbench exercise Refer to the film, actor, and film_actor tables of the Sakila database. This exercise is based on the initial Sakila installation. If you have altered these tables or their data, your results may be different. Do the following in MySQL Workbench: Enter the following statements: USE sakila; SELECT last_name, first_name, ROUND(AVG(length), 0) AS average FROM actor INNER JOIN film_actor ON film_actor.actor_id = actor.actor_id INNER JOIN film ON film_actor.film_id = film.film_id WHERE title = "ALONE TRIP" GROUP BY last_name, first_name ORDER BY average; Highlight the SELECT query. In the main menu, select Query > Explain Current Statement. In the Display Info box, highlighted in red below, select Data Read per Join.…