Databases | SQL | Oracle | MS Access Answers

1. Create a databases of Finance and do the 4 triggers, 4 procedures and 4 functions by SQL codes.

1. A Database of Finance by four functions, four projections and four triggers?please help

Q.1.1. Distinguish between brief use case description and fully developed use case description. (4)

Q.1.2. Identify four use cases that has Commissioner as an Actor and use your own words to construct a brief use case description for each use case you have identified. (13)

Q.1.3. Choose one of the Use Cases you have identified in Q.1.2 above and create a fully developed use case description. You do not have to include Flow of Activities and Exception Conditions. Please put your answer in a tabular form. (13)

Study the ERM below and answer the questions that follow. The ER diagram captures relationships between production lots (or batches), individual production units, and raw materials.

3.1 Using SQL , design the above conceptual model, with attention to the relationships. Show a screenshot of your logical model.

3.2 Show the SQL query generated for creating the logical model you created in Question 3.1 above.

3.3 Put pseudo data into the tables. After putting the data into the tables, run the following queries:

a. Display all material types contained in the database.

b. Display the results of the inner joint between Lot and Production Units.

c. Create a view of your choice and state what is shown.

Big Data techniques are not as widely used by professional accountants as in other related fields…

a.

True.

b.

False.

1. Create a database and do the Triggers.

 Using the syntax of creating Triggers.

o After Insert

o Before Insert

o After Update

o Before Update

o After Delete

o Delete Trigger

 Create a database and tables.

 Import any data with 10 values.

 Provide me the sql file or screenshot per commands and show the

BEFORE and AFTER of the data.

Suppose there are two relations r and s, such that the foreign key B of r references the

primary key A of s. Describe how the trigger mechanism can be used to implement

the on delete cascade option, when a tuple is deleted from s.