Computers and Technology, 11.03.2022 14:00 aaliyahrice02
* Ocelot exercise database presented in SQL basics 1 will be used in this exercise
* Return exercise in .txt format and use formatting presented below (question always followed be the query)
-- Select all employees from table
SELECT * FROM EMPS;
* In this exercise you will add a new table to Ocelot training database, which will be used to describe the history of employee salary.
Create tables
1. Create a new table called salarydata with the following columns:
* salarydataID (primary key)
* salary (the amount of salary described with two decimals)
2. Create a connection between salarydata and emps tables (Tip: First think what column you should bring from emps table and then create a new column for it). Use the following options in foreign key definition:
* UPDATE CASCADE
* DELETE NO ACTION
Editing table properties
* Important: Do not include the following tasks with the CREATE TABLE statement used in the first exercise but rather add them using a separate query!
3. Add a new column called last_update. The current date should be added automatically for this column when new data is inserted.
4. Add automatic counter for salarydataID column so that this field value will be automatically generated each time a new data is inserted.
Input validation
5. Create input validation check with TRIGGER. The following checks has to be made:
* Salary cannot be under 1000 and cannot exceed 12000 euros.
* Salary value must be even (salary % 2 = 0). For example, only salary values 1000, 1002, 1004 etc. are accepted.
Answers: 3
Computers and Technology, 21.06.2019 12:30
Svieta is making a chart of the hours that different employees have put into a team project at work. what formula would autosum most likely generate if added into b8?
Answers: 1
Computers and Technology, 21.06.2019 21:30
What’s the process of observing someone actually working in a career that interests you?
Answers: 1
Computers and Technology, 23.06.2019 10:00
What is estimated time of arrival (eta)? a device that measures the acceleration (the rate of change of velocity) of an item and is used to track truck speeds or taxi cab speeds a gps technology adventure game that posts the longitude and latitude location for an item on the internet for users to find a north/south measurement of position the time of day of an expected arrival at a certain destination and is typically used for navigation applications
Answers: 3
Computers and Technology, 23.06.2019 19:30
What are loans to a company or government for a set amount of time
Answers: 1
* Ocelot exercise database presented in SQL basics 1 will be used in this exercise
* Return exerci...
Computers and Technology, 18.09.2021 14:00
Chemistry, 18.09.2021 14:00
Social Studies, 18.09.2021 14:00
Mathematics, 18.09.2021 14:00
Chemistry, 18.09.2021 14:00
Physics, 18.09.2021 14:00
Social Studies, 18.09.2021 14:00
Social Studies, 18.09.2021 14:00
Mathematics, 18.09.2021 14:00
English, 18.09.2021 14:00
Mathematics, 18.09.2021 14:00