Question

[3.0] make 10 questions for the database design

[4.4] make 4 questions for the system processes (application)

[5] Find out ten queries (for certain data retrieval or update) for your group project. (1 point)

Answer 1

Ans:1 Most important data base design questions can be:-

1.Define Database Design?

2. Define the term Logical Design Of A Database?

3 Describe Logical Data Model?

4.What do you mean by Physical Data Model?

5.What Is the concept of Conceptual Design Of A Database?

6. What Are important fuctions Of A Physical Data Model

7.What Are functions Of Conceptual Data Model?

8.Distinguish Between Logical Data Model And Conceptual Data Model?

9. Define the term Data Modeling?

10. What Are The Steps included To Design Logical Data Model?

Questions on System process:-

Q1:-Give some advantages of multithreaded programming.

Q2: Define Fragmentation?

Q3: Explain advantages and disadvantages of a command line interface?

Q4:What do you mean by plumbing?

Ans3:10 queries can be:-

Q1. Write a SQL query to fetch the count of employees working in project 'C1'.

Q2: Write a SQL query to fetch employee names having salary greater than or equal to 5100 and less than or equal 10100

Q3: Write a SQL query to fetch all the Employees who are also ext-managers from EmployeeD

Q4:-please write a query to fetch employee names and salary records. Return employee details even if the salary record which isnot present for the employee.

Q5: Write a SQL query to provide duplicate records from a table

Q6: Provide a SQL query to fetch only odd rows from table.

Q7:Write a SQL query in order to provide all the Employees details from EmployeeDetails table who joined in Year 2022

Q8:- Write SQL query in order to find the nth highest salary from table.

Q9:Write Sql query update emp_id if emp_name='Flash'

Q10:Insert empname,empnumber,empaddreess values Rakesh,1234,CTF-3/1

.