please answer these nine questions from mysql . note: the table at the last is t

Question

please answer these nine questions from mysql .

note: the table at the last is the hints .

Database Systems Chapter and MySQL 1 through 5 and Lab. -Answer the questions by filling in the blanks with the information required to produce the results for each of the questions Enter the commands to complete the table design below for an Employee Payroll Database Application utilizing the MySQL Database Software. The table should have a name and 7 columns to include, name for the employee, the hired date, job title and all columns should have no nulls. Create a foreign and primary (03) 2. Before entering the data into the table use the command to confirm or display the structure of the MysOL table for the Employee Payroll Database Application that was created using MySQL in the exam step number one. 3. Enter the commands to enter 2 rows of information into the Employee Payroll Database Application tabl structure displayed in number two using MysOL software. EMPLOYEE 4. Based on the information entered into the table, use the command below to display and all employee table EMPLOYEE 5. Make a change to the table structure and change a column name and the datatype definition in the Employee Payroll Database Application table created above. You choose which field you would like to change. EMPLOYEE 6. Create a guery to view at least 3 one of the emnlovyys,

Explanation / Answer

Okay so lets Start

1.

create table Employee_Payroll
(Employee_id Varchar2 (04) Primary key NOT NULL,
First_Name Varchar2 (30) NOT NULL,
Last_Name Varchar2 (30) NOT NULL,
Gender Varchar2 (01) NOT NULL,
Address Varchar2 (40) NOT NULL,
Salary number (5) NOT NULL,
Hired_Date Varchar2 (3) NOT NULL,
Job_Title Varchar2 (10) NOT NULL FOREIGN KEY);

2.

DESC Employee_Payroll;

3.

insert into Employee_Payroll values

('E001', 'Suresh', 'Gupta','M','Mumbai', '25000', '25/05/2015', 'Manager');

insert into Employee_Payroll values

('E005', 'Ramesh', 'Gupta','M','Delhi', '20000', '10/08/2015', 'Ass. Manager');

4.

select * from Employee_Payroll;

As we are allowed to answer only 4 subparts of a Question, to get answers to the other parts of your question please repost only those parts again.

Thank You for using Chegg...

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.