7. Create the following table :ΕMPLOYΕΕ ΤΑΒEmpid Empname4 digits 50JobManager Hiredate4 digits DateSalComm.Deptid4 digits Numberic 2 digitswhole10characterscharactersfield with 3number decimalPrimary Not nullkeyForeignkeyNot nullNot null Not null8. Create the following tableDEPT TΑΒ :DEPTIDDNAMELOC2 digitsPrimary key Not null25 characters 15 charactersNot null

Queries are written by using MySQL database. 7. EMPLOYEE_TAB: CREATE TABLE EMPLOYEE_TAB(Empid INT(4)…

7. Create the following table : EMPLOYEE TAB Empid Empname 4 digits 50 Comm. Deptid 4 digits Numberic 2 digits field with 3 Job Manager Hiredate Sal 4 digits Date 10 characters characters whole number decimal Primary Not null key Foreign key Not null Not null Not null

7. Create the following table : EMPLOYEE TAB Empid Empname 4 digits 50 Comm. Deptid 4 digits Numberic 2 digits field with 3 Job Manager Hiredate Sal 4 digits Date 10 characters characters whole number decimal Primary Not null key Foreign key Not null Not null Not null

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

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: 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: Create a list showing only the EmployeeID, Sales, and Projected Sales sorted from highest to lowest…

A: The query selects the specified columns from the EmployeeSales table and orders the result set based…

Q: Based on the ERD below, display Employee first name, middle initial and last name so it displays in…

A: In this case, the whole name is displayed in a single column of employees where the job code is…

Q: Task 4: Create a view named PROPERTY_OWNERS. It consists of the property ID, office number, square…

A: Answer is given below .

Q: Task 6: Add the following record to the OWNER table: INSERT INTO OWNER VALUES('SA100', 'Sam',…

A: Attached the Procedure to add the following record to the OWNER table: INSERT INTO OWNER…

Q: Write a query to display the author ID, first name, last name, and year of birth for all authors…

A: The below query will return a list of authors with their IDs, first names, last names, and birth…

Q: Based on the ERD below, write the SQL statement to display the average hourly job charge for a job.

A: Query to display the average hourly job charge for a job. To get average hourly job charge for all…

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: Some rows of a User table are shown below: User ucode name phone scode 7 Alex 847 - 3902…

A: Names and phone numbers are among the details about different users that are included in the User…

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: The command DESC DEPARTMENTS shows the following information Name Null? Type DEPARTMENT ID NOT NULL…

A: Let's see the answer

Q: Display customer number, customer name, and location for customers whose Customer_name starts with…

A: The LIKE operator is used in a WHERE clause to search for a specified pattern in a column. ORDER BY…

Q: Rank Normal forms where each form is a subset of the form above it. [ Select) [Select First Normal…

A: We are going to arrange Normal forms in the database.

Q: statement can remove the definition of a table. alter table update drop table delete

A: SOLUTION: drop table statement can remove the definition of a table. The DROP table command is…

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: Column Name Sie Constraints Data Type DepelD Varchar 4 Primary key DepeName 40 Not mull Varchar…

A: I have created the query below for the table:

Concept explainers

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.

Question

7. Create the following table :
ΕMPLOYΕΕ ΤΑΒ
Empid Empname
4 digits 50
Job
Manager Hiredate
4 digits Date
Sal
Comm.
Deptid
4 digits Numberic 2 digits
whole
10
characters
characters
field with 3
number decimal
Primary Not null
key
Foreign
key
Not null
Not null Not null
8. Create the following table
DEPT TΑΒ :
DEPTID
DNAME
LOC
2 digits
Primary key Not null
25 characters 15 characters
Not null

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: Creation of EMPLOYEE_TAB Table

VIEW

Step 2: Sample tables

VIEW

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Create the table that results from EMPLOYEE PRODUCT DEPT I am unsure of what to do here. I f the column DEPTNAME is in both tables do I put the column twice? Please explain what to do in this case and provide the result.
Based on the ERD below, display all assigned numbers that had an assigned charge per hour greater than $84.5 and assigned charges were less than $200.
The following fields are presented in the table: Member Last Name, MemberFirstName, Street, City, State, ZipCode and MemberFee. The table contains 75,000 documents. How would you build indexes for the table and why would you create these indexes?
Create a table named company with these columns: Company_id varchar(255) Company_name varchar(255) default ‘x’ Hq_phone_number varchar(255) Primary key of company_id (please use constraint format) Unique key of Hq_phone_number (please use constraint format)
Alternate keys: Identify at least five keys (not already listed as PK or FK) needed by end users. These indexes would be considered Alternate or Secondary keys and are mostly used for queries and quick reporting. They may contain multiple columns.
Write Create Table SQL statements Work Session table The table must have a primary key. The table must have appropriate foreign key constraints. Foreign keys must have the same name, datatype and size of the primary key that they refer to The following columns datatypes and sizes and named constraints must be used Column DataType Constraint WorkYear number(4) Range 2019 - 2020 WorkWeek number(2) Range 1-52 WorkHours number(4,2) Range 0.5 – 99.99 BID NUMBER(4) ,AUTHID NUMBER(4)
Task 12: When deleting a customer, subtract the balance multiplied by the sales rep’s commission rate from the commission for the corresponding sales rep.
help please Create a table named BRANCH. The table has the following structureBRANCH_NUM decimal(2,0) NOT NULL default '0'BRANCH_NAME char(50) default NULLBRANCH_LOCATION char(50) default NULLNUM_EMPLOYEES decimal(2,0) deault NULL PRIMARY KEY (`BRANCH_NUM`) (Please type answer no write by hand)
question 5 please use the picture below to answer the following question Assuming all other tables are already created, write a SQL statement to create the following tables and the given constraint(s).
Having this information. StudentsAttribute Name Data TypeStudentID char(11)FirstName varchar(20)LastName varchar(20)Gender char(1)DateofBirth date CoursesAttribute Name Data TypeCourseCode varchar(6)CourseName varchar(70)Level char(2)Credits int RegistrationAttribute Name Data TypeStudentID char(11)CourseCode varchar(6)Grade decimal(2, 1) Write SQL code to: 1. What are the student ID, the names, and birthday of the female students who were born before the last day of 1992? 2. How many students are registered in the course “PHY210”? 3. How many courses are offered by the department of Computer Science (i.e. course codes CS***)? 4. Which course(s) (couseCode and courseName) of level G1 give 5 credits?
16. please use the picture below to answer the following question Write a SQL statement to display Invoice Number and total sale for each Invoice.
Based on the ERD below, display the first and last names, hire dates, and number of years employed for all employees who have worked for the organization more than 15 years. Order by the most recent hire date.