Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
Write down the different merits and demerits of data warehousing?
What is deadlock? What are the FOUR necessary conditions for a deadlock occurrence? How deadlock can be prevented?
Briefly explain the three levels of data abstraction? Describe indexed file organization?
Describe the basic operations that can perform using relational algebra. Also describe the concept of referential integrity in database management system.
What do you mean by data conversion function? What do you mean by partitioned views? Write down are the advantages of indexes?
What is Normalization and its need? Explain in brief the different steps used to normalize any data base.
Describe the architecture of Database system. Explain different types of security methods to be established in RDBMS.
Explain the differences between trivial and nontrivial dependencies. Write down the difference between function and procedure?
Create two tables company_info with fields, emp_id, name, city, salary, designation, date_of_joining and personal_info with fields name, city, address, DOB, and phone_no. Modify the table by adding
Write down the syntax for creating the two table with primary key and foreign key as roll for both the table?
Describe the BOYCE-CODD Normal Form? Describe Normal Forms Based On Primary Key?
What do you mean by E-R model? What are the components used to draw an E-R diagram? Write down the advantage and disadvantage?
Describe two-tier client/server architectures for DBMS? Describe three-tier client/server architectures for DBMS?
Describe hiding and un- hiding a column? Describe the steps for the printing the tables?
Describe the advantages and disadvantages of hierarchical model? What do you mean by relationship and describe the types of relationships?
Describe the record based data models in RDBMS? What are the logical operator describe all with their syntax?
Write down three kinds of Record based logical model? Explain entity set, attributes, entities in detail with suitable example?
What do you understand by database package? Distinguish between DBMS and RDBMS? What do you mean by DBMS?
Name some DDL and DML command? Write down the syntax for Alter command? What do you mean by RDBMS, entity?
Make a Relational Data Model to implement a business state that is explained by using an Entity Relationship Diagram and text.
Use a join to display the employee identification number and employee name of all employees of the production department.
Describe in detail about Multi dimensional analysis and descriptive mining of complex data objects.
Describe data warehouse process. Describe the different system management tools in a data warehouse.
Write down the advantages of SQL CODE? Write in detail Triggers predicates and Trigger Mutating tables.
Describe embedded SQL and dynamic SQL in detail: