Databases | SQL | Oracle | MS Access Answers

https://docs.google.com/document/d/16o4eJA_nK8IyUxHcPhavXGYliqWpnHujbm1JDnZ3Z5M/edit?usp=sharing

Click on the above link and Identify User Characteristics or types of users from the above scenario.

a) Create the above two relations and impose the following constraints on that (10 marks) Attribute name Data type Constraints ID Number (7) Primary key Name Varchar (15) Not Null Deptname Char(3) Not Null Foreign key for instructor relation Primary key for department relation Budget Number (7) NOT NUll

b) Insert the following tuples to the department relation “MGBlock, CSE, 50L” & “SJTAnnex, CHE, 16L” – Present the output for each insertion. (5 marks) c) Form a new relation from with the following attributes – building, department, budget, number of instructors in each department. Name the new relation as Dept_Instcount - (10 marks) d) Update the tuple of Dept_Instcount – if instructor count is more than 2, increase the budget to 30L. (10 marks) e) Implement question – (b) as a trigger (10 marks) 

1. Insert a node at beginning

2. Insert a node at end

3. Delete a node from beginning

4. Delete a node from end

5. Count number of nodes in Circular linked

list

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.