Write Relational Query Expression to do the following:
a. Find all the committee names where instructor Abdullah is a member
b. Find the maximum given salary.
c. Find the total number of instructors for each department.
Question Two
Consider the following relation instances:
Student
Student_id Name Course_code
10001 Abdullah IT244
10002 Mohammed CS140
10003 Nasser CS141
10004 Khalid IT403
Course
Course_code
Course_name
IT244 Introduction to databases
CS140 JAVA I
CS141 JAVA II
CS566 Cyber Security
Write the output of the following relational algebra expression:
a. Student Course
b. Student Course
Question Three
You have been asked to design a database of documents, authors, and readers. described as follows:
• Document: has a docID, title
• Publisher: each author is the creator of several documents, and each document is published by one or several publishers.
• Readers: each reader reads several documents, and each document is read by several readers.
Draw an E/R diagram, which includes entity, attributes, and relationships. Remember to indicate the key for each entity, as well as the multiplicity of each relationship using the appropriate notation.(You may presume your own scenario)
Sample Solution
In addition, this experience leads the company to reach determinations on the best production for the long-term viability of a well. Weatherford labs provide several services according to the client requirements, for instance MICP (Mercury injection and Capillary pressure), Porosity and Permeability measurement, CT scan for cores, Soxhlet Cleaning, Core photo, Core gamma, Fluid Saturation by Dean Stark, Salinity Analysis, and finally Miscible Extraction. Weatherford laboratory sections The Waterford lab in Oman is divided into several sections and each department has special tasks. The flow chart below shows the different sect The Conventional core analysis department is about using different instrument in order to measure the porosity and permeability of fluids using Nitrogen and Helium gases. In addition porosity and permeability are important factors in petroleum. This section provide an important data related to porosity and permeability in order to get a better understanding in reservoir and flow of different types of fluids using DHP (Digital Helium Porosimeter) and DGP (Digital Gas Porosimeter) devices also VINCI is one of the instruments that used for steady- state processes. SCAL sectio Special core analysis section are specialist in understanding petrophysical properties goes beyond special techniques with advance tests to help the client more in estimating their fields. It is important to note however, that SCAl provide several services in MICP (mercury injection and capillary pressure), FRF (formation resistivity factor), and permeability of fluids especially water, CT scan, and flush cleaning using different solvents. However, the department provides unique tests related to the above processes in order to ensure the delivery of good quality services and focus on saving costs to the customer. Therefore, SCAL section is responsible for different fluid analysis at several stages in order to fulfil all the operational requirements and to achieve important results that optimize production and development of the fields. Other sections Weatherford laboratories also provide some other services behind the services provided by CCA and SCAL. These services include the basic experiments and requirement to observe several parameters such as temperature, pressure, and type of gas. Summary of the internship I have implemented the internship in Weatherford Company, Is one of the international oilfield services company. The company has several sections and the section where I had training is the Weatherford laboratory and is considered one of the main sections in Weatherford. The Weatherford labs are located in Ghala Industrial Estate in Oman. The company offers internship opportunities to students in different departments for example wireline, product line which include laboratories, and finances related to their major and skills.>
GET ANSWER