a) Find the address of MGM studios. b) Find Sandra Bullock's birthdate. c) Find all the stars that appeared either in a movie made in 1980 or a movie with "Love" in the title.

Q: The Primary Key is (doctorID, patientID).   i. Explain why the above table is not in 2nd Normal…

A: Below is the answer with explanation:

Q: Please I want the EER or E-R Digram for this question: A patient is identified by patient id, and…

A: An EER diagram, or Enhanced Entity-Relationship Diagram, is a type of data model that is used to…

Q: 12. Report the names of the professors who supervise more than one student. 13.  Report the names…

A: In order to find professors who supervise more than one student, we will need a COUNT() function on…

Q: ask 16: List the invoice number and invoice date for each invoice that was created for James…

A: The given is database problem where multiple tables are needed to join to get the required result.

Q: What Oracle function should you use to calculate the number of days between yourbirthday and the…

A: Oracle functions are constructed into Oracle Database and can be used in multiple SQL statements.…

Q: Show all the different positions in the Staff table. • Show all the different branchNo in the Staff…

A: The SQL queries for the given question are provided below -

Q: Second normal form says:   a. No nonkey columns depend on another nonkey column.   b. Every…

A: The second normal form says:   a. No nonkey columns depend on another non-key column.   b. Every…

Q: List all book titles that have never been borrowed by any borrower.

A: The SQL program for the given problem is as follows: use demo;Create table Book(ISBN varchar(30) Not…

Q: Calculate the number of days that have passed between your birthday and the current date using an…

A: Given:   Calculate the number of days that have passed between your birthday and the current date…

Q: Given the below list, “Record”, that includes 2 sub lists. The first includes the names, while the…

A: Record = [["Ali", "Mazen", "Fida", "Nader", "Majd"], ["Tutor", "IT", "Manager", "PR", "Clerk"]]Sal =…

Q: Who has rented movies in Japanese language? Return only the first five distinct results in…

A: The INNER JOIN keyword chooses records from both tables whose values match. The SELECT clause just…

Q: write a MySQL procedure to retrieve and output the item number, description, storehouse number, and…

A: Always prefer to provide database of table.

Q: Show all female’s first names and their salary.  Show the branchno that has a supervisor whose…

A: Relational database is a type of database which stores and provides the access to data which are…

Q: In the 403 area code, how many of the 10-digit phone numbers (where any combination of digits is…

A: What is phone: A phone, short for telephone, is a telecommunications device used for transmitting…

Q: While selection structures are essential in programming, they are not perfect. The same repetitive…

A: Check the answer. Web developers use "frontend" and "backend" most. Website construction requires…

Q: Find the first names and last names of employees if they got a salary increase more

A: create table commands and inserting sample data into the table for query  create table employees…

Q: Task 6: Find the ID, first name, and last name of each customer for which an invoice was not created…

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: creat the following tables and insert your own values: emp(eno, ename, bdate, title, salary, dno)…

A: The SQL INSERT INTO Statement is used to add new rows of data to a table in the database

Q: Answer the given question with a proper explanation and step-by-step solution.  c. Create a…

A: An organized group of data that is kept and controlled by a computer system is called a database. It…

Q: Show students’ first name and last name, the course numbers the student took (don’t include…

A: Data is coming from 3 tables . So apply inner join on 3 tables with joining condition.  student…

Q: Student ID 1011 1012 1013 1015 Course MIS ACT MKT FIN Student Name Salem Ali Ayman Ahmad Rana Omar…

A: Data Dictionary in database is defined as a structure which defines and catalogue the content of…

Q: Task 17: List the invoice number and invoice date for each invoice that was created for James…

A: We need to provide a query that lists the invoice number and invoice date for each invoice that was…

Q: Task 6: Find the ID, first name, and last name of each customer for which an invoice was not created…

A: Queries are given below :

Q: reate a list of EMPNO, ENAME, HIREDATE, DEPTNO from EMPLOYEE for employee’s with a salary (SAL)…

A: Note: Since you have not provided the language or database name to write the code so I am using SQL…

Q: 1. Report the student names and ages of all students who have a "hotmail" email address. Sort the…

A: 1. Report the student names and ages of all students who have a "hotmail" email address. Sort the…

Q: Find the names and surnames of the customers who received the "Kalem" in 2018 but did not receive it…

A: Note: we have provided answer according to table and attributes mention in picture part. we need to…

Q: C) Which employees earn less salary than the average salary for the consultants who perform the same…

A: According to the information given:- We have to consider the instruction to write queries on the…

Q: The following table stores details of tutors, students and dates of lectures. The Primary Key is…

A: Rules regarding 2nd NF:-  tables must be in 1st NF.  No non-prime is functionally dependent on part…

Q: Find the album title, band name, format, and total length of all albums. Order from longest to…

A: create table album( title varchar(255), band_name varchar(255), format varchar(255), total_len int…

Q: Develop Assignment_Code Student Id Start Date Al P01 A2 P01 A3 P01 B1 P02 B2 P02 Id End Date DO01…

A: As you have asked for the second normal form it is already proved that the table is in 1st Normal…

Q: A) Find all loan numbers with amount greater than $50,000. B) Find the names of all depositors who…

A: A) Find all loan numbers with amount greater than $50,000. σ(amount > 50000) (loan)

Q: a) List the names (Fame and Lame) and SSN of all male employees (Sex='M). b) List the last name and…

A: As per our guidelines, only 3 sub parts will be answered. So, please repost the remaining questions…

Q: vii) Show the (car) types and the frequency at which each type has been used. Show most frequently…

A: vii. Query: select TYPE, count(*) as frequency from cargroup by TYPEorder by frequency desc

Q: Third normal form says: a. No nonkey columns depend on another nonkey column. b.…

A: • When a database is in the third normal form, it is assumed to be in the third normal form. If it…

Q: Task B.  Import the data shown in pictures into the two tables created.

A: To import the data, use the insert query. Insert The INSERT INTO Statement for SQL To add new…

Q: List the invoice number and invoice date for each invoice that contains an invoice line for a Wild…

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: 5: List the names of all salespeople and a count of the number of members they work with. (use uter…

A: Customer_id Name City Grade Saled_ID 1 Ricky Sydney 30 1001 2 Roy Delhi 20 1002 3 Bob London…

Multiple Table

In a database, a table is used to store data in the form of rows and columns. Rows are aligned horizontally and identified by one or more values in a specific column. Columns are vertically aligned and identified by a unique column name.