Given the Employee, Class, and Training tables. Employee Emp_id (PK) Name Address Phone Email Ali ali@yahoo.com nazire@gmail.com katrina@gmail.com lemi@hotmail.com alican@yahoo.com mustafa@hotmail.c hasan@gmail.com EM8765 USA 98733211 EM3456 Nazire Dubai 98764533 90857464 EM7658 Katrina USA EM1987 Lemi USA 99663425 Alican Mustafa Hasan EM8009 UK 95583372 EM7698 Dubai 92234452 EM6666 Jordan 92123366 Class
Q: 2. (a) Is it possible to have a forest with 13 vertices and 10 edges? (b) Is it possible to have an ...
A: INTRODUCTION: We need to tell that forest with 13 vertices and 10 edges.
Q: Write down the transition function values for each state and symbol for the DFA in question 1(a) and...
A: For the given language in 1.a which is: A language that accepts strings of length not more than 5 an...
Q: 2. Consider the following plaintext message. Happy Friday a. What is the corresponding ciphertext if...
A: Transportation cipher using python
Q: MATLAB In MATLAB, Compare the usage of the script and function and state their similarities. State ...
A: MATLAB files comes in two types:- SCRIPTS FUNCTIONS Lets compare both of them one by one :- Scrip...
Q: Discuss the use of the term "accuracy" in categorization difficulties. Is it a good or terrible idea...
A: Discuss:- The accuracy in classification problem. Whether it is good or bad to measure the performa...
Q: in java create a lexical parse tree that displays ( 0 + 1 ) * 10 from an text input file
A: Let's see the solution in the next steps
Q: Consider this scenario: An exception is thrown when a function is called. What are the three things ...
A: An exception is thrown when a function is called. Things can do by the function is try-catch, throw...
Q: 3. Let ,, and . a. Find ANB. b. Find AUB. c. Find A-B. d. Find. e. Find AXC. f. Is CCA? Explain. g. ...
A: Assume A= { a,b,c,d } B= { c,d,e,f } C={ c,d,e,f }
Q: In what ways will PSP contribute to the whole process of software product development and management...
A: Introduction: The personal Software process is the process by which the engineers and human resou...
Q: Write a function myfunction that requests user input i the form of an integer value, 1, 2 or 3. The ...
A: For the given function, we will be using an if control statement inside an infinite while loop on us...
Q: = ax+b is
A: 1) f(x) = ax+b is O(x2) 2) explain a condition where the code isn't O(x). also prove witness and gra...
Q: Why can't IP address ranges from different VPCs or VNets overlap? As an example, identify two IP add...
A: Introduction: If a host is attached to a network with the IP address 192.168 10.0/24 and the other d...
Q: How does I.R.M. Relate to Information Engineering and Systems?
A: IRM stands for Information Resource Management and it is a form of security technology used to prote...
Q: Write a in C++ Using take while loop from your entered will that पन्ीिनति in string anay input and u...
A: the c++ code is an given below :
Q: What precisely is the Internet Explorer Box Model Bug, and how does it affect your browsing experien...
A: Introduction: The Internet Explorer box model problem refers to how previous versions of Internet Ex...
Q: Write the code to check if y is between 100 and 150 (including 150 only
A: The given code is in the C programming language Code Screenshot:
Q: People find it easier to read time in hours, minutes, and seconds rather than just seconds. Write a ...
A: The number of seconds in an hour are 60 * 60 = 3600, the number of seconds in a minute are 60. These...
Q: Computers manipulate information and carry out binary instructions. What exactly is binary's purpose...
A: To understand human instructions, computers employ the binary system. Binary 1 denotes a positive pu...
Q: Prove that {02"|n 2 1 and n E N} is not regular using the Pumping Lemma
A: Here, I have to prove the given language is not regular using pumping lemma.
Q: What role do individuals play in a computer system?
A: Introduction: Information System Information systems (IS) refers to the combination of hardware and...
Q: Given an input string, a non-empty substring subs, and a non-negative number n, compute recursively ...
A: Code works perfectly. I am providing code in java. Please use proper indentation for no error. Follo...
Q: Expan the application of the complex instruction SAVE CONTEXT and LOAD CONTEXT and explain the situa...
A: Context Switching A context switching is a process of storing the state of a process or thread in or...
Q: 9 import java.util.Scanner; 10 //Creating a class 11 - public class Main{ 12 // Driver code public s...
A: the output is tax calculation based onn input amount and then the total amount including tax.
Q: Given the Sailor, Boat, and Reservation tables. Sailor Table Reservation Table ID (PK) NAME RATING A...
A:
Q: he term cache pollution refers to the situation where more than one process is running concurrently ...
A: Introduction: Here we are required two choose the correct option of the question given above.
Q: Explain how many programing language are there?
A: The programming language is a set of rules that have a specific syntax and are used for creating sof...
Q: What is the matehmatical machine on which both top-down and bottom-up parser are based? Reduction Su...
A: Introduction: The question is about the matehmatical machine on which both top-down and bottom-up pa...
Q: Please someone hlep me, based on the java code given how can i make the change to program run like t...
A: Program Done in Java
Q: Corollary 5.6. (i) If G is a connected simple planar graph with (n> 3) vertices and m edges, then m ...
A: Here, we are going to derive given corollary using graph theory rules.
Q: Using JAVASCRIPT, print the count of all the vowels present in the string "Data Structures and Algor...
A: INTRODUCTION: In the given problem statement, we are asked to print the count of all the vowels that...
Q: What are smart pointers, exactly? What purpose do they serve?
A: Introduction: A Smart Pointer is a pointer wrapper class with overloaded operators such as * and -&g...
Q: What are the different models for software requirements, and their advantages and disadvantages in r...
A: Advantages and disadvantages of different software models Thesoftware model is an abstract represent...
Q: Long method or long method is a term for a method that has too many lines. In general, methods that ...
A: Meаsure: the number оf things they dоА funсtiоn саn аlsо be meаsured by the number оf...
Q: What is a data warehouse and what are its advantages and disadvantages? What is the data warehouse's...
A: Introduction: A data warehouse (DW or DWH), sometimes known as an enterprise data warehouse (EDW), i...
Q: Martha created a list of 10 elements but forgot to insert one element into the list. Write a Python ...
A: Write a Python program to input the index and the value of the element missed by Martha and add that...
Q: Program to input the elements(integer type) of a array of size 17 and check if all the elements of t...
A: Code: class Main{ public static void main(String args[]){ int a[]={33,3,4,5,5,8,96,23,11,56,78...
Q: Explain why it is logical to presume that advances in information technology are driven by people an...
A: Introduction: People and information systems are the driving drivers behind information technology a...
Q: Give a recursive definition for an (where n=1,2,3,...) if an=2n+5
A: Below is the recursive definition for an=2n+5: a1=7,a2=9........an=2n+5 Now from above we get : lang...
Q: 1. In the following operating systems architectures, discuss how servers that require direct access ...
A: А mоnоlithiс kernel is аn орerаting system аrсhiteсture where the entire орerаting syste...
Q: Ex: If the input is: 2000 2 the output is: 1000 500 250 Note: In Java, integer division discards fra...
A: Introduction:
Q: what are the data structures that one needs to implement a radix sort algorithm? What is the purpose...
A: Radix sort sorts integers on the basis of digits of the number. It sorts the numbers from least sign...
Q: What does it mean to have a gaming laptop computer?
A: Introduction: A gaming laptop is a small and portable computer that has a monitor.
Q: Question 18 "With ISAM, Overflows of data blocks cause insertion into an overflow area Selected Answ...
A: As per company guidelines we are suppose to answer only 1 question. Kindly re-post other questions ...
Q: To answer this question, you may need to write a small program. Consider the following case: current...
A: Introduction To answer this question, you may need to write a small program. Consider the following ...
Q: tch (m) {case 0: printf(" the number is low\n"); break; case 1:
A: Code: #include <stdio.h> int main (void) { int m; printf ("enter an integer number between...
Q: what is emerging technology?
A: This question comes from Computer and Technology Evolution which is a paper of computer science. Let...
Q: What are the differences between the many types of system units found on desktop computers, laptop c...
A: Introduction: A system unit is a casing that houses electrical components for data processing. Most ...
Q: (a) Using a true table
A: A b a⇎b ¬(a⇎b) a ⊕ b 0 0 1 0 0 0 1 0 1 1 1 0 0 1 1 1 1 1 0 0
Q: Write a function called mysum. This function should take a single argument, an integer value (N). If...
A: For this function, we will be using an if control statement to check whether the input is negative o...
Q: rest a social netw
A: Pinterest a social network?
Step by step
Solved in 7 steps with 9 images
- CUSTOMERColumns = 7, Rows = 10 CustomerID LastName FirstName Address ZIP Phone Email 1 Shire Robert 6225 Evanston Ave N 98103 206-524-2433 Robert.Shire@somewhere.com 2 Goodyear Katherine 7335 11th Ave NE 98105 206-524-3544 Katherine.Goodyear@somewhere.com 3 Bancroft Chris 12605 NE 6th Street 98005 425-635-9788 Chris.Bancroft@somewhere.com 4 Griffith John 335 Aloha Street 98109 206-524-4655 John.Griffith@somewhere.com 5 Tierney Doris 14510 NE 4th Street 98005 425-635-8677 Doris.Tierney@somewhere.com 6 Anderson Donna 1410 Hillcrest Parkway 98273 360-538-7566 Donna.Anderson@elsewhere.com 7 Svane Jack 3211 42nd Street 98115 206-524-5766 Jack.Svane@somewhere.com 8 Walsh Denesha 6712 24th Avenue NE 98053 425-635-7566 Denesha.Walsh@somewhere.com 9 Enquist Craig 534 15th Street 98225 360-538-6455 Craig.Enquist@elsewhere.com 10 Anderson Rose 6823 17th Ave NE 98105 206-524-6877 Rose.Anderson@elsewhere.com EMPLOYEEColumns = 5, Rows = 5 EmployeeID LastName FirstName…CUSTOMERColumns = 7, Rows = 10 CustomerID LastName FirstName Address ZIP Phone Email 1 Shire Robert 6225 Evanston Ave N 98103 206-524-2433 Robert.Shire@somewhere.com 2 Goodyear Katherine 7335 11th Ave NE 98105 206-524-3544 Katherine.Goodyear@somewhere.com 3 Bancroft Chris 12605 NE 6th Street 98005 425-635-9788 Chris.Bancroft@somewhere.com 4 Griffith John 335 Aloha Street 98109 206-524-4655 John.Griffith@somewhere.com 5 Tierney Doris 14510 NE 4th Street 98005 425-635-8677 Doris.Tierney@somewhere.com 6 Anderson Donna 1410 Hillcrest Parkway 98273 360-538-7566 Donna.Anderson@elsewhere.com 7 Svane Jack 3211 42nd Street 98115 206-524-5766 Jack.Svane@somewhere.com 8 Walsh Denesha 6712 24th Avenue NE 98053 425-635-7566 Denesha.Walsh@somewhere.com 9 Enquist Craig 534 15th Street 98225 360-538-6455 Craig.Enquist@elsewhere.com 10 Anderson Rose 6823 17th Ave NE 98105 206-524-6877 Rose.Anderson@elsewhere.com EMPLOYEEColumns = 5, Rows = 5 EmployeeID LastName FirstName…A new table has been requested to support tracking automated emails sent to customers. Create the table and add data as described below. Tablename: email_log Columns: emailid (numeric), emaildate (datetime), customer# (numeric) Primary key: emailid column, define as an Identity Column Add the following data rows and display resulting rows (if any errors occur, explain why the error is expected) Emaildate = current date, customer# = 1007 Emailid = specify to use the column default value, emaildate = current date, customer# = 1008 Emailid = 25, emaildate = current date, customer# = 1009
- Year Gender Name_of_person Date_of birth Membership _type Contact_phone_no joined Contact_email 2018 Nor Kwa 03 2453 5673 2/4/2005 n.kwa@rockict.com Social Adam Mazian 082 25 4689 2016 23/5/2003 Social AdamM@abc.co.my Ahmed Othman 12/03/2006 01223 432678 2018 Junior AOthman@cie.org Zara Png 1/12/1997 123 3267 9999 2010 F Senior Zara@cbc.cnInsert the following data into your database tables.STUDENTSSTUDENT_ID STUDENT_NAME STUDENT_SURNAMES123456 Neo PetleleS246810 Derek MooreS369121 Pedro NtabaS654321 Thabo JoeS987654 Dominique WoolridgeMODULESMODULE_ID MODULE_NAME MODULE_CREDITDATA6212 Database Intermediate 30INPU221 Desktop Publishing 20PROG6211 Programming 2A 15PROG6212 Programming 2B 15WEDE220 Web Development (Intermediate) STUDENT_MODULESSTUDENT_ID MODULE_IDS123456 PROG6211S123456 PROG6212S246810 DATA6212S369121 DATA6212S369121 INPU221S369121 WEDE220S987654 PROG6211S987654 PROG6212S987654 WEDE220LECTURERSLECTURER_ID LECTURER_NAME LECTURER_SURNAMEL578963 Kwezi MbeteL876592 Julia RobinsL916482 Trevor JanuaryLECTURER_MODULESMODULE_ID LECTURER_IDDATA6212 L578963INPU221 L876592PROG6211 L916482PROG6212 L916482WEDE220 L876592Correct INSERT statements used and all data correctly inserted per table.Indicate the changes you need to make to the KimTay Pet Supplies database to support the following additional requirement. Each location has a manager who is identified by a manager ID, a manager first name, and a manager last name.
- Write an SQL query to display: The last name of the student who registered at the last. K Your output should contain 1 column in the below-mentioned order. last_nameUsing mysql client create a database named supermarket create a table named groceryitems in the supermarket database. Groceryitems table should have the following information : itemname, itemtype(i.e fruit, vegetable, pantry, meat, dairy etc), item description, price per unit, quantity available. Use appropriate data type for each of the columns. Itemname should be the primary key. Create a php page through which you can connect to the grocery database and you can insert information into the grocery table. The php page displays an interface , texboxes for itemname , textfield for item description, radio button for item type, text box for unit price , text box for quantity available and a submit button. Once you click the submit button the php file should first validate the data types inserted. After successfully adding a row of information the same php page should show a confirmation message about successful information in the table. Make the radio buttons used for…Database course: Which of the following queries is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another? SELECT UNIQUE V_CODE FROM PRODUCT; SELECT DISTINCT V_CODE FROM PRODUCT; SELECT DIFFERENT V_CODE FROM PRODUCT; SELECT ONLY V_CODE FROM PRODUCT;
- Write, but do not execute, the commands to grant the following privileges: a. User Ashton must be able to retrieve data from the ITEM table. b. Users Kelly and Morgan must be able to add new orders and order lines. c. User James must be able to change the price for all items. d. User Danielson must be able to delete customers. e. All users must be able to retrieve each customers number, name, street, city, state,and postal code. f. f User Pere7 must be able to create an index on the ORDFRS table. g. User Washington must be able to change the structure of the ITEM table. h. User Grinstead must have all privileges on the ORDERS table.CONSIDER THE INVOICE TABLE BELOW: invoice id NUMBER (12), invoice date DATE,Invoice total NUMBER (9, 2), payzent_total NUBER (9, 2), credit total NUMBER (9, 2),invoice due date DATE, payrent date DATE,CIL REC user VARCHAR2 (12),CTL SEC level NUMBER (1)Consider the INVOICE table structure below: A trigger is created on the INVOICE table: CREATE OR REPLACE TRIGGER rg_On_Quiz before insert or update on Invoice FOR EACH ROW DECLARE V_level Number; V_name VARCHAR (20); Begin SELECT USERNAME, SECURITY_LEVEL INTO V_name, V_level FROM AUTHORIZED_USERS WHERE USERNAME = USER; :NEW.CTL_REC_user := V_name; :NEW.CTL_REC_user := V_level; EXCEPTION WHEN NO_DATA_FOUND THEN RAISE_APPLICATION_ERROR (-2003, 'UNAUTHORIZED USER'); END; In Oracle/PLSQL, the USER function returns the user_id from the current Oracle session. a.) Explain what this triger does…Select employees and managers with inner join USING MYSQL The Employee table has the following columns: ID - integer, primary key FirstName - variable-length string LastName - variable-length string ManagerID - integer Write a SELECT statement to show a list of all employees' first names and their managers' first names. List only employees that have a manager. Order the results by Employee first name. Use aliases to give the result columns distinctly different names, like "Employee" and "Manager". Hint: Join the Employee table to itself using INNER JOIN.