“Data is processed into Valuable Information and Valuable Information is processed into Knowledge” Give your opinion for the statement in the detail.
[7 marks]Define the Following: 1. DDL 2. Derived Attribute 3. Normalization 4. Candidate Key 5. Tuples 6. Functional Dependency 7. SQL
[7 marks]Explain Codd’s 12 Rules in detail.
[7 marks]Define Data Abstraction. Differentiate between Logical and Physical Data Interdependence.
[7 marks]Explain the following Models with neat diagram and suitable example: 1) Relational Model 2) Network Model 3) Hierarchical
[7 marks]Explain various Components of Database with Examples.
[7 marks]Discuss in brief Data Dictionary. Describe various types of users of DBMS.
[7 marks]Define Data Integrity. Discuss various Integrity Constraints of DBMS.
[7 marks]Differentiate between Strong and Weak Entity Set. Also Discuss aggregate functions with example(s).
[7 marks]Draw an E – R Model as per following: There are 1000 Students in a college pursuing various courses like 10% are in MBA, 25% are in BBA, 15% are in MCA and rest are in Engineering.
[7 marks]What is Normalization? Explain any 2 Forms of your choice with suitable example.
[7 marks]Draw an E-R Diagram for the situation given below: Auniversity consists of a number of departments. Each department offers several courses. Anumber of modules make up each course. Students enroll in a particular course and take modules towards the completion of that course. Each module is taught by a lecturer from the appropriate department, and each lecturer tutors a group of students.
[7 marks]Discuss the functions of SQL- ROLLBACK, COMMIT, SAVEPOINT.
[7 marks]Enlist SQL commands for DML. Consider following relations and write SQL queries for given statements.1 Assume suitable constrains. Department (dept-no, dept-name) Job(job-id, job-title, minimum-salary, maximum-salary) Employee(emp-no, emp-name, emp-salary,dept-no) Deposit(acc-no, cust-name, branch-name, amount, account-date) Borrow(loan-no, cust-name, branch-name, amount) 1. Give name of depositors whose branch name starts from ‘P’. 2. Give employee name(s) whose salary is between Rs. 50000 to 70000 and department name is Production. 3. Delete borrower details whose amount is more than 20000.
[7 marks]What is RDBMS? What is the Structure of Relational Data?
[7 marks]From the Given Data, Create 5 Different Queries and Sub Queries: Roll No First Name Last Name Subject 1001 Abhinav Dushyant Marketing 1002 Keshav Gandhi Finance 1003 Jagruti Patel Marketing 1004 Vijay Gohil Human Resource 1005 Swati Rawal Finance
[7 marks]Discuss the role of Data Warehouse for Online Retailer.
[7 marks]