Databases | SQL | Oracle | MS Access Answers

The aim of this project is to simulate a proper systems design, will need to make the necessary assumptionsto identify the design requirements

12:Details about the design problem as understood by the design team

Scope

Identifying stakeholders

Identifying key functional and non-functional requirements

Identifying an estimate of the project

Identifying a time schedule for the project

13. Constraints and limitations on the design

14. Assumptions made

f. Designing the software systems using various types of models as follows: An entity relationship diagram

g. A matching class diagram

h. A complete set of use case diagrams

i. Activity diagrams for use cases related to establishing new projects

j. System sequence diagrams for the diagrams in d.

Each Model should be introduced and point out the aim of the model and how you design it. Include a brief explanation and description for each model.

Implementation and deployment of the Solution

5. Details about the design problem as understood by the design teamQuestions 5 [---/2 pts]

• Scope

 Identifying stakeholders

 Identifying key functional and non-functional requirements

 Identifying an estimate of the project

 Identifying a time schedule for the project

6. Constraints and limitations on the designQuestions 6: [---/1 pts]

7. Assumptions madeQuestions 7: [---/1 pts]

8. Designing the software systems using various types of models as follows:Questions 8: [---/5 pts]

a. An entity relationship diagram

b. A matching class diagram

c. A complete set of use case diagrams

d. Activity diagrams for use cases related to establishing new projects

e. System sequence diagrams for the diagrams in d.

Each Model should be introduced and point out the aim of the model and how you design it. Include a brief explanation and description for each model.

9. Implementation and deployment of the SolutionQuestions 9: [---/2

get the total number of users subscribed for the channel tyler oakley

Consider the following snippets of code. Then, identify and describe the sorting algorithm used. num scores[5] = 90,85,65,95,75 sort() x = 1 while x < SIZE temp = scores[x] y = x – 1 while y >= 0 AND scores[y]>temp scores[y+1] = scores[y] y = y – 1 endwhile scores[y+1] = temp

Write the code solution using an explicit cursor with a simple Loop. Make sure to use your own variables.

Write a PL/SQL code to find the sum of digits of even digits from a number fetched from a table using implicit cursors and check if the sum is prime number or not.

Suppose you are given a transaction:

read(A);

A:= A - 150;

write(A);

read(B);

B:= B + 150;

Write (B).

Now, describe A-C-I-D properties for the above transaction.

Consider the functional dependency of relation R (M, N, R, P)

F = {M→NR, N→R, M→N, MN→RP }

Compute the canonical cover Fc of F

Define exception handling in your own words then justify, using at least four examples of pre‐ defined system exceptions. (10 marks)

Using your code examples, explain what the following are and when you would use them:



A subquery.



A Join.