Create two different “Views” using below relations, then Alter one of the Views and Drop the other one.  After that discuss why Views are used by giving examples using relations from the tables below.   Student Relation Student_ID Student_Name Dept_Name 0000 AAAAA Computer Science 1111 BBBBB Computer Science 2222 CCCCC Business Administration 3333 DDDDD Education 4444 EEEEE Physics 5555 FFFFF History   Student_Courses Relation Student_ID Course_ID Section  Year Grade 0000 CS 2203 2 2020 A 0000 CS 1101 1 2019 A 1111 CS 1101 5 2019 B 1111 CS 1102 1 2019 B 1111 CS 2204 1 2020 A 1111 CS 2401 1 2020 A 2222 BUS 1101 3 2019 C 2222 BUS 2201 1 2020 B 2222 BUS 3302 1 2020 B 3333 EDUC 5010 1  2019 A 3333 EDUC 5210 1  2020 B 4444 PHY 1101 4  2019 A 4444 PHY 2202 1  2020 C 4444 PHY 3304 1  2020 A

Q: For the 4 following questions, your submission will be the query that shows you’ve created the table…

A: According to the information given:- We have to write a query that shows you’ve created the table…

Q: Refer to the given tables. Salesperson Salesperson Commission Year of Department Manager Number Name…

A: In order for a relation to be in the 2NF, it must be: Should not include partial dependency in 1NF.…

Q: Consider the following PRODUCT table (Primary key underlined). True or False: The two last rows are…

A: Dear Student, Only the primary key column must contain  unique items, other column can contain same…

Q: Create entity named schedule with attributes schedule_code as characters with size 15, course_code…

A: Query to create the table is:   Create table Schedule ( schedule_code varchar(15), course_code…

Q: PLZ help with the following: Populate every relation with “sufficient” representative rows (at…

A: The given are the tables created in SQL database where details of Book, Client, Author are stored.…

Q: Click the small + sign beside the employee with ID 149. What do you see? Why do you see it?

A: Datasheet view: Datasheet view provides the visual way to create a table. It is used to arrange the…

Q: Having this information. Students Attribute Name Data Type StudentID char(11) FirstName varchar(20)…

A: Structured Query Language, abbreviated as SQL, which refers to the one it is a domain-specific…

Q: Normalize the following form into UNF 1NF, 2NF and 3NF. Show primary keys and foreign keys for all…

A: We have given a table and we need to normalize the given table into 1NF, 2NF, and 3NF. Then we need…

Q: Parking_Number Car_Model Course Marketing lent_ID 2 Toyota 4 BMW Business IT Оpel Ford Hyundai…

A: Given that using the join statement select records that matching in both tables limited to…

Q: Modify the PILOT table to add the attribute shown in the following table, with a precision and scale…

A: ALTER TABLE command is used to add new Attribute to the table Syntax: ALTER TABLE table_name  ADD…

Q: [   slide-15 .png  ] Q1. Please write SQL codes to create below member database table   based on…

A: A relational database contains tables. Tables are also known as relations and they contain rows and…

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: 9. Create a new table lab_instructor which has the ID, name, lab_incharge and experience attributes.…

A: -- QUERY TO CREATE TABLE : CREATE TABLE lab_instructor( ID int primary key, name varchar(50),…

Q: Please draw an EERD based on following description: A rental car agency classifies the vehicles it…

A: Entity Relationship Diagrams (ER diagrams) are flowcharts that show all of the relationships between…

Q: using sql develpper or sql live oralce Create the DONORS table with the following columns:…

A: As per our company guidelines we are supposed to answer ?️only first 3️⃣ sub-parts. Kindly repost…

Q: Write a SQL statement to create a foreign key in table Invoice_Detail that refers to the…

A: Write a SQL statement to create a foreign key in table Invoice_Detail that refers to the…

Q: write mysql statement to create database name aurther2.and do the following -create table name…

A: Please refer to the following steps below for the solution to the question above. Comments are given…

Q: Use the following precision for each row: Attribute Name Attribute Precision CHAR_WAIT_CHG 6,2…

A: QUESTION Modify the CHARTER table to add the attributes.   ANSWER A new column is added to a table…

Q: Create the Branch_Reps table and define the constraints at the table level. Note that Not Null can…

A: Creating a simple table entails naming it, creating its columns, and specifying the data type for…

Q: PUBLISHER Pub_Name Mailing Address Phone ISBN Title Publishes Price Pages BOOK ROYALTY_CHECK Check…

A: Below is the relation for given EERD

Q: The term attribute refers to a of a table. Your answer When we talk about the table in more accurate…

A: Solution ::    The term attribute refers to a column of a table. Answer ::.  Column Explanation:…

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: Write a sql query to create the given table.

A:

Q: reate a query in query design view based on both tables to answer the question, What is the concert…

A: Query:   Create query:   CREATE TABLE `sponsor`( `concert_id` INT(50), `sponsor_name` VARCHAR(50),…

Q: Having this information. Students Attribute Name Data Type StudentID char(11) FirstName varchar(20)…

A: 1. The MySQL code for the given problem is as follows: CREATE TABLE Students (    StudentID…

Q: Please write the MySQL query for the following task: Find the first_name, last_name, employee_id,…

A: we can use the following MySQL query:

Q: Create a table named Clerks, with 3 columns (employee-id, first name and job_id) where all employees…

A: The question has been answered in step2

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: difference between  Primary key; Composite key

A: Primary Key is a column in a table from which can  uniquely identify each row. It is a single…

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: The table STUDENT has the attributes STUDENT_ID, NAME, SCHOOL_ID, and ADDR. The table SCHOOL has the…

A: The objective of the question is to identify the correct SQL query that will create a table showing…

Q: :When the primary key is not a composite key, the relation is said to be in at least fifth normal…

A: Lets see the solution.

Q: Name an example of an attribute in the following table. Student_ID Student Name Student Street…

A: Attributes are defined in terms of their domain. A domain defines the allowable values that an…

Q: The Car Maintenance team considered that the available maintenance tasks should also have the price…

A: TASK 1: -- Creating a new table MAINTENANCE_TYPES with following fields create table…

Q: Create a View to show the city name of any location that has a department. Only show the city name…

A: SQL Query:- A query is a request for data or information from a database table or set of databases.…

Q: In the figure below, STUDENT relation has a composite primary key contains Stud_ID and Course_ID.…

A: The Answer is  in Below Steps

Q: Q7: An ERD about a company has been mapped to the following Relations. Please choose the correct…

A: The above question is solved in step 2 :-

Q: 1004 BB-189-MM MERCEDES E200 2019 TRAVEL ID TRAVEL START TIME TRAVEL END TIME TRAVEL START LOCATION…

A: ALTER TABLE command is used to alter the table. The syntax is: ALTER TABLE table_name ADD CONSTRAINT…

Q: use the picture below to answer the following question Add a ZIP field/column to the customer…

A: Add a column in the table You can use the ALTER TABLE statement in SQL Server to add a column to a…

Q: Which of the following is not true about a relation? Group of answer choices The cells of a relation…

A: Which of the following is not true about a relation?Group of answer choicesThe cells of a relation…

Q: Normalize the form below to UNF, 1NF, 2NF and 3NF. Show primary keys and foreign keys of tables in…

A: Normalize the form below to UNF,1NF,2NF and 3NF.Show primary keys and foreign keys of tables in 3NF.…

Fundamentals of Datawarehouse

A data warehouse is a data repository which is used to store large quantities of historical data that are mostly used for creating reports that help businesses to identify their weaknesses and strengths. For example, demographics data about people of a region can help businesses identify the needs and preferences of the region’s population. A data warehouse acts as a central storage for storing data that comes from one or more heterogenous sources. It also consists of data which can be old and of historical value. One of the most important applications of this type of system is that it is used for supporting business intelligence and data analytics applications.