Consider the following primary key underlined project (PNO, P Name, Duration, Cost) Staff (SNO, SName) Assigned to (PNG, SNO) write The relational algebra for the following 1. Find the project Names of projects assigned to Ahmed. 2. find project mames of projects not assigned to any Staff 3. find names of employee working on all projects. DR. 3622
Q: C++ Given positive integer numInsects, write a while loop that prints that number doubled without…
A: C++ (or “C-plus-plus”) is a general-purpose programming and coding language. C++ is used in…
Q: Is assembly language really so terrible that it should be avoided in widely used applications? When…
A: Assembly language, sometimes known as assembler language and more often abbreviated as "asm," is a…
Q: Represent the following complex numbers in polar coordinate Z= 2 + 5j Y=-3-3j D=-2 +6j
A:
Q: Tell me about your experience using email. How many clicks do I need to do before my email is sent…
A: A mental model is an intuitive image that a user already has or develops about the structure of an…
Q: What is a benefit of using an HTML text editor?
A: The answer to the following question:-
Q: Describe your application in terms of its intended function. A microcontroller application that…
A: A microcontroller application that uses the Analog to Digital Converter (ADC) module.Explain the…
Q: If you're interested in user and kernel threading, Sun Solaris OS is worth a try. Could you explain…
A: Solar micro systems produced the Unix-based Sun Solaris os. Fibers are lightweight parallel…
Q: Explain the difference between a method and a function. Identify the name of a method which you've…
A: - We need to talk about functions and methods. - We are referring to java as the programming…
Q: Assume the file data.dat contains a sequence of binary data. Write a program that does the…
A: Introduction Exception: An exception is a circumstance that arises while a programme is being…
Q: Provide a case in favor of deep access as opposed to shallow access from the perspective of a…
A: Introduction: Deep binding and shallow binding: A deep or shallow binding variable access approach…
Q: . What is the difference between a smooth model and a layered model when it comes to VES modeling?
A: The smooth model and the layered model are the two varieties of models that may be used in the…
Q: If you want to argue that deep access is better than shallow access, you need to do more than simply…
A: Introduction: The use of deep learning in neuroimaging data is especially intriguing since MRI scans…
Q: create a simple chatbox in python asking the user if they like the color pink if the user inserts…
A: Please find the answer below :
Q: Discuss the logistics of storing and retrieving schedule management system files.
A: Introduction: Logistics of storing and retrieving schedule management system files involves creating…
Q: Identify one TCP/IP Suite protocol and an attack that can be performed on it. Describe the kind of…
A: INTRODUCTION: " This abbreviation refers to communication protocols used to join network devices on…
Q: Explain in detail with steps and necessary diagrams how the traceroute tool relies on ICMP Time…
A:
Q: the UPDATE_INVOICE procedure to change the date of the invoice whose number is stored in…
A: Dear Student, The procedure is given below -
Q: standpoint, deep access is preferable to shallow access, rather than focusing solely on performance
A: Dear Student, The answer to your question is given below -
Q: Individuals IndividualID, int FirstName, varchar LastName, varchar Address, varchar Phone, varchar…
A: Editable code: CREATE TABLE Individuals ( IndividualsID int primary key NOT NULL, FirstName…
Q: On Office, complete the following tasks: Configure UAC to automatically deny elevation requests for…
A: “Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: What kind of setup should each server have in order to be secure if the operating system is not…
A: Security is very important for the system and if the operating system is not regularly patched then…
Q: The Internet has evolved into a crucial medium for exercising one's right to freedom of expression.…
A: Introduction: The Internet offers extraordinary opportunities for "speakers" in the fullest meaning…
Q: Write a c++ code that implement a loop that accesses a number of different locations in an array…
A: Answer:
Q: What specific kind of computer architecture do smartphones and other mobile devices typically…
A: Dear Student, The answer to your question is given below -
Q: OVLW 33H; MOVWF 8H; MOVWF 11H; ADDWF 8, 0; ADDWF 11, 1; Questions: What is…
A: Dear Student, The answer to your question is given below -
Q: Should we eliminate or drastically reduce the analysis phase when we plan to use a software package…
A: Packaged software may not always be compatible with your present IT setup or operational procedures.…
Q: What makes CMOS RAM superior to other options for storing configuration data like jumpers and…
A: CMOS" alludes to both a specific style of computerized hardware plan and the group of cycles used to…
Q: How is it decided what image from the Image List will be shown in the PictureBox, and what value is…
A: ImageList: It is a control component that enables you to keep track of the amount of photos utilised…
Q: 3. List the order in which the vertices are visited with a breadth-first search starting with vertex…
A:
Q: Complete the TODO by finishing the accuracy() function. 1. Compute the total number of correct…
A: Complete the TODO by finishing the accuracy() function.1. Compute the total number of correct…
Q: Complete the TODO function by converting the TPR equation into code so that we can compute the TPR…
A: Complete the TODO function by converting the TPR equation into code so that we can compute the TPR…
Q: What does it mean for a computer to have an operating system, and how can you check to see whether…
A: operating system: An operating system (OS) is software that serves as the user's and hardware's…
Q: Discuss the logistics of storing and retrieving schedule management system files.
A: A file management system maintains files. It organises computer files. File management systems are…
Q: If we live in a free and open society, what purpose do barriers serve? Please include at least two…
A: Barriers plays an important role in society for controlling the conflicts and other disputes.
Q: If a tree with a single node has a height of 1, how many nodes may there be in a balanced binary…
A: If the height of a tree with a single node is 1, then the resulting binary tree is five levels tall…
Q: What specific kind of computer architecture do smartphones and other mobile devices typically…
A: Dear Student, The answer to your question is given below -
Q: If you want to convince a programmer that deep access is preferable to shallow access, you need to…
A: Introduction: Dynamic scope allocation rules are used for non-block structured languages. By taking…
Q: For what purposes does protected mode employ the "access rights byte"?
A: INTRODUCTION: The ability to read, write, alter, delete, or otherwise access a computer file; change…
Q: (python) calculating time in Bubble Sort the funtion will only run for 40 seconds create a list…
A: create a list that stats with 5 and will be adding 5 each time, 5+5+5+5+...... until the program…
Q: In your opinion, what tasks fall primarily under the Compiler Phases' purview? Give some specific…
A: Passes are the number of times the compiler explores the source code. Compilers help with this.…
Q: Having this error message when I try to open one of the files in my project on Eclipse: Could not…
A: The following solution is
Q: Create the GET_CREDIT_LIMIT procedure to obtain the full name and credit limit of the customer whose…
A: From the above given question we have to write an SQL query that take the Customer ID as input and…
Q: Speculate on the origins of other forms of media and how the process of making video recordings…
A: Introduction: An electrical signal is captured and replicated by an electromechanical device. a…
Q: What does it mean when an OS user says their hard drives use a "RAID structure"? Which RAID…
A: RAID structure is a way of storing data in operating system.
Q: elect one topic that is of particular interest to you. Perform additional internet research on that…
A: Introduction: SQL, or Structured Query Language, is a strong and adaptable programming language that…
Q: ect information both while in motion and when stored? In addition, which security method provides…
A: In your view, what measures should be taken to protect information both while in motion and when…
Q: Can you explain what an ADT is and how it functions to complete tasks? Is it possible that there are…
A: Introduction: As a mathematical concept, ADT can stand in for many different kinds of information.…
Q: What exactly does "widening conversion" mean?
A: Dear Student, The answer to your question is given below -
Q: Exercise 9(***): Write a program that takes as input two integer numbers and perform a swap…
A: Dear Student, Source code, implementation and expected output is given below -
Q: Fixing the computer disk error caused by incorrect CMOS settings. Will you please elaborate on that?
A: Introduction: In the next response, I will talk exactly how the CMOS settings were entered…
Step by step
Solved in 2 steps
- Question 14 Consider the following schema and answer the following questions: Project(projld: integer, proj_name: varchar) Employee(empld: integer, jobTitle: varchar, salary: number, projld: integer, deptld: integer) Department(deptld: integer, dept_name: varchar) a. Write the following queries in relational algebra. I. Find the jobTitle of employees who worked in project with id= "2654". ii. Find the IDs of employees who are earn salaries more than 1000. i. Find IDs of projects who accomplished by employee with id = "7452".Considering the un-normalized relational table PROJECT below: PROJECT (Project Title, EmpeName, ManagerName, Location, Hours Work, ManagerPhone) The attributes of PROJECT table satisfy the following properties: Each project has many employees, Each employee may involve in one or more projects, Projects are managed by managers; there are many managers in the company, hence a project may be assigned to any one of the managers, but each manager manages only one project. Each project is located in a specific location, The number of hours an employee works at each project is determined by a project title and the name of an employee. Each manager has a telephone number. Normalize the relational table PROJECT into a minimal number of relational tables in BCNF. Use the functional dependencies to prove that each one of the relational tables obtained from the decomposition of the original table is in BCNF.Question 14 Consider the following schema and answer the following questions: Project(projld: integer, proj_name: varchar) Employee(empld: integer, jobTitle: varchar, salary: number, projld: integer, deptld: integer) Department(deptld: integer, dept_name: varchar) a. Write the following queries in relational algebra. i. Find the jobTitle of employees who worked in project with id= "2654". ii. Find the IDs of employees who are earn salaries more than 1000. ii. Find IDs of projects who accomplished by employee with id = "7452". b. Write SQL queries for the following statements. i. Display all the employee's details in the decreasing order of their salary. ii. Count and display the number of employees worked in each project. i. Add the given new department's data into the Department table. deptld Dept_name 123 Human Resources
- If an employee can work for only one department and a department can have many employees (one to many relationship). Which answer the relationship table "work" that has the best values to describe the relationship between employee and department? The employee table has two columns (eid, name) with records ('E1','A'), ('E2','B'), ('E3','C'). The department table has two columns (did, name) with records ('D1','X'), ('D2','Y'), ('D3', 'Z'). work(eid, did) with values ('E1','D1'), ('E1','D2'), ('E2,'D2'). work(eid, did) with values ('E1','D1'), ('E2','D2'), ('E3,'D2'). work(eid, did) with values ('E1','D1'), ('E2','D2'), ('E2,'D3'). work(eid, did) with values ('E1','D1'), ('E2','D2'), ('E3,'D3').4. In a company, employees involved in many projects, and each project may have many employees working on it. The number of hours each employee works in each project, and the start date on which the employee starts working on the project are capture in the following relational table. EmployeeProject (EmpeNum, ProjNum, HoursWork, DateStartWorkOnProj)Modify the CHARTER table to add the attributes shown in the following table. TABLE P8.37 ATTRIBUTES AND VALUES FOR PROBLEM 37 ATTRIBUTE NAME ATTRIBUTE DESCRIPTION ATTRIBUTE TYPE CHAR_WAIT_CHG Waiting charge for each model (copied from the MODEL table) Numeric CHAR_FLT_CHG_HR Flight charge per mile for each model (copied from the MODEL table using the MOD_CHG_MILE attribute) Numeric CHAR_FLT_CHG Flight charge (calculated by CHAR_HOURS_FLOWN CHAR_FLT_CHG_HR) Numeric CHAR_TAX_CHG CHAR_FLT_CHG tax rate (8%) Numeric CHAR_TOT_CHG CHAR_FLT_CHG + CHAR_TAX_CHG Numeric CHAR_PYMT Amount paid by customer Numeric CHAR_BALANCE Balance remaining after payment Numeric
- Indicate dependences and their type.StayWell also rents out properties on a weekly basis to students attending summer school in the Seattle area. Design a database to meet the following requirements, using the shorthand representation and a diagram of your choice. For each student renter, list his or her number, first name, middle initial, last name, address, city, state, postal code, telephone number, and e-mail address. For each property, list the office number, property address, city, state, postal code, square footage, number of bedrooms, number of floors, maximum number of persons that can sleep in the unit, and the base weekly rate. For each rental agreement, list the renter number, first name, middle initial, last name, address, city, state, postal code, telephone number, start date of the rental, end date of the rental, and the weekly rental amount. The rental period is one or more weeks.Assume that you are hired to design a relational database to "manage" the thesis and the projects done in an academic department. Write a maximum 5 pages executive summary which will serve as the requirements analyses document. Your exec summary should provide the following information. No SQL implementation is required at this stage. Stake holders (not just the bare end users) End users Expected functionalities (i.e., sample queries in English, not in SQL) Relation/Tables with the attributes Primary key(s) for each table.
- Write the SQL statements to create all of the necessary tables to represent the above diagram, representing as many constraints as possible. Note: you do not need to worry about specifying types for the fields, but you do need to provide suitable foreign key option(s). When playing a game, the home team name should be stored in attribute htname and the away team name should be stored in atname.Design a survey form of your own. Fill it out as it might have been completed during the database design for Henry Books. For any questions you have too little information to answer, make a reasonable guess. (Ray Henry, the owner of a bookstore chain named Henry Books, gathers and organizes information about branches, publishers, authors, and books. Each local branch of the bookstore has a number that uniquely identifies the branch. In addition, Ray tracks the branch’s name, location, and number of employees. Each publisher has a code that uniquely identifies the publisher. In addition, Ray tracks the publisher’s name and city. The only user of the Book database is Ray, but you do not want to treat the entire project as a single user view. Ray has provided you with all the reports the system must produce, and you will treat each report as a user view. Ray has given you the following requirements: User View 1 Requirements: For each publisher, list the publisher code, publisher name, and…Regional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. The table below shows data that Regional Labs collects about projects and the employees assigned to them. This data is stored in a relation (table) named PROJECT: PROJECT(ProjectID, EmployeeName, EmployeeSalary)