Lecturer Information:  Super Class   : lecturer Attributes    :       Lecturerid, LecturerName, Address, Qualification age,  Gender , Methods     :       Read the lecturer details Display the  Lecturer details   Sub class   :  Subject_details Attributes    :   no__of_ students_course1,   no__of_ students_course2, :   no_of_ studenst_course3,    no_of_ students_course4,Total_no_working hours Methods     :  Find the total number of  students from all courses Get the total number of working hours Display the Lecturer details and Subject details.   The following information must be included in your solution(program):   Properties with proper data types   Demonstration of OOP feature (Inheritance) Proper naming convention Proper comments in each program and within program Purpose of each code should be explained. Program Execution (output)

Q: display all fields in the JOB table sorted by the largest hourly charges for the job first

A: SELECT * will fetch you all record in table

Q: Based on the ERD below, display the assignment number, employee number and assigned hours for either…

A: Here we are joining three tables ASSIGNMENT, EMPLOYEE, and JOB and the assigned job is either 501 or…

Q: Table: Task Primary key: TaskID Foreign key: Team MemberID TaskID 1 2 3 Description Build login…

A: INSERT Query: It used to insert new record in table. Syntax: INSERT INTO table_name (column1,…

Q: Create a list manager names and also his supervise names if the manager has any one

A: you can try this query to get the result

Q: please use the picture below to answer the following question Display employee number, employee…

A: SELECT EmployeeID, Emp_LName, HireDate FROM Employee e JOIN Position pWHERE e.Emp_LName like '%e%'…

Q: Complete the entries: 1. Set methods are commonly called v methods. 2. Set methods change v fields.…

A: As we know data of an object must be kept private. However, if any data member is declared private,…

Q: student takes ID ID Course id sec id semester name dept_name tot_red ear grade ection se id id ester…

A: I have written queries below: Short Summary: Provided the Select statement performed on tables…

Q: Q1\ Give the ID First Last ame name

A: Thank you  _________ Here it is called Employees details  ID - int  First Name - char  Last Name -…

Q: ccording to tables below, Write 3 SELECT statements to exemplify FULL OUTER JOIN statement

A: Full outer join -  Full outer join combines the result of left outer join and right outer join. It…

Q: Grade Roster Sort (file I/O) The file RosterScores.txt contains student test scores with…

A: Q: Please resubmit error question with question details. Read the file, and sort the table.…

Q: Patient *Pat ID Num Pat Last Name Pat_First Name Pat_Age Pat_Blood Type Pat Address Pat Phone…

A: Some key points regarding the 3 pdf before converting to it is no transitive dependency should be…

Q: Costumer_ID Contact No Order_Total Order No COSTUMER 1 n ORDER Order Date n Name Mode_of_Payment…

A: It is evident by looking at the ERD that, there are no relationships between the attributes which…

Q: Find the result relation of the above query

A: The Relational is query is a very interesting one. Let's understand step by step. The Infinite…

Q: Create the table Students (sno, sname, dateofbirth, program, cgpa)   Fees (sno, date, fee )…

A: NOTE- Since your question contain multiple sub-section . so we are providing solution to query…

Q: Is [CLASS_CODE, CLASS_NAME, STU_NUM, STU_NAME] a Superkey? Why? Is [CLASS_CODE, CLASS_NAME, STU_NUM]…

A: Dear Student, A superkey is a combination of key attributes which can identify each tuple uniquely.…

Q: Count the number of different professors names.

A: DISTINCT is the keyword used to get the different names and then COUNT is applied

Q: According to tables below, write  SELECT statements to exemplify nested and/or correlated nested…

A: Here are the sample SQL Query for the given options: 1. Display number of flights between 6.00 AM…

Q: ormalized 3nf int.

A: 1NF (First Normal Form): A relation is in 1NF if every attribute value in a tuple is atomic, i.e.,…

Q: Customer ={idC(PK), surname} Contract ={idC(PK), customer, consultant, insurance_type, date}…

A: SQL statements editable using MS SQL Server CREATE TABLE Customer(idC char(5) PRIMARY KEY, surname…

Q: 1. Find out the entities in the specifications above. 2. Find out the relationships among the…

A:

Q: Write down 5 check constraints. Check constraints should be meaningful.

A: create table Ticket(Ticket_number INT primary key, flight_number INT, leg_number INT, Flight_date…

Q: A real Estate Company has in its poššession a long list of landlords and the rent cost of their two…

A:

Q: Oracle supports creating objects and collections using type. Write SQL code for the following…

A: Answer :

Q: Where stud_type_id=student_type.id AND student_type.name='local'

A: The complete answer is given below.

Q: Show the list of courses numbers that are taken at least once by students. The course should appear…

A: So, all the unique course numbers has to be printed So, for this you can make use of DISTINCT…

Q: Find the name and the age of the youngest graduate student (use subquery).

A: Subquery is a query written inside another query and here we use this concept to find the minimum…

Q: Given the following relation that stores details about students'  activities:   StudentID…

A: here have to determine functional dependencies are consistent or not.

Q: Based on the ERD below, display all assigned numbers that had an assigned charge per hour greater…

A: The assignment number of the assignment is displayed in which the charge is greater than 84.5 and…

Q: Each student at a school has a unique student ID number. A teacher has the following spreadsheets…

A: The suitable answer is (c) Spreadsheets 2 and 3.

Q: Please convert to 3rd Normal Form

A: Third Normal Form is a form that is already in First Normal Form as well as Second Normal Form and…

Q: Task 4: KimTay Pet Supplies is running a promotion that is valid for up to 20 days after an order is…

A: Here, we are using dateadd function to add 20 days into the invoice date the day today function…

Q: Using the Henry Books database, add the new title from Stephen King to the wrote table: Book code =…

A: The question is asking to add a new book title by Stephen King to the "wrote" table in the Henry…

Q: How many days, years did quitting employees work in their past jobs. Name Null? Туре NUMBER (6)…

A: Here is the query for the the time span of the employees work

Q: 6. Write an SQL query to display the ID, ITEMNAME, CUSTOMERNAME and price is not equal 35000 and…

A: As per Bartleby's guidelines “Since you have posted a question with multiple sub-parts, we will…

Q: Normalise the data below to third normal form (3NF)

A: This is very simple. We know for a table to be in the third normal form, It should be in the Second…

Q: SQL code for: (1) Hint: A NULL in the hours column should be considered as zero hours. Find the…

A: SQL: SQL stands for Structured Query Language. It is easy to learn. It is a standard language for…

Q: SQL Help The Car Maintenance team wants to learn how many times each car is used in every month and…

A: In order to perform the given query, consider a sample database with the name CARMAINTAINENCE where,…

Q: {               String str = tf5.getInt("ID");…

A: It can be challenging to virtualize Microsoft SQL Server due to the high cost of traditional…