Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
Illustrate the difference between logical data independence and physical data independence? Which one is harder to accomplish? Explain why?
What are the merits and demerits of Top-Down Approach and Bottom-Up Approach for the data warehouse design?
Distinguish between the data warehouse and operational database.
What do you mean by primary goal of normalization? How the concepts of functional dependency and multi are valued dependency related with the normalization? Give an illustration for the same.
Illustrate the responsibilities of the Database Administrator (or DBA)?
Consider a relational database regarding hotels, customers (or guests) and their bookings which is maintained by an online hotel booking company.
Consider the given employee database, where the primary keys are underlined. Give an expression in the SQL for each of the given queries:
Illustrate the key properties of long duration transactions? How does the concurrency protocol influence the long duration transactions?
List all the four significant differences between the file-processing system and DBMS.
Write down the uses of Distributed Databases. Explain. Write down the features of the heterogeneous services.
What do you understand by the term partition algorithm? Illustarte with the aid of appropriate illustration.
What is normalization? Explain 1NF, 2NF, 3NF with examples?
Write down the different types of partitioning methods. Discuss in detail. Illustrate out the concept of Type Inheritance and Hierarchies with illustrations. Also discuss multiple inheritances.
Write a program in FOXPRO to determine the average of any ten numbers.
Discuss and describe the classification of DBMS based upon location of database. Illustrate out the term functional dependency. Provide examples. Also describe 1st, 2nd and 3rd normal Forms.
Make a table student with attributes student roll number, name, total marks and percentage. Do the following operations:
Write down the difference between the random access and sequential access?
What are the various kinds of database end users? Explain the major activities of each.
Write down the SQL queries by using Data Manipulation Language (DML) statements. Make the payroll database considering table employee.
Describe time complexity of an algorithm. Describe space complexity of the algorithm.
What are the advantages of normalized ER-Model? What are the various kinds of data constraints?
Demonstrate an equi Join operation with suitable example.
Illustrate out e-commerce architecture and then concisely illustrate each one of its components.
Use following business rules to make the E-R diagram. You must clearly show all the minimum and maximum cardinality constraint on each side of relationship.
By using the data above, normalise the relation to Third Normal Form. Show any intermediate relations and explain each step in the normalisation process. Underline the keys in each relation.