1- Draw an ERD about a restaurant on Oracle SQL developer data modeler, it should contain at least 8 entities and each should have at least 4 attributes and then explain the relationship between each entity.
Q: How do I fix this error for HTML I keep trying to remove the li o ut of the ul and so and so but it...
A: You must wrap every inner ULs with an LI. The children (direct descendants) of a ul element must all...
Q: Differentiate and discuss briefly any four points about primary and secondary memory.
A: The Differences and explanation about primary and secondary memory is below:
Q: Suppose you have a RISC machine with a 2.7 GHz clock (i.e., the clock ticks 2.7 billion times per se...
A: Given: RISC machine with a 2.7 GHz clock. Array elements processed in 4.4 milliseconds
Q: Hints: Cipher methods are among: Shift, Affine, Substitution, Vigenere and Hill Ciphers. Alphabet al...
A: Encryption schemes, cyber-attacks are the most common type of cyber-attack: Any adversary using a ci...
Q: by reading the article. Summarize each of
A: Open source software is a software that is open to study,analyse and modify the software Open sourc...
Q: (The Rectangle class) Following the example of the Circle class in Section 8.2, design a class named...
A: PROGRAM EXPLANATION: Create a Rectangle class. Declare all the data members for this class as given...
Q: Explain the phrase "laser card," which refers to a memory card that is theoretically tied to the sma...
A: Introduction: a plastic card that contains integrated circuits and is used to store and process comp...
Q: code in python. Use import sys and read lines from stdin. Users don't have to enter the input. sor...
A: import sys x=["SAS","ORV","NAND","EQE"] for lines in sys.stdin: x.append(lines) x...
Q: (Data exploration and Mining Method Proposal): Here you will explore your data both visually and/or ...
A: Answer: I Correlations: It is used to investigate the degree to which two or more variables are rela...
Q: Rewrite the program with a little bit of changes in the codes...
A: The program written above is for sorting the numbers in ascending order. I have rewritten the progra...
Q: Why do we use inheritance? when you want to combine classes. when a "is-a" relationship exists whe...
A: Why do we use inheritance? when you want to combine classes. when a "is-a" relationship exists when ...
Q: 5. Describe the resources automatically set up for new users. Next, summarize how you would modify e...
A: let us see the answer:- Introduction:- When you're finished estimating activity resources, you'll ha...
Q: Given the following array of integer values, perform the first step of quicksort to sort the array i...
A: Quicksort is a comparison-based sorting algorithm to sort the array in ascending or descending order...
Q: What are the benefits and drawbacks of utilising parameters instead of a global variable in a C prog...
A: What is the definition of a variable?A variable is a name given to a storage area that can be manipu...
Q: 1. Using ASCII / EBCDIC char a = Data 2. Using ASCII / EBCDIC - char a = Data Your answer 3. U...
A: Program Explanation: Include the header files. Create char type letter and with the help of c langu...
Q: What is in a class diagram's characteristics section? Class Algorithms The class's methods Class var...
A: Introduction: What is in a class diagram's characteristics section? Class Algorithms The class's met...
Q: What should happen if the processor sends a request to the cache while a block from the write buffer...
A: Introduction: The cache will be able to satisfy the request since it will be idle while the writing ...
Q: A={L,M,N,P,Q} and B={L,R,S,P,T} , Find the output of A intersection B ?
A: The intersection is an operation in set theory. The intersection of two sets is defined as the set o...
Q: def calculate_sphere_volume_m3(radius_m: float) -> float: """ TODO: write the function purpose, para...
A: Answer: Python Source Code: def calculate_sphere_volume_m3(radius_m:float): pi = 3.141592 vol...
Q: When you run your programme and don't obtain the results you want, what measures do you take? Cis a ...
A: Introduction: The steps involved in running the C program To run the C program, the user should sav...
Q: The complement of a condition is all possibilities where the condition is not true. Which assembly c...
A: The condition we are given is t0 > t1 This is true whenever t0 is greater than t1. For every othe...
Q: HOW ARE THE FUNCTIONAL UNITS CON
A: HOW ARE THE FUNCTIONAL UNITS CONNECTED BY ERP
Q: Prepare a brief report in the form of a letter. In the introductory part of the letter: i. Briefly i...
A: When it comes to increasing a company's efficiency, Spread Sheet Automation is a valuable ally. Dat...
Q: How much time is required to compute f(x) = Eo a;x: a. Using a simple routine to perform exponentiat...
A: Actually, given information f(x) = sigma_i = 0^N a_i x^I.
Q: 10 Write a function, is_prime, which takes a single integer argument and returns True when the argum...
A: function for prime: def is_prime(n): i=0 c=0 for i in range(1,n+1): if n%i==0: ...
Q: nt that
A: The explicit join syntax makes use of two keywords, ON and JOIN. ON keyword is used to specify the p...
Q: Question 1: Write a program in JAVA that displays a menu as shown in the sample run and asks user to...
A: PROGRAM EXPLANATION: Import java.util package. Create the main class and the main method. Create a ...
Q: What is the term used to describe a non-key attribute in one entity that points to the primary key i...
A: This is used to establish relation between two tables
Q: Q/ write a a ssem bly Progam that store 1234H #in r egister Ax then trans fo The Contents of Ax tore...
A: I'm providing the answer to above query. I hope this will be helpful.
Q: Using Python Write a program that prints the numbers from 1 to 100. But for multiples of three prin...
A: As given, I need to write a Python program that prints the numbers from 1 to 100. But for multiples ...
Q: recreate this using html
A: HTML: HTML stands for HyperText Markup Language. It is used to design static web pages. It is create...
Q: Identify and briefly describe each of the five basic task management approaches used in operating sy...
A: Answer : Five basic task management approaches used in operating system are : 1) File management :...
Q: (al Gine the langnagr arpted In this DFA. (Ennlate the way we expeess Langusges as sets in 3) hị Enc...
A:
Q: What is in a class diagram's characteristics section? Class Algorithms The class's methods Class var...
A: Answer: The “variables” of the class are listed in the attributes section of a class diagram. So the...
Q: What is the purpose of system engineering? How to achieve performance improvement by using system en...
A: The answer is given below:-
Q: Was there any impact on the Symbian, Android, and iPhone operating systems as a result of the file d...
A: Intro The mobile operating system Android is built on a modified version of the Linux kernel and oth...
Q: 2. Convert the following two’s complement binary fixed-point number to base 10. The implied binary p...
A: Converted the two's complement to decimal
Q: Give one benefit and one drawback of the Microkernel OS over the Monolithic OS. Provide evidence to ...
A: Introduction The question is about one benefit and one drawback of the Microkernel OS over the Monol...
Q: The following is related to the Hill cipher. A pair of plaintext and its corresponding ciphertext is...
A: Hill cipher: The decryption key is a linear algebra-based vector tracking cryptosystem. Numeric modu...
Q: Write a program that Requests a temperature from the user. Also asks if the temperature is in Fahren...
A: Ans: python is very sensitive about indentation.So, please take care about indentation.Copy the same...
Q: Convert unsigned decimal 60293 to a hexadecimal value. 1656 いr6u293
A: Assembly code to convert decimal 60293 to hexadecimal: .MODEL SMALL .STACK 100H .DATA d1 dw 6029...
Q: WAP to convert a square into a rectangle. Perform the conversion in source class.
A: Explanation: Include the necessary header files. Create two functions. One for printing square and ...
Q: systen operating at an information rate of 36 kbps determine, Baud Minimum bandwidth
A: The Answer is in Below steps
Q: Write this using a java script function and test with a mocha or postman to see if it passes the t...
A: I have provided JAVASCRIPT CODE along with CODE SCREENSHOT and also provided OUTPUT SC...
Q: Write a program that prints out the letters of a word, each followed by a dot (full stop or period) ...
A: Wrtting the program below with comments :
Q: Commercial software Shareware Freeware Public domain software Open-source software Based on the prov...
A: Answer: 1. In many jurisdictions, commercial software is copyrighted and so protected. Both the obj...
Q: Which logical operators perform short-circuit evaluation? A. or, and B. not, and C. or...
A: The answer is
Q: Simplify the following using K-Map and compare it to Boolean simplification. SHOW ALL PERTINENT SOLU...
A: Karnaugh guide or K-map is a guide of a capacity utilized in a strategy utilized for minimization or...
Q: A high level of compute redundancy is one of the benefits of a Hadoop installation. Why is this so c...
A: INTRODUCTION: Hadoop is run on UNIX in its production context, although it may also be run on Window...
Step by step
Solved in 3 steps with 1 images
- You are working with a database that stores information about suppliers, parts and projects. The Supply relation records instances of a Supplier supplying a Part for a Project. The schema for the database used in this question is as follows: ( primary keys are shown underlined, foreign keys in bold). SUPPLIER (SNo, SupplierName, City) PART (PNo, PartName, Weight) PROJECT (JobNo, JobName, StartYear, Country) SUPPLY (SNo, PNo, JobNo, Quantity) Provide relational algebra (NOT SQL) queries to find the following information. NOTE: You can use the symbols s, P, etc or the words ‘PROJECT’, ‘RESTRICT’ etc . do not need to try to make efficient queries – just correct ones. Where you use a join, always show the join condition. List the quantity of parts supplied on JobNo 4745. List the weight of the Part named “Left-handed screwdriver”. List the Project name and Part name of any Parts where fewer than 500 of the part has been supplied to a particular project. List the name of any Suppliers…In SQL, foreign key constraints can reference only the primary key attributes ofthe referenced relation or other attributes declared to be a superkey using theunique constraint. As a result, total participation constraints on a many-to-manyrelationship set (or on the “one” side of a one-to-many relationship set) cannotbe enforced on the relations created from the relationship set, using primarykey, foreign key, and not null constraints on the relations. Explain whyConsider the E-R diagram in Figure 8.7 showing entity set instructor. Give an SQL schema definition corresponding to the E-R diagram, treating phone number as an array of 10 elements, using Oracle or PostgreSQL syntax.
- Explain why an index is only useful if the values of an attribute are sufficiently varied.You are working with a database that stores information about suppliers, parts and projects. The Supply relation records instances of a Supplier supplying a Part for a Project.The schema for the database used in this question is as follows: (note that primary keys are shown underlined, foreign keys in bold).SUPPLIER (SNo, SupplierName, City)PART (PNo, PartName, Weight)PROJECT (JobNo, JobName, StartYear, Country)SUPPLY (SNo, PNo, JobNo, Quantity)Provide relational algebra (NOT SQL) queries to find the following information. Each question is worth 2 marks.NOTE:• You can use the symbols etc or the words ‘PROJECT’, ‘RESTRICT’ etc as you prefer. • You do not need to try to make efficient queries – just correct ones. • Where you use a join, always show the join condition.a. List the quantity of parts supplied on JobNo 4745.b. List the weight of the Part named “Left-handed screwdriver”.c. List the Project name and Part name of any Parts where fewer than 500 of the part has been supplied to a…You are working with a database that stores information about suppliers, parts and projects. The Supply relation records instances of a Supplier supplying a Part for a Project.The schema for the database used in this question is as follows: (note that primary keys are shown underlined, foreign keys in bold). SUPPLIER (SNo, SupplierName, City)PART (PNo, PartName, Weight)PROJECT (JobNo, JobName, StartYear, Country)SUPPLY (SNo, PNo, JobNo, Quantity) Provide relational algebra (NOT SQL) queries to find the following information. NOTE:• You can use the symbols σ, π, etc or the words ‘PROJECT’, ‘RESTRICT’ etc as you prefer. • You do not need to try to make efficient queries – just correct ones. • Where you use a join, always show the join condition.a. List the quantity of parts supplied on JobNo 4745.b. List the weight of the Part named “Left-handed screwdriver”.c. List the Project name and Part name of any Parts where fewer than 500 of the part has been supplied to a particular project.d.…
- You are working with a database that stores information about suppliers, parts and projects. The Supply relation records instances of a Supplier supplying a Part for a Project.The schema for the database used in this question is as follows: (note that primary keys are shown underlined, foreign keys in bold). SUPPLIER (SNo, SupplierName, City)PART (PNo, PartName, Weight)PROJECT (JobNo, JobName, StartYear, Country)SUPPLY (SNo, PNo, JobNo, Quantity) Provide relational algebra (NOT SQL) queries to find the following information.NOTE:• You can use the symbols σ, π, etc or the words ‘PROJECT’, ‘RESTRICT’ etc as you prefer.• You do not need to try to make efficient queries – just correct ones.• Where you use a join, always show the join condition.a. List the Project name and Part name of any Parts where fewer than 500 of the part has been supplied to a particular project.b. List the name of any Suppliers who have supplied Parts to the Project called “New Academic Building” or to the Project…This question is related to the Database:- Suppose you are creating a database for a library management system. Explain how you would make a table for the "books" entity and insert some sample data, and then alter the table to add a new column for the "authorID" attribute and update "authorID" with some data. Finally, make a SQL query to retrieve all the books that were published after the year 2000. Note that this book schema has several columns, including "book_id" as the primary key, "title", "authorN", "publisher", "publication_year", "isbn", "language", and "num_pages". It also includes "available" column that is set to "true" by default and can be used to track the availability of the book. Please don't use handwriting...Answer questions 2.1 to 2.4 based on the following schema. Note that primary keys are in BOLD. Note also that attributes with the same name in different tables are foreign keys. For example, doctorID in the Treatment table is a foreign key that refers to the Doctor table. Doctor(doctorId:integer, specialtyID:integer, firstName:varchar(20), lastName:varchar(20), salary:numeric(11,2)) Specialty(specialtyID:integer, specialtyName:varchar(20), specialtyCost:numeric(11,2)) Treatment(doctorId:integer, patientSSN:integer, dateTreated:date, costOfTreatment:numeric(11,2)) Patient(patientSSN:integer, firstName:varchar(20), lastName:varchar(20), street:varchar(30), city:varchar(15), state:char(2),zipCode:integer(5)) 1. Write an SQL statement to increase the cost of all Specialty treatment by 2.5% 2. Write a SQL statement to delete all treatment rows that were done before 2015 and cost less than $500.
- Answer questions 2.1 to 2.4 based on the following schema. Note that primary keys are in BOLD. Note also that attributes with the same name in different tables are foreign keys. For example, doctorID in the Treatment table is a foreign key that refers to the Doctor table. Doctor(doctorId:integer, specialtyID:integer, firstName:varchar(20), lastName:varchar(20), salary:numeric(11,2)) Specialty(specialtyID:integer, specialtyName:varchar(20), specialtyCost:numeric(11,2)) Treatment(doctorId:integer, patientSSN:integer, dateTreated:date, costOfTreatment:numeric(11,2)) Patient(patientSSN:integer, firstName:varchar(20), lastName:varchar(20), street:varchar(30), city:varchar(15), state:char(2),zipCode:integer(5)) 2.3) Write an SQL statement to increase the cost of all Specialty treatment by 2.5% 2.4) Write a SQL statement to delete all treatment rows that were done before 2015 and cost less than $500. 2.5) Write an SQL statement to select all Specialties where the specialtytName has a null…Specify the following queries on the database schema shown in Figure attached using queries in SQL 1. Insert a new project “ProductO”, with pnumber 4, located at Houston, controlled bydepartment 4How does the SQL ORDER BY clause work, and why might it be important when using database functions like MAX() or MIN()? Provide a query illustrating its usage.