please answer these MYSQL questions for me and please take y

please answer these MYSQL questions for me and please take your time to answer them correctly . Thanks

28 Business rules are derived from operations A, a detailed description of an organization\'s B. standards and practices developed over the years recommendations D. govemmental oversight organization standards below. Use the information from the table below to fil in the blanks and complete the MySQL the initial Life Cycle 29. Database Life Cycle select the phase from below that is the phase after Development 30, The systems design is created during which phase of the Systems 31. e database contents are loaded during this phase from below of the Systems Development Life 32. Cycle (SDLC) phase the Database Life Cycle (DBLc involves this selection C The maintenance and evolution of 33. from bekovu. data has been loaded into the database, the person required to tests and fine-tunes the Ice the database for pet ance, integrity, concurrent access, and security constraints stage of the 34, \"Should the existing system be replaced is a question that is asked during this 35. Systems Development Life Cycle (SDLC) and B, if A contains 8 rows and B How many rows would be returned from a c join of tables A 36 contains 18? Select correct answer from below. and traditional (FOR In oracle, which of the statements below ke(s) it possible to merge SQ programming such as variables, conditional processing and WHILE loops and emor trapping users across many 37. This is the type of database that is used by an organization and supports many 38. C A collection of programs that manages the database structure and controls access to the data stored departments. in the database. la database design management system) U DBMS (database implementation B. Procedural Language SQL (SDLC) system. planning C. introducing changes D database administra L. analysis with the requirement evaluations user-info) 28 H, DBLC (database lifecycle)

Solution

28) A
29) K (SDLC) system planning
30) I databbase design
31)
32) D database administration
33) H DBLC
34) L analysis with the requirement evaluation
35) M 144
36) B Procedural Language
37) J DBMS(database Management System)
38) D Database Administrator

39) create database MAC250_Company;

40) Create table employee
(
Emp_no DOUBLE (10) PRIMARY KEY.
First_name varchar (30) NOT NULL,
last_name varchar (30) NOT NULL,
address varchar (60) NOT NULL.
city char (30) NOT NULL,
prvince char (2) NOT NULL,
postal NUMBER (11) NOT NULL
);

41) insert into employee values

42) select * from employee;

43) select employee_last_name, employee_city,employee_state from employee order by employee_last_name;

44) Alter table employee add column employee_m_name char(1) NOT NULL;

45) Alter table employee update column employee_zip NUMBER (15) NOT NULL;

46) update employee set employee_zip=\'1234-23413\' where employee_id=1111111111 and employee_last_name=\'Doe\';

47)select * from employee;

48) Select employee_id, CONCAT(\'employee_last_name\',\'employee_first_name\') as NAME from employee;

49) Alter TABLE employee RENAME MYyCompany_employee;

50) 1. Create Statement
example:Create table employee
(
Emp_no DOUBLE (10) PRIMARY KEY.
First_name varchar (30) NOT NULL,
last_name varchar (30) NOT NULL,
address varchar (60) NOT NULL.
city char (30) NOT NULL,
prvince char (2) NOT NULL,
postal NUMBER (11) NOT NULL
);

2. Alter statement
example: Alter table employee update column employee_zip NUMBER (15) NOT NULL;

3. Drop statement
example\" drop table employee;

51) 1. Select statement
example: select * from employee;

2. Insert statement;
example: insert into employee values(\'111111111\',\'Joe\',\'Shu\');

3. Delete statment
example: delete from employee where employee_id=\'1111111111\';