se SQL program Server2014 ... A company undertakes a number of projects, the employees work on it, and during the process of analyzing the system we found the following points: The company is made up of a number of departments (the department number, which is a single number, the name of the department, the department's website) There are employees (the employee's number is a single number, his name, address, salary, and job) The employee belongs to one department only, and each department has more than one employee. There are projects (the project number, which is a single number, the name of the project, the project site) Each project has a specific department that it manages, and the department may manage it more than one project. More than one employee works in the project, and the employee may work in more than one project. Each employee has a number of work hours per week in each project. Required: 4. Create a Trigger that indicates the end of the entry operation on any of the previous tables.

If for example you are creating a hospital database, can you identify which of the following are the entities and which are attributes. Nurse Check up date Rate Per Hour Address Phone Number Religion Consultation Fee Hospital Physician Room Number

The following database is maintained by a bookstore: the database structure is shown below. AUTHOR(AuthorName) BOOK(ISBN, AuthorName, Title, PublisherName, PublicationYear, RetailPrice)AuthorName foreign key to AUTHORPublisherName foreign key to PUBLISHER PUBLISHER(PublisherName) CUSTOMER(CustomerNumber, Name, Address, Phone, Email, CreditCardNumber, ExpiryDate) ORDER(OrderNumber, CustomerNumber, OrderDate)CustomerNumber foreign key to CUSTOMER ORDERDETAIL(OrderNumber, ISBN, QuantitySold, RetailPrice, TotalCost)OrderNumber foreign key to ORDER Write SQL code to implement the following separate queries numbered 1 to 4: 1. Find all orders placed in 2018-2019.  2. Report the following information: ISBN, AuthorName, Title, RetailPrice for all books written byAlexandre Dumas or by Mark Twain, published by ClassicsPublishingCo, with a retail price at least$24.99. 3. Create a table which shows the value of orders by each customer who actually placed an orderin 2019. Group in order by customer…