Galaxy is an international Airline company. The company has several Airports each Airport is located at a different country. Each Airport has a name and capacity. Each Airport can hold several Aircrafts at the same time. Each Aircraft has ID, Type and Capacity. The Company has many Employees working in Airports. Each Airport has many employees working in it. Every employee working in an Airport can only one of three Jobs: Pilots, Admins and Mechanics. Each Employee has an ID, Name and salary. Pilots have Number of Flight hours and Mechanics have years of experience. The company keeps information of its customers. Each customer has Name and Passport ID. A customers can book one or more tickets. The company keeps information of its tickets such as flight date, Flight ID and Ticket ID. Each Ticket is associated with one customer and Aircraft.

Q: What type of join is needed when you wish to include rows that do not have matching values?…

A: Refer to step 2 for the answer.

Q: Syntax for drop table cascade constraints drop table with restrict  syntax for On delete/update…

A: A SQL  query can be defined in such a way that it is a command that is basically used to interact…

Q: 3. CREATE TABLE Employee ( name VARCHAR(), e_id int, mgr_id INT, PRIMARY KEY (e_id) ); CREATE…

A: The SQL queries are given in the below step   We have to use self join of table Employee as Manager…

Q: The degree of a relation is the number of its columns. True False

A: Defined the given statement as true or false

Q: Normalization functional dependencies have what characteristics?

A: Functional dependencies It is a specific connection between two characteristics inside a table: main…

Q: What is the difference between an inner join and outer join?

A: The objective of this question is to understand the difference between two types of SQL joins: inner…

Q: Explain why an index is only useful if an attribute's values change enough.

A:

Q: What is the distinction between a PRIMARY KEY and a UNIQUE constraint

A: In Step 2,   I  have  provided  distinction between a PRIMARY KEY and a UNIQUE  KEY---

Q: Using the Henry Books database,update the paperback field for the book titled Black Houseto Y. You…

A: “Since you have posted a question with multiple sub parts, we will provide the solution only to the…

Q: The various database table choices should be discussed when dealing with subtype associations.…

A: Business databases may store supplier names, emails, and phone numbers in a Contacts table. Tables…

Q: What constraint is imposed on am attribute that is declared as Primary Key? What bemefit does that…

A: The solution to the given problem is below.

Q: The Car Maintenance team also wants to store the actual maintenance operations in the database. The…

A: DELETE CASCADE: - When we constitute a foreign key using this option, it deletes the referencing…

Q: Topic: Database Design It is possible to use NATURAL join, and there are some downsides to using…

A: A NATURAL Join is a special type of EQUI Join in which columns with the same name in the tables to…

Q: Which types of joins is used to produce the query? A)Right Join B)Left Join C)Inner Join D)Natural…

A: Incorrect options A. Right join is a join that lists each row of a table available on the right side…

Q: Describe any issues you might have when doing join operations with the NATURAL JOIN keywords.

A: A NATURAL JOIN joins the tables in such a way that the columns with same names appear only once in…

Q: A relation may not have a super key. (a)True (b)False

A: A super key is a set of one or more attributes (columns) within a relational database table…

Q: What conditions allow a relation's attribute to have a changeable length?

A: According to the question, we have to answer that what conditions allow a relation's attribute to…

Q: What is the difference between a UNIQUE and a PRIMARY KEY constraint? (See the tables in the JustLee…

A: Key in Database: Key constraint is used to identify the records uniquely in the table. The Table may…

Q: Implement a new independent entity phone in the Sakila database. Attributes and relationships are…

A: All lower case Underscore separator between root and suffix Foreign keys have the same name as…

Q: What data types would you use for the attributes in this entity? How would you code a CREATE TABLE…

A: In a database management system (DBMS), an attribute is a piece of data that describes an entity.…

Q: Implement a new independent entity phone in the Sakila database. Attributes and relationships are…

A: There is only one error in the above code and that is the ALTER TABLE command on the address table.…

Q: What is the difference between a UNIQUE and a PRIMARY KEY constraint? (See the tables in the JustLee…

A: Introduction: When creating a table, a primary key is used to identify each row in the table, while…

Q: Create a new table named PRODUCT. The product table will have two attributes;  product ID as…

A: Create a new table named PRODUCT. The PRODUCT table has two attributes: A product ID as an integer…

Q: do this  Following tables support the database of a shopping store. The schema contains four tables…

A: here have to determine about sql query from given problem.

Q: Implement a new independent entity phone in the Sakila database. Attributes and relationships are…

A: SQL: Database management is done using a programming language called SQL, or Structured Query…

Q: In order to utilize an index, an attribute's values must be sufficiently varied.

A: Introduction Use of an index with a wide range of values A file index is a table or other data…

Q: Create a table named "LIBRARY" with the specifications mentioned below. Display the details of the…

A: The CREATE TABLE statement is used to create a new table in a database. Syntax: CREATE TABLE…

Q: create the following tables in a database named STUDENT_REGISTRATIONS. Ensure that you create the…

A: in the following section we will be writing the oracle SQL queries for the above mentioned table…

Q: Explain why an index is only helpful if the values of an attribute have a suitable range of values.

A: The answer :

Q: When an attribute is included in a composite primary key, it automatically becomes a candidate key…

A: Introduction: A single field or a composite expression that satisfies the criteria for a primary key…

Q: Using the Employees table display the department_id and the average salary of all the employees for…

A: A query to calculate average and to retrieve columns from one or more tables is created using the…

Q: 5.6 LAB - Implement independent entity (Sakila) Implement a new independent entity phone in the…

A: First check whether phone_id column exists in your customer, staff, and store table or not. If…

Q: Provide an example of a 3 table OUTER join. Explain how it works and what the order of of the joins…

A: OUTER join OUTER join indicates all the rows are included in the output irrespective of whether…

Q: The value range of an attribute must be large enough for the index to be relevant. Except for this…

A: Utilizing An Index With A Broad Range Of Values: An index is a table or data structure used in…