
a) Discuss the advantages and disadvantages of DBMS.
This question has 0 answers so far.


Briefly define three level of data abstraction
This question has 0 answers so far.


Briefly define three level of data abstraction
This question has 0 answers so far.


b) Why is relation database approach better than carlier methods?
This question has 0 answers so far.


Consider the following MAILORDER relational schema describing the data for a mail order company.
PARTS(Pno, Pname, Qoh, Price, Olevel)
CUSTOMERS(Cno, Cname, Street, Zip, Phone)
EMPLOYEES(Eno, Ename, Zip, HireDate)
ZIP CODES(Zip, city)
ORDERS(One, Cno, Eno, received, Shipped)
ODETAILS(Ono. Pno. Qty)
The attribute names are selfexplanatory:Qoh stands for quantity on hand. Specify the following queries using Relational Algebra:
List the name of parts that costs less than Rs. 200
This question has 0 answers so far.


Consider the following MAILORDER relational schema describing the data for a mail order company.
PARTS(Pno, Pname, Qoh, Price, Olevel)
CUSTOMERS(Cno, Cname, Street, Zip, Phone)
EMPLOYEES(Eno, Ename, Zip, HireDate)
ZIP CODES(Zip, city)
ORDERS(One, Cno, Eno, received, Shipped)
ODETAILS(Ono. Pno. Qty)
The attribute names are selfexplanatory:Qoh stands for quantity on hand. Specify the following queries using Relational Algebra:
List the name of customers who have ordered parts from employees living in Mumbai.
This question has 0 answers so far.


Consider the following MAILORDER relational schema describing the data for a mail order company.
PARTS(Pno, Pname, Qoh, Price, Olevel)
CUSTOMERS(Cno, Cname, Street, Zip, Phone)
EMPLOYEES(Eno, Ename, Zip, HireDate)
ZIP CODES(Zip, city)
ORDERS(One, Cno, Eno, received, Shipped)
ODETAILS(Ono. Pno. Qty)
The attribute names are selfexplanatory:Qoh stands for quantity on hand. Specify the following queries using Relational Algebra:
List the name of customers who have placed exactly two orders
This question has 0 answers so far.


Construct appropriate tables for the above ER diagram.
This question has 0 answers so far.


Construct appropriate tables for the above ER diagram.
This question has 0 answers so far.


Consider the following relational schema: Emp (cmpno, ename, job, sal, comm., hiredate, deptno)
Dept (deptno, dname, location)
Give an expression in SQL for the following Queries:
d) Create the table Dept.
This question has 0 answers so far.


Differentiate between physical and logical data independence.
This question has 0 answers so far.


Define strong and weak entity.
This question has 0 answers so far.


Define primary key and candidate key.
This question has 0 answers so far.


Define entity integrity and referential integrity constraint
This question has 0 answers so far.


Define domain constraint and union compatible.
This question has 0 answers so far.


Define update and insertion anomalies.
This question has 0 answers so far.


Define starvation and time stamp.
This question has 0 answers so far.


Define Schedule and serialisability.
This question has 0 answers so far.


Define binary locking and multiple locking.
This question has 0 answers so far.


Write syntax of UPDATE and INSERT command.
This question has 0 answers so far.


Design and explain the ER diagram of college database with following consideration also indicate the relationship cardinality.
College keeps the track of students, faculties, departments and courses organized by various department.
This question has 0 answers so far.


Design and explain the ER diagram of college database with following consideration also indicate the relationship cardinality.
College contains various departments and each department is assigned a unique id and Some faculty members are also appointed to each department and one of them at as head of me department.
This question has 0 answers so far.


A number of courses are conducted by each department and ench course is assigned a unique id, name and duration.
This question has 0 answers so far.


Faculty information contains id, name, address, basic salary and phone. A faculty member is assigned to only one department but can teach various course of other departments.
This question has 0 answers so far.


Smdent's information contains roll number (unique), name, address, marks and age. A student can opt one course only.
This question has 0 answers so far.


Guardian information is also kept along with cach student, which keeps guardian name, age address and phone.
This question has 0 answers so far.


Explain sub class, super class, generalization and specialization with example.
This question has 0 answers so far.


Discuss three tier architecture of database management system in detail. Explain each term used in the architecture. Write its advantages.
This question has 0 answers so far.


What are the drawbacks of file management system explain them?
This question has 0 answers so far.


Consider the following table
client (client_no, name, city, pin_code, state, bul_due)
product(product_no, description, unit, sell_price, codt_price)
salesman(salesman_no , name, city, pin code, sal_amt, tgt__to_get,yet_sal)
Write SQL for each of following:
Create the above tables.
This question has 0 answers so far.


Consider the following table
client (client_no, name, city, pin_code, state, bul_due)
product(product_no, description, unit, sell_price, codt_price)
salesman(salesman_no , name, city, pin code, sal_amt, tgt__to_get,yet_sal)
Write SQL for each of following:
List all sales man who are located in Bombay and have salary equal to 20000.
This question has 0 answers so far.


Consider the following table
client (client_no, name, city, pin_code, state, bul_due)
product(product_no, description, unit, sell_price, codt_price)
salesman(salesman_no , name, city, pin code, sal_amt, tgt__to_get,yet_sal)
Write SQL for each of following:
Add column telephone of data type number and size 10 to client
This question has 0 answers so far.


Consider the following table
client (client_no, name, city, pin_code, state, bul_due)
product(product_no, description, unit, sell_price, codt_price)
salesman(salesman_no , name, city, pin code, sal_amt, tgt__to_get,yet_sal)
Write SQL for each of following:
Change size of sel_price to (10,2)
This question has 0 answers so far.


Consider the following table
client (client_no, name, city, pin_code, state, bul_due)
product(product_no, description, unit, sell_price, codt_price)
salesman(salesman_no , name, city, pin code, sal_amt, tgt__to_get,yet_sal)
Write SQL for each of following:
Change name of salesman to s_man
This question has 0 answers so far.


Explain aggregate functions with example.
This question has 0 answers so far.


Explain LIKE, GROUP BY, ORDER BY AND HAVING clause with example.Explain
This question has 0 answers so far.


Explain numeric functions with example.
This question has 0 answers so far.


What is normalization? Explain in detail INF, 2NF and 3NF with example of each.
This question has 0 answers so far.


What is functional dependency? Explain trivial and non trivial dependency.
This question has 0 answers so far.


What are basic set operstions? Explain with example.
This question has 0 answers so far.


Write the steps to convert ER model to Relational model.
This question has 0 answers so far.


What is a transaction? Explain ACID properties.
This question has 0 answers so far.


What do you mean by concurrent transaction? Explain the problems of concurrent transaction.
This question has 0 answers so far.


What is deadlock? Explain the wait  die and wound wat scheme for deadlock prevention.
This question has 0 answers so far.


What is locking? Explain 2Phase Locking.
This question has 0 answers so far.


Explain the difference between physical and logical data independence.
This question has 0 answers so far.


List differences between file processing and a DBMS.
This question has 0 answers so far.


What is generalization and specialization? What is specialization and generalization hierarchies and lattices?
This question has 0 answers so far.


Explain aggregation with an example.
This question has 0 answers so far.


What is entity integrity, referential integrity and foreign keys? Explain.
This question has 0 answers so far.


Consider the relational database. Employee person names, street, city
Works (person name, compname, salary) Company (compname, city) Manages (person name, manager name) Write the queries in relational algebra and SOL i) Find the names, street address, and cities of residence of all employees who work for
First Bank Corp and earn more than Rs. 10K/month. ii) Find the names of all managers whose employees work for First Bank Corp.
This question has 0 answers so far.


What do you mean by functional dependency?
This question has 0 answers so far.


State inference rules of functional dependency?
This question has 0 answers so far.


Consider the following relation: STUDENT (Subject, Student, Faculty, Term, Grade) Each student receives only one grade in a subject during a terminal examination. A student
can take many subjects and each subject can have more than one faculty in a terminal. Define FD and MVD for this relation. Check the normal form for the relation. If necessary, further normalize.
This question has 0 answers so far.


Explain what is convert channel. Explain polyinstantiation.
This question has 0 answers so far.


Define authorization and security in the database.
This question has 0 answers so far.


Discuss about Statistical database.
This question has 0 answers so far.


Explain timestamp ordering protocol.
This question has 0 answers so far.


What is woundwait and wait die? Explain.
This question has 0 answers so far.


Discuss the relative advantages of centralized and distributed databases.
This question has 0 answers so far.


When it is useful to have replication or fragmentation of data?
This question has 0 answers so far.


Explain: fragmentation transparency, replication transparency, location transparency and naming transparency.
This question has 0 answers so far.


What is a data model? How schema is different from instances? Give examples.
This question has 0 answers so far.


Name different database users and explain the responsibilities of DBA.
This question has 0 answers so far.


What do you mean by mapping constraints? Distinguish between primary key and foreign key.
This question has 0 answers so far.


What do you mean by ISA relationship? Explain the concept of aggregation with a suitable example.
This question has 0 answers so far.


Consider the relational schema: employee (employee no, name, office,age) books(isbn, title, authors, publisher) loan(employee no, isbn, date) Find the names of employees who have borrowed a book published by McGrawHill, write this query in relational algebra
This question has 0 answers so far.


Consider the relational schema: employee (employee no, name, office,age) books(isbn, title, authors, publisher) loan(employee no, isbn, date) Find the names of employees who have borrowed all books published by McGraw Hil, write this query in relational algebra.
This question has 0 answers so far.


Consider the relational schema: employee (employee no, name, office,age) books(isbn, title, authors, publisher) loan(employee no, isbn, date) Find the names of employees who have borrowed more than six different published book by McGrawHil, write this query in relational algebra.
This question has 0 answers so far.


Consider the relational schema: employee (employee no, name, office,age) books(isbn, title, authors, publisher) loan(employee no, isbn, date) Find the names of employees who have borrowed more than six different book publishedby McGrawHill.
write this query in relational algebra.
This question has 0 answers so far.


Consider the relational schema: employee (employee no, name, office,age) books(isbn, title, authors, publisher) loan(employee no, isbn, date) For each publisher , find the names of employees who have borrowed more than seven books of that publishers, write this query in relational algebra.
This question has 0 answers so far.


Why do we normalize a database? What are different normal forms?
This question has 0 answers so far.


What is DKNE? Explain multivalued dependency.
This question has 0 answers so far.


What do you mean by referential integrity constraint? Explain.
This question has 0 answers so far.


What do you mean by data encryption? Why do we need statistical databases?
This question has 0 answers so far.


Define transaction. Discuss the problems associated with concurrent execution of multiple transactions.
This question has 0 answers so far.


Explain timestamp ordering protocol for concurrency control.
This question has 0 answers so far.


What are the fragments of relations in distributed systems?
This question has 0 answers so far.


Discuss the advantages of Distributed Database Management System.
This question has 0 answers so far.


What do you mean by Database Management System? Why it is needed?
This question has 0 answers so far.


Differentiate conventional file system and a DBMS.
This question has 0 answers so far.


Explain the advantages and applications of a DBMS.
This question has 0 answers so far.


Explain the use of DML commands.
This question has 0 answers so far.


Write short notes on database Models.
This question has 0 answers so far.


Write short notes on architecture of DBMS.
This question has 0 answers so far.


Write short notes on data Abstraction.
This question has 0 answers so far.


Write short notes on data Independence.
This question has 0 answers so far.


What do you understand by "Conceptual Modelling". Explain.
This question has 0 answers so far.


What are mapping Cardinalties?
This question has 0 answers so far.


Define Tangible and Nontangible entity.
This question has 0 answers so far.


Define Entity Type and Entity set
This question has 0 answers so far.


Define Simple and Composite attributes.
This question has 0 answers so far.


Define Stored and Derived attributes.
This question has 0 answers so far.


Define Single and multivalued attributes.
This question has 0 answers so far.


Define Strong and weak entity sets.
This question has 0 answers so far.


Why the ER diagrams are needed? Explain different ER diagram notations and naming conventions.
This question has 0 answers so far.


what are the different types of Relationships between Entities?
This question has 0 answers so far.


Give some features of Good Relational Design.
This question has 0 answers so far.


What do you understand by "NORMALISATION"concept? Give its advantages.
This question has 0 answers so far.


What are aggregate operators? Explain with examples.
This question has 0 answers so far.


Discuss various Normal forms upto 3nd in detail. Give suitable examples.
This question has 0 answers so far.


Explain the working of set operators with the help of suitable examples.
This question has 0 answers so far.


What are uses of Reports in MSAccess? How are they created?
This question has 0 answers so far.


Explain nested queries with suitable examples.
This question has 0 answers so far.


Write short notes on Codd's Rules.
This question has 0 answers so far.


Write short notes on Foreign Key Constraints.
This question has 0 answers so far.


Write short notes on Use of creating views.
This question has 0 answers so far.


Write short notes on Functional Dependencies.
This question has 0 answers so far.


Write short notes on Data types in MSAccess.
This question has 0 answers so far.


Write short notes on Concurrency.
This question has 0 answers so far.


Explain what are database views?
This question has 0 answers so far.


Draw an ER diagram for a garment sales company dealing with different types of garments like shirts, pants, shorts and vests. The company keeps the information
about warehouses, vendors and customers. Choose the attributes in such a way that
they are sufficient to represent an entity.
This question has 0 answers so far.


What are functional dependencies? Explain Amstrong's Axioms.
This question has 0 answers so far.


Differentiate between 2NF and 3NF with a suitable example.
This question has 0 answers so far.


Differentiate between a lossy join and a lossless join with suitable example.
This question has 0 answers so far.


What are the various rules for database decomposition? Explain.
This question has 0 answers so far.


List the twelve Codd rules.
This question has 0 answers so far.


Explain the three bered architecture or RDBMS. What are the various levels of abstraction?
This question has 0 answers so far.


Explain the various integrity constraints.
This question has 0 answers so far.


Explain the various operations of SQL DML with suitable examples.
This question has 0 answers so far.


What are aggregate functions in SQL? Explain.
This question has 0 answers so far.


What are nested queries? Explain with suitable example.
This question has 0 answers so far.


Why null values are important in a database? Explain.
This question has 0 answers so far.


Explain the following terms:
a) Primary key
b) Foreign Key
C) Entity Set
d) Relationship Sct
c) Data independance
This question has 0 answers so far.


Write short notes about SQL DDL
This question has 0 answers so far.


Write short notes about Database Administrator.
This question has 0 answers so far.


Write short notes about Extended Entity Relationship Features
This question has 0 answers so far.


Define the term Foreign Key.
This question has 0 answers so far.


Define the term Hashing
This question has 0 answers so far.


Define the term Database.
This question has 0 answers so far.


Define the term Database recovery
This question has 0 answers so far.


Define the term Inheritance
This question has 0 answers so far.


Define the term Constructers
This question has 0 answers so far.


Define the term Data Dictionary
This question has 0 answers so far.


Define the term SOL
This question has 0 answers so far.


Define the term Normaligation
This question has 0 answers so far.


Define the term Full functional dependency.
This question has 0 answers so far.


What is database tuning? How is it useful and used? How is it related with database design? Explain in detail with suitable examples.
This question has 0 answers so far.


Describe various hashing functions with their relative merits and demerits.What problems we may face in hashing and how these can be revolved?
Discuss briefly.
This question has 0 answers so far.


Design any three tables of your choice related to your college and normalize them upto 3NF (at least).
This question has 0 answers so far.


What is Query Processing? How is it useful and implemented? Explain in detail with examples.
This question has 0 answers so far.


Differentiate between simple database and objectoriented database with examples in terms of Design.
This question has 0 answers so far.


Differentiate between simple database and objectoriented database with examples in terms of Uses.
This question has 0 answers so far.


Differentiate between simple database and objectoriented database with examples in terms of Advantages.
This question has 0 answers so far.


Differentiate between simple database and objectoriented database with examples in terms of Disadvantages.
This question has 0 answers so far.


Write short notes on the Relational algebra.
This question has 0 answers so far.


Write short notes on the Data base security.
This question has 0 answers so far.


Write short notes on the Programming using SQL.
This question has 0 answers so far.


What is timestamp based protocol?
This question has 0 answers so far.


Distinguish between nonserializable and serializable schedules.
This question has 0 answers so far.


Define the concept of minimal cover
This question has 0 answers so far.


Discuss the ACID properties of a transaction.
This question has 0 answers so far.


What is the lossless join decomposition?
This question has 0 answers so far.


What do you understand by DCL commands?
This question has 0 answers so far.


How is a weak entity set different from a strong entity set?
This question has 0 answers so far.


Write the syntax of selection and projection operations in relational algebra.
This question has 0 answers so far.


Differentiate between equi join and natural join.
This question has 0 answers so far.


When is a query called relationally complete?
This question has 0 answers so far.


Draw an ER diagram for The Book Club. It has members to whom the books are sold. The books are made available at different places in the citycalled Book Club Chapter to make it easy to members. The books are identifies by a book _id, the author and the publisher. An author can write more than one book and a book can have more than one author. Members have information such as Membership _id, Name, Phone# and status. A member can place more than one order. Choose additional attributes for the schema that seems appropriate. Mention any
assumptions you make. Show minimum and maximum cardinality ratios
based on the assumptions.
This question has 0 answers so far.


Consider the following MAILORDER relational schema describing the data for a mail order company.
PARTS(Pno, Pname, Qoh, Price, Olevel)
CUSTOMERS(Cno, Cname, Street, Zip, Phone)
EMPLOYEES(Eno, Ename, Zip, HireDate)
ZIP CODES(Zip, city)
ORDERS(One, Cno, Eno, received, Shipped)
ODETAILS(Ono. Pno. Qty)
The attribute names are selfexplanatory:Qoh stands for quantity on hand. Specify the following queries using Relational Algebra:
List the name and cities of employees who have taken orders for parts costing more than Rs.500
This question has 0 answers so far.


What is the purpose of integrity constrain in SOL?
This question has 0 answers so far.


What is the difference between WHERE and HAVING clause?
This question has 0 answers so far.


Differentiate between Outer and Inner Join operations?
This question has 0 answers so far.


Define BCNF. How is different from 3NF? Present an example of a relation in 3NF that is not in BCNF.
This question has 0 answers so far.


What is a concurrent transition? What are the problems associated with concurrency?
This question has 0 answers so far.


What is a twophase locking protocol? How does it guarantee serializability?
This question has 0 answers so far.


What is a timestamp? How does the system generate timestamps?
This question has 0 answers so far.


What are the rules followed to ensure serializibility in multiversion techniques based on timestamp ordering?
This question has 0 answers so far.


What is a deadlock? How are deadlocks handled? What is deadlock prevention and how is it different from deadlock detection and deadlock recovery?
This question has 0 answers so far.


Write notes on Checkpoints.
This question has 0 answers so far.


Write notes on Triggers and Assertions
This question has 0 answers so far.


Write notes on EER Model
This question has 0 answers so far.


A table R has attributes A,B,C,D,E and satisfies the following functional dependencies:
A>BC
B> D
CD>E
E> A
What are the candidate keys?
This question has 0 answers so far.


A table R has attributes A,B,C,D,E and satisfies the following functional dependencies:
A>BC
B> D
CD>E
E> A
Is this table in 2NF/3NF/BCNF?
This question has 0 answers so far.


Differentiate between Database and D.B.M.S
This question has 0 answers so far.


What is Data Abstraction? Explain
This question has 0 answers so far.


Explain the difference between physical and logical data independence.
This question has 0 answers so far.


What do you understand by the term "Data Dictionary?
This question has 0 answers so far.


Explain the terms "Entity Set" and "Relationship Set".
This question has 0 answers so far.


What are derived attributes? Explain with an example.
This question has 0 answers so far.


Explain the difference between a weak and a strong entity set.
This question has 0 answers so far.


Explain the Project Operation of a relational model.
This question has 0 answers so far.


What are the components of DBMS? Explain the each component in detail.
This question has 0 answers so far.


Explain the distinctions among the tems primary key, candidate key and superkey
This question has 0 answers so far.


Explain the relational, hierarchical and network models. Also explain their advantages and disadvantages.
This question has 0 answers so far.


Construct an ER diagram for a hospital with a set of patients and a set of medical doctors. Associate with each patient a log of the various tests and examinations conducted.
This question has 0 answers so far.


What are mapping cardinalities?
This question has 0 answers so far.


Discuss the normal forms usingFunctional Dependencies
This question has 0 answers so far.


Discuss the normal forms using Multi valued Dependencies
This question has 0 answers so far.


Discuss the normal forms using Join Dependencies
This question has 0 answers so far.


What are the data types supported by MSACCESS?
This question has 0 answers so far.


Explain the following SQL commands by taking a suitable example.
Create table
This question has 0 answers so far.


Explain the following SQL commands by taking a suitable example.
Insert
This question has 0 answers so far.


Explain the following SQL commands by taking a suitable example.
Update
This question has 0 answers so far.


Explain the following SQL commands by taking a suitable example.
Delete
This question has 0 answers so far.


Explain the referential integrity constraint between two relations.
This question has 0 answers so far.


What are the three ways of creating a form in MSACCESS database? Explain the purposes of using forms and labele in MSACCESS
This question has 0 answers so far.


List and explain the Codd's rules for RDBMS How many rules are satisfied by MS ACCESS?
This question has 0 answers so far.


Explain Database end users.
This question has 0 answers so far.


What is entity? Explain strong and weak entity.
This question has 0 answers so far.


Define Insért, Update and Delete anomalies.
This question has 0 answers so far.


Define aggregation and generalization.
This question has 0 answers so far.


What do you mean by data independence? Explain physical and logical data independence.
This question has 0 answers so far.


List the advantage of Database Management System over Traditional File Based System.
This question has 0 answers so far.


What is data abstraction? Explain all three level of abstraction.
This question has 0 answers so far.


Explain Different data models with their relative advantage.
This question has 0 answers so far.


Who is Database Administrator (DBA)? Explain the role and responsibilities of DBA.
This question has 0 answers so far.


Explain 1", 2nd and 3rd Normal forms with example. Draw an ER diagram for college database, also find out entities, their attributes and relationship among them, whose points are given below
One student can opt one course but one course can opt by many students.
This question has 0 answers so far.


Explain 1", 2nd and 3rd Normal forms with example. Draw an ER diagram for college database, also find out entities, their attributes and relationship among them, whose points are given below
One course can be taught by many faculties and one faculty can taught many courses.
This question has 0 answers so far.


Explain 1", 2nd and 3rd Normal forms with example. Draw an ER diagram for college database, also find out entities, their attributes and relationship among them, whose points are given below
In a department there can be any number of faculty members but each faculty member belongs to one department only.
This question has 0 answers so far.


Explain 1", 2nd and 3rd Normal forms with example. Draw an ER diagram for college database, also find out entities, their attributes and relationship among them, whose points are given below
Many students can enrolled in one department but a student can not enrolled in more then one department.
This question has 0 answers so far.


Explain 1", 2nd and 3rd Normal forms with example. Draw an ER diagram for college database, also find out entities, their attributes and relationship among them, whose points are given below
A student can have more then one local guardian but one guardian is assumed to be relate to one student only
This question has 0 answers so far.


What is an attribute? Explain types of attribute used in ER model with example
This question has 0 answers so far.


What are Basic Set Operations? Explain with example
This question has 0 answers so far.


Define candidate key, primary key and alternate key.
This question has 0 answers so far.


Define Domain constraint, Primary key constraint, and Referential Integrity constraints
This question has 0 answers so far.


Explain 1", 2nd and 3* Normal forms with example.
This question has 0 answers so far.


Define Functional Dependency.
This question has 0 answers so far.


What do you mean by Update, Insert and Delete anomalies? Discuss in detail
This question has 0 answers so far.


Consider the relation Library (member_id, member_namne, member_address, book_codebook_name, issue_date, return_date), this relation boxes information about issue and retum of books in a library to its member. A member can be issued many different books but one copy of same book.
What anomalies can occur in the above relation
This question has 0 answers so far.


Consider the relation Library (member_id, member_namne, member_address, book_codebook_name, issue_date, return_date), this relation boxes information about issue and retum of books in a library to its member. A member can be issued many different books but one copy of same book.
What are the functional dependencies in the above relation
This question has 0 answers so far.


Consider the relation Library (member_id, member_namne, member_address, book_codebook_name, issue_date, return_date), this relation boxes information about issue and retum of books in a library to its member. A member can be issued many different books but one copy of same book.
Normalize the above relation up to 3 normal form
This question has 0 answers so far.


Define tuple and attribute
This question has 0 answers so far.


Consider the following table
Employee(eid, name, sal, deptt, job)
Write SQL for each of following:
Create Employee table.
This question has 0 answers so far.


Consider the following table
Employee(eid, name, sal, deptt, job)
Write SQL for each of following:
Add a attribute address in above table.
This question has 0 answers so far.


Consider the following table
Employee(eid, name, sal, deptt, job)
Write SQL for each of following:
Find the name of employee having maximum sal.
This question has 0 answers so far.


Consider the following table
Employee(eid, name, sal, deptt, job)
Write SQL for each of following:
Find the name of employee whose name begins with's
This question has 0 answers so far.


Write the syntax of Insert and Delete command.
This question has 0 answers so far.


What are aggregate functions? Explain with example.
This question has 0 answers so far.


Write short note on data type used in MSAccess
This question has 0 answers so far.


Write steps to create report in MSAccess.
This question has 0 answers so far.


Compare and contrast the Traditional File Based System with Database Management System
This question has 0 answers so far.


What do you mean by data independence? Explain physical and logical data independence
This question has 0 answers so far.


Who is Database Administrator (DBA)? Explain the role and responsibilities of DBA.
This question has 0 answers so far.


What are the main features of ER model? Define strong and weak entity set.
This question has 0 answers so far.


State the difference between Generalization and Specialization with example.
This question has 0 answers so far.


Define OnetoOne, OnetoMany and ManytoMany relationship cardinality between two entity sets with example.
This question has 0 answers so far.


Define Domain constraint, Primary key constraint, and Referential Integrity constraints.
This question has 0 answers so far.


Define candidate key, primary key and alternate key
This question has 0 answers so far.


What are Basic Set Operations? Explain with example.
This question has 0 answers so far.


Write short notes on What is data redundancy?
This question has 0 answers so far.


Write short notes on Discuss various types of keys in relational data model.
This question has 0 answers so far.


Write short notes on Distinguish between logical and physical data independence.
This question has 0 answers so far.


What are the rules for decomposition of relations? Explain
This question has 0 answers so far.


How does the concept of an object in the object oriented model differ from the concept of an entity in the entity relationship model?
This question has 0 answers so far.


What are the major functions performed by the DBMS? Explain
This question has 0 answers so far.


Explain the role of database administrator.
This question has 0 answers so far.


Explain the three tiered architecture of relational model.
This question has 0 answers so far.


Explain the advantages of DBMS over a file system
This question has 0 answers so far.


Explain the 12 Codd Rules for relational model.
This question has 0 answers so far.


What are database views? How the views are created? Explain.
This question has 0 answers so far.


Design an ER diagram for keeping track of the exploits of your favourite cricket team. You should store the matches played, the scores in each match, the
players in each match, and individual player statistics for each match Convert it
to tables.
This question has 0 answers so far.


Explain various attribute types.
This question has 0 answers so far.


What is normalization? Explain third normal form with a suitable example.
This question has 0 answers so far.


What is schema refinement? Explain
This question has 0 answers so far.


What is functional dependency? Given Relation R (A, B, C, D, E) satisfies that
following functional dependencies:
AB>C
C>A
BC>D
ACD>B
BE>C
Find out the closure of FD'S.
This question has 0 answers so far.


What are various types of anomalies that can occur in a relational database?How they can be removed? Explain with an example
This question has 0 answers so far.


Explain various SQL DDL commands with proper example.
This question has 0 answers so far.


How integrity constraints are enforced in SOL? Explain
This question has 0 answers so far.


Write down the following queries in SQLSuppliers (sno, sname, pincode, city)
Parts (pno, pname, color weight)
Projects (projno, projname, city)
Shipments (sno, pno, projno)
(a) Get supplier name and city for suppliers who supply to any project with a 'red'
colored part.
This question has 0 answers so far.


Write down the following queries in SQLSuppliers (sno, sname, pincode, city)
Parts (pno, pname, color weight)
Projects (projno, projname, city)
Shipments (sno, pno, projno)
Get part name, color and project name supplied by supplier with sno's 2
This question has 0 answers so far.


Write down the following queries in SQLSuppliers (sno, sname, pincode, city)
Parts (pno, pname, color weight)
Projects (projno, projname, city)
Shipments (sno, pno, projno)
Get the total number of suppliers who supplied part with pno '1'.
This question has 0 answers so far.


Discuss the advantages and disadvantages of DBMS over file processing system.
This question has 0 answers so far.


Draw and explain the architecture of DBMS.
This question has 0 answers so far.


Differentiate between network model and relational model.
This question has 0 answers so far.


Why is relational model more popular over other models of DBMS?
This question has 0 answers so far.


What is 'logical schema?
This question has 0 answers so far.


Explain how concurrency is handled by DBMS?
This question has 0 answers so far.


Explain the types of attributes represented in ER model. How are the entity Sets different from relationship sets?
This question has 0 answers so far.


Construct an ER diagram for hospital management system. By choosing your own entity and relationship sets. .
This question has 0 answers so far.


Reduce down the above ER model into the table structure.
This question has 0 answers so far.


Consider the employee database. Emp (empno, ename, job, salary,hiredate, deptno)
Dept (deptno, dname, location Give an expression in SCL for the following queries:
Display the empno and dname of the employee named "Anit'.
This question has 0 answers so far.


Consider the employee database. Emp (empno, ename, job, salary,hiredate, deptno)
Dept (deptno, dname, location Give an expression in SCL for the following queries:
Display the total salary of each deptno encluding, the employees who are 'clerk'.
This question has 0 answers so far.


Consider the employee database. Emp (empno, ename, job, salary,hiredate, deptno)
Dept (deptno, dname, location Give an expression in SCL for the following queries:
Give 20 percent salary hike to all the employees, work in deptno 30.
This question has 0 answers so far.


Consider the employee database. Emp (empno, ename, job, salary,hiredate, deptno)
Dept (deptno, dname, location Give an expression in SCL for the following queries:
Create the table Emp.
This question has 0 answers so far.


Consider the employee database. Emp (empno, ename, job, salary,hiredate, deptno)
Dept (deptno, dname, location Give an expression in SCL for the following queries:
Insert the details of new employee in the Emp table.
This question has 0 answers so far.


Consider the employee database. Emp (empno, ename, job, salary,hiredate, deptno)
Dept (deptno, dname, location Give an expression in SCL for the following queries:
Display the name of the employee who is having maximum Salary.
This question has 0 answers so far.


List and explain the Codd's rules of DBMS.
This question has 0 answers so far.


What is referential integrity constraint? Explain.
This question has 0 answers so far.


How are the views created? Explain by giving the syntax.
This question has 0 answers so far.


Differance between Functional dependencies and fully functional dependencies?
This question has 0 answers so far.


discuss the Differance between 3 NF and 2NF.
This question has 0 answers so far.


Discuss the Differance between 2 NF and INF
This question has 0 answers so far.


Discuss the Differance between Data definition language and Data manipulation language.
This question has 0 answers so far.


Discuss the Differance between Normalization and Denormalization.
This question has 0 answers so far.


Explain by giving suitable examples, the working of set operators ie. Union, Intersect, and Except.
This question has 0 answers so far.


What are the uses of forms in MSAccess? How are they created?
This question has 0 answers so far.


How are the aggegate operators deals with null values?
This question has 0 answers so far.


Breifly define entity
This question has 0 answers so far.


Briefly define super key and primary key.
This question has 0 answers so far.


briefly define normalization.
This question has 0 answers so far.


Briefly define tuples and attribute
This question has 0 answers so far.


Briefly define mail merge
This question has 0 answers so far.


Briefly define SQL
This question has 0 answers so far.


Briefly define UNION and INTERSECTION.
This question has 0 answers so far.


Differentiate between loss less and lossy decomposition with example.
This question has 0 answers so far.


Give five examples statements of each DDL and DML.
This question has 0 answers so far.


Explain primary key, secondary key candidate key and forign key in brief.
This question has 0 answers so far.


Draw ER diagram corresponding to customers and Loan. Explain the various shapes and lines used in ER Model.
This question has 0 answers so far.


Define the following anomalies
(a) Update anomaly
(b) Insertion anomaly
(c) Deletion anomaly
This question has 0 answers so far.


Explain the purpose of the database system.
This question has 0 answers so far.


Explain different Database users.
This question has 0 answers so far.


List three reasons why null values might be introduced to the database.
This question has 0 answers so far.


Mention the fundamentals operations of relational DBMS and their symbol.
This question has 0 answers so far.


Write short notes on Creating Report using Report Wizard
This question has 0 answers so far.


Write short notes on Access object understanding
This question has 0 answers so far.


Write short note on Codd rules
This question has 0 answers so far.


We have following relations:
Supplier(S=, sname, status, city)
Parts(P#, pname, color, weight, city)
SPISA, P#, quantity
Answer the following queries in SQL:
Find the supplier for city  Delhi'.
This question has 0 answers so far.


We have following relations:
Supplier(S=, sname, status, city)
Parts(P#, pname, color, weight, city)
SPISA, P#, quantity
Answer the following queries in SQL:
Find suppliers whose name start with 'AB
This question has 0 answers so far.


We have following relations:
Supplier(S=, sname, status, city)
Parts(P#, pname, color, weight, city)
SPISA, P#, quantity
Answer the following queries in SQL:
Find all suppliers whose status is 10, 20 or 30.
This question has 0 answers so far.


We have following relations:
Supplier(S=, sname, status, city)
Parts(P#, pname, color, weight, city)
SPISA, P#, quantity
Answer the following queries in SQL:
Find total number of city of all suppliers.
This question has 0 answers so far.


We have following relations:
Supplier(S=, sname, status, city)
Parts(P#, pname, color, weight, city)
SPISA, P#, quantity
Answer the following queries in SQL:
Find the name of suppliers who supplies quantity of the item P1 more than 50.
This question has 0 answers so far.


What does defining, manipulating and sharing of a database mean?
This question has 0 answers so far.


Discuss the main characteristics of the database approach and how it differs from traditional file systems.
This question has 0 answers so far.


Describe the three  schema architecture. What is the difference between logical and physical data Independence?
This question has 0 answers so far.


Differentiate the following: I) Entity and Attribute
This question has 0 answers so far.


Differentiate the following: ii) Entity type and Entry set
This question has 0 answers so far.


Differentiate the following: iii) Strong and weak Entity
This question has 0 answers so far.


Differentiate the following: iv) Recursive relationship and Identifying relationships
This question has 0 answers so far.


A database is being constructed to keep track of the teams and games of a sports league. A team has a number of players, not all of whom participate in each game. It is desired to keep
track of the players participating in each game for each team, the positions they played in
that game and the result of the game. Design an ER diagram for this application, stating any
assumptions you make. Choose your favorite sport (e.g Cricket Base ball, Football).
This question has 0 answers so far.


Explain the entity integrity and referential integrity constraints. Why each is considered important?
This question has 0 answers so far.


Briefly discuss the different types of update operations on a relation.
This question has 0 answers so far.


Consider the following relational schema. Emp (eid, ename, age, sal)
Works_foreid, pid, #hrs)
Proj (pid, pname)
Write the Queries in Relational algebra for the following:
i) Retrieve Employee Id and Name of the employees who work for all the projects.
This question has 0 answers so far.


Consider the following relational schema. Emp (eid, ename, age, sal)
Works_foreid, pid, #hrs)
Proj (pid, pname)
Write the Queries in Relational algebra for the following:
ii). Retrieve Name and Age of employees whose salary > 10000.
This question has 0 answers so far.


Consider the following relational schema. Emp (eid, ename, age, sal)
Works_foreid, pid, #hrs)
Proj (pid, pname)
Write the Queries in Relational algebra for the following:
iii) For each employee, get the number of projects and number of hours worked on projects.
This question has 0 answers so far.


Consider the following relational schema. Emp (eid, ename, age, sal)
Works_foreid, pid, #hrs)
Proj (pid, pname)
Write the Queries in Relational algebra for the following: iv) Retrieve Names of employees working on "CSE" project.
This question has 0 answers so far.


Give the complete syntax of SELECT statement in SQL and discuss all the clauses with examples.
This question has 0 answers so far.


What are Aggregate functions in SQL? Explain with examples.
This question has 0 answers so far.


Consider the following Relational schema: Lives (Name, Street, City)
Works (Name, Cname, Salary)
Located (Cname, City)
Manager (Name, MGR_Name)
Write the Queries in SQL for the following:
i) Find the people who earn more than every employee of "Canara Bank".
This question has 0 answers so far.


Consider the following Relational schema: Lives (Name, Street, City)
Works (Name, Cname, Salary)
Located (Cname, City)
Manager (Name, MGR_Name)
Write the Queries in SQL for the following:
ii) Find the Name and city of all the people who work for "SBI" and earn more than 35000 rupees.
This question has 0 answers so far.


Consider the following Relational schema: Lives (Name, Street, City)
Works (Name, Cname, Salary)
Located (Cname, City)
Manager (Name, MGR_Name)
Write the Queries in SQL for the following:
iii) Find the company employing the most people.
This question has 0 answers so far.


Consider the following Relational schema: Lives (Name, Street, City)
Works (Name, Cname, Salary)
Located (Cname, City)
Manager (Name, MGR_Name)
Write the Queries in SQL for the following:
iv) Show 20% raise in salary of all managers.
This question has 0 answers so far.


Consider the following Relational schema: Lives (Name, Street, City)
Works (Name, Cname, Salary)
Located (Cname, City)
Manager (Name, MGR_Name)
Write the Queries in SQL for the following:
v) Find the companies located in every city in which ICICI" is located.
This question has 0 answers so far.


Explain Insert, Delete and Update statements in SQL with examples.
This question has 0 answers so far.


What are views in SQL? Show how views are specified in SQL. List the advantages of views.
This question has 0 answers so far.


Differentiate : i) Trigger and Assertion
This question has 0 answers so far.


Differentiate : ii) Embedded and Dynamic SQL
This question has 0 answers so far.


Differentiate : iii) Outer join and Self Join
This question has 0 answers so far.


Differentiate : iv) Super key and Candidate key
This question has 0 answers so far.


What are the informal guidelines for relation schemas? Explan.
This question has 0 answers so far.


Define INF, 2NF and 3NF with examples.
This question has 0 answers so far.


What is BCNF? How it is different from 3NF? Prove that a relation with two attributes is always in BCNF
This question has 0 answers so far.


What do you mean by MVD? When does it arise? Define 4NF.
This question has 0 answers so far.


Define Join Dependency and 5NF.
This question has 0 answers so far.


Let R = {SSN, Ename, Pnumber, Prame. Plocn, Hrs) and D = {R_{1}, R_{2}. R_{3}, where
R_{1} = Emp = {SSN, Ename)
R_{2} = Proj= {Pnumber, Pnamie, Ploch)
R_{3} = Work_ON = (SSN, Pnumber, Hrs)
The following functional dependencies hold on relation R.
F = (SSN Ename;
Pnumber {Pname, Plocn);
(SSN, Pnumber) Hrs).
Prove that above decomposition of relation 'R' has the lossless join property.
This question has 0 answers so far.


What are the problems with concurrency? Explain each with an example.
This question has 0 answers so far.


With a neat state transition diagram, discuss the different states of a transaction.
This question has 0 answers so far.


Wine and explain the Twophase locking protocol for concurrency control.
This question has 0 answers so far.


Define the following (Give example where necessary): (a) Multivalued dependency
This question has 0 answers so far.


Define the following (Give example where necessary): (b) Dependency preservation
This question has 0 answers so far.


Define the following (Give example where necessary): c) Functional dependency
This question has 0 answers so far.


Define the following (Give example where necessary): (d) Referential integrity
This question has 0 answers so far.


Define the following (Give example where necessary): (e) Internal schema
This question has 0 answers so far.


Define the following (Give example where necessary): (f) Candidate key
This question has 0 answers so far.


Define the following (Give example where necessary): (g) Triggers
This question has 0 answers so far.


Define the following (Give example where necessary): (h) DBA
This question has 0 answers so far.


Define the following (Give example where necessary): (i) Weak entity
This question has 0 answers so far.


Define the following (Give example where necessary): (j) Foreign key
This question has 0 answers so far.


(a) Differentiate between the term Generalization and Specialization with example.
This question has 0 answers so far.


(b) Differentiate between Fragmentation. Replication and Transparency.
This question has 0 answers so far.


(a) Define closure of FD set. For the following relation R (A, B, C, D)
With FDs as follows: (i) Find the closure of (B, D) and (CA).
This question has 0 answers so far.


(b) What is canonical cover? How it is computed?
This question has 0 answers so far.


(a) Explain the "ACID" properties in brief.
This question has 0 answers so far.


(b) What do you mean by serializability. Discuss the conflict serializability and view serializability with examples.
This question has 0 answers so far.


(a) Draw and explain a neat diagram of three level architecture of database system.
This question has 0 answers so far.


(b) Construct an ER diagram for 'Hospital management system. There would be a set of patients and set of doctors. For each patient, there would be a log of various tests and
examinations conducted. Make assumptions if necessary and clearly state them.
This question has 0 answers so far.


(a) How the B+ tree index files are maintained? Explain.
This question has 0 answers so far.


(b) Explain the method of "query processing" in brief.
This question has 0 answers so far.


(a) Discuss clearly inner join, outer join and theta join with example.
This question has 0 answers so far.


(b) For the relation R=(A, B, C) and S=(D, E, F) and relation (R) and s(s), give SQL statement for following expressions and explain. (i) (ii) (iii) (iv)
This question has 0 answers so far.


Attempt the following (a) How the deadlock is detected in transactions? Explain its recovery process also.
This question has 0 answers so far.


Attempt the following (b) Normalize the following relation to as much as possible citing the reasons and anamoloies. R (empno, name, street, city, company name, companycity, managername, age, salary, maritalstatus, spousename)
This question has 0 answers so far.


Attempt the following (c) State the mulitversion time stamp based protocol. Suggests a scheme to avoid the phantom phenomenon.
This question has 0 answers so far.


a) Discuss the main characteristics of the database approach and how it litters from file systems.
This question has 0 answers so far.


b) Design an ER schema for keeping track of information about votes taken in the U.S. House of Representatives during the current twoyear congressional session. The database seeds to
keep track of each U.S. STATE's Name (e.B, Texas, New York, California) and includes the
Region of the state (whose domain is (Northeast, Midwest, Southeast, Southwest, West)
Each CONGRESSPERSON in the House of Representatives is described by their Name, and
includes the District represented, the StartDate when they were first elected, and the political
Party they belong to (whose domain is (Republicar, Democrat, Independent, Other). The
database keep track of each BILL (ie, proposed law), and includes the BillName, the
DateOf Vote on the bill, whether the bill PassedOtFailed (whose domain is YES, NO}), and
the Sponsor (the congressperson(s) who sponsoredi.e., proposed the bill). The database
keeps track of how each congressperson voted on each bill (domain of vote attribute is (Yes.
No, Abstain, Absent)). Draw an ER schema diagrams for the above application State clearly
• any assumptions you make.
This question has 0 answers so far.


a) What are the responsibilities of the DBA and the database designers?
This question has 0 answers so far.


b) Consider the following set of requirements for a university database that is used to Keep track of students transcripts.
• The university keep track of cach student's name, student number, social security
number, current address and phone, permanent address and phone, birthdate, sex, class
(freshuman, sophomore, ... graduate), major department, minor department (if any).
and degree program (B.A., B.S.,..,Ph.D.). Some user applications need to refer to
the city, state, and zip code of the student's permanent address and to the student's last name. Both social security number and student number have unique values for each student • Each department is described by & name, department code, office number, office
phone, and college. Both name and code have unique values for each department
•Each course has & course name, description, course number, number of semester
hours, level, and offering department. The value of course number is unique for each
course
•Each section has an instructor, semester, year, course, and section number. The section
number distinguishes sections of the same course that are taught during the same
semester/year, its values are 1, 2, 3,..up to the number of sections taught during
each semester. •A grade report has a student, section, letter grade, and numeric grade (0, 1, 2, 3, or 4).
Design an ER scheme for this application, and draw an ER diagram for that schema
Specify key attributes of each entity type and structural constraints on each relationship
type. Note any unspecified requirements, and make appropriate assumptions to make the
specification complete.
This question has 0 answers so far.


a) How can the key and foreign key constraints be enforced by the DBMS is the enforcement technique you suggest difficult to implement? Can the constraint checks be executed efficiently when updates are applied
to the database?
This question has 0 answers so far.


b) What is a view in SQL and how is a defed? Discuss the problems that may arise when one attemps to update a view. How a view typically implemented?
This question has 0 answers so far.


c) How does SOL allow implementation of the entity integrity and referential in egrley constraints? What about general integrity constraints?
This question has 0 answers so far.


b) Explain Multivalued dependencies with the help of examples.
This question has 0 answers so far.


a) What is join dependencies? Explain with the help of example.
This question has 0 answers so far.


b) What are the types of anomalies? How these anomalies can remove explain with the help of example.
This question has 0 answers so far.


b) Explain Bindex files with the help of examples
This question has 0 answers so far.


a) Since every conflictserializable schedule is view serializable, why do we emphasize conflict serializability rather than view serializability?
This question has 0 answers so far.


b) Show that the twophase looking protocol ensures conflict serializability, and that transactions can be serialized according to their lock points
This question has 0 answers so far.


a) List the physical storage media available on the computers you use routinely. Give the speed
with which data can be accessed on each medium
This question has 0 answers so far.


Consider the following two transactions: Add lock and unlock Instructions to transactions The and 132. so that they observe the twophase locking protocol. Can the execution of these transactions result in a deadlock?
This question has 0 answers so far.


a) What is a view? How it is related to data independence?
This question has 0 answers so far.


b) What is a Relation Schema and a Relation?
This question has 0 answers so far.


c) What is Functional Dependency?
This question has 0 answers so far.


d) Define Join and enlist its types
This question has 0 answers so far.


c) What is database Trigger?
This question has 0 answers so far.


f) Compare Nonclustered and clustered index
This question has 0 answers so far.


g) Define correlated subqueries".
This question has 0 answers so far.


h) What is Fully Functional dependency?
This question has 0 answers so far.


i) What do you mean by Correlated subquery?
This question has 0 answers so far.


j) What is cursors give different types of cursors?
This question has 0 answers so far.


Consider the following six relations for an order pressing database application in a company CUSTOMER(Cust, Crame, City)
ORDER(Ordert, Odate, Cust, Ord Amt)
ORDER_ITEM(Ordery, Item, Quy)
ITEM(Item# Unit_price)
SHIPMENT(Ordert, Warehouse, Ship_date)
WAREHOUSE(Warehouse, City)
Here, Ord. Amt refers to total dollar amount of an order; Odate is the date the order was placed
Ship date is the date an order is shipped from the warehouse. As me that an order can be
shipped from several warehouses. Specify the foreign keys for the above schema, stating any
Assumptions you make. Then specify the following queries in relational algebra
# List the Order and Ship date for all orders shipped from Warehouse number 'W2" a) What is cursors give different types of cursors?
This question has 0 answers so far.


Consider the following six relations for an order pressing database application in a company CUSTOMER(Cust, Crame, City)
ORDER(Ordert, Odate, Cust, Ord Amt)
ORDER_ITEM(Ordery, Item, Quy)
ITEM(Item# Unit_price)
SHIPMENT(Ordert, Warehouse, Ship_date)
WAREHOUSE(Warehouse, City)
Here, Ord. Amt refers to total dollar amount of an order; Odate is the date the order was placed
Ship date is the date an order is shipped from the warehouse. As me that an order can be
shipped from several warehouses. Specify the foreign keys for the above schema, stating any
Assumptions you make. Then specify the following queries in relational algebra
# List the Order and Ship date for all orders shipped from Warehouse number 'W2" b) List the Warehouse information from which the Customer named 'Jose Lopez' was supplied his orders. Produce a listing Order Warehouse.
This question has 0 answers so far.


Consider the following six relations for an order pressing database application in a company CUSTOMER(Cust, Crame, City)
ORDER(Ordert, Odate, Cust, Ord Amt)
ORDER_ITEM(Ordery, Item, Quy)
ITEM(Item# Unit_price)
SHIPMENT(Ordert, Warehouse, Ship_date)
WAREHOUSE(Warehouse, City)
Here, Ord. Amt refers to total dollar amount of an order; Odate is the date the order was placed
Ship date is the date an order is shipped from the warehouse. As me that an order can be
shipped from several warehouses. Specify the foreign keys for the above schema, stating any
Assumptions you make. Then specify the following queries in relational algebra
# List the Order and Ship date for all orders shipped from Warehouse number 'W2" c) Produce a listing: CUSTNAME, #OFORDERS, AVG ORDER AMT, where the middlecolumn is the total number of orders by the customer and the last column is the average order amount for that customer.
This question has 0 answers so far.


Consider the following six relations for an order pressing database application in a company CUSTOMER(Cust, Crame, City)
ORDER(Ordert, Odate, Cust, Ord Amt)
ORDER_ITEM(Ordery, Item, Quy)
ITEM(Item# Unit_price)
SHIPMENT(Ordert, Warehouse, Ship_date)
WAREHOUSE(Warehouse, City)
Here, Ord. Amt refers to total dollar amount of an order; Odate is the date the order was placed
Ship date is the date an order is shipped from the warehouse. As me that an order can be
shipped from several warehouses. Specify the foreign keys for the above schema, stating any
Assumptions you make. Then specify the following queries in relational algebra
# List the Order and Ship date for all orders shipped from Warehouse number 'W2" c) List the orders that were not shipped within 30 days of ordering.
This question has 0 answers so far.


Consider the following six relations for an order pressing database application in a company CUSTOMER(Cust, Crame, City)
ORDER(Ordert, Odate, Cust, Ord Amt)
ORDER_ITEM(Ordery, Item, Quy)
ITEM(Item# Unit_price)
SHIPMENT(Ordert, Warehouse, Ship_date)
WAREHOUSE(Warehouse, City)
Here, Ord. Amt refers to total dollar amount of an order; Odate is the date the order was placed
Ship date is the date an order is shipped from the warehouse. As me that an order can be
shipped from several warehouses. Specify the foreign keys for the above schema, stating any
Assumptions you make. Then specify the following queries in relational algebra
# List the Order and Ship date for all orders shipped from Warehouse number 'W2" c) List the Order# for orders that were shipped from all warehouses that the company has in New York.
This question has 0 answers so far.


a) Suppose you are given a relation (table) R=(A,B,C,D,E) with the functional dependencies:
1. Find all candidata keys
This question has 0 answers so far.


a) Suppose you are given a relation (table) R=(A,B,C,D,E) with the functional dependencies: 2.Identify the highest normal form that satisfies
This question has 0 answers so far.


a) Suppose you are given a relation (table) R=(A,B,C,D,E) with the functional dependencies: 3 If is not in Boyce Codd Normal Form (CNF), then decompose the relation into additional relations until all relations are in BCNF.
This question has 0 answers so far.


a) Explain the CODD's rules of RDBMS.
This question has 0 answers so far.


b) Discuss the timestamp ordering techniques for concurrency control.
This question has 0 answers so far.


a) Discuss the different types of transaction failures that may occur in database environment,
This question has 0 answers so far.


b) What is checkpoint? Explain the different recovery techniques when database crashes.
This question has 0 answers so far.


Answer the following: Draw and explain the architecture of DBMS. Compare it with file system.
This question has 0 answers so far.


Answer the following: b) Explain the role of ER model in database design.
This question has 0 answers so far.


Answer the following: c) How can the two tables be joined using left outer and right outer joins?
This question has 0 answers so far.


Answer the following: d) What problems are encountered if data is not stored in normalized table?
This question has 0 answers so far.


Answer the following: e) List the problems associated with two phase locking protocol.
This question has 0 answers so far.


Consider the following relational schema: Emp (cmpno, ename, job, sal, comm., hiredate, deptno)
Dept (deptno, dname, location)
Give an expression in SQL for the following Queries:
a) Find the names of employees who work in deptno 10 and 20.
This question has 0 answers so far.


Consider the following relational schema: Emp (cmpno, ename, job, sal, comm., hiredate, deptno)
Dept (deptno, dname, location)
Give an expression in SQL for the following Queries:
b) Increase the salary by Rs 1500 for the employees who are "CLERK.
This question has 0 answers so far.


Consider the following relational schema: Emp (cmpno, ename, job, sal, comm., hiredate, deptno)
Dept (deptno, dname, location)
Give an expression in SQL for the following Queries:
c) Display the details of employees who work in same deptno as of the employee 'SMITH'.
This question has 0 answers so far.


Consider the following relational schema: Emp (cmpno, ename, job, sal, comm., hiredate, deptno)
Dept (deptno, dname, location)
Give an expression in SQL for the following Queries:
e) Display total salary of employees of each deptno and display those deptno whose total salary is more than Rs. 30000.
This question has 0 answers so far.


Differentiate between: a) Primary key and Foreign Key
This question has 0 answers so far.


Differentiate between: b) View and Indexes
This question has 0 answers so far.


Differentiate between: c) Serializable and non serializable transactions
This question has 0 answers so far.


Differentiate between: d) 2NF and 3CNF
This question has 0 answers so far.


Differentiate between: e) Data and Metadata
This question has 0 answers so far.


a) Construct an ER diagram for a hospital management system with a set of doctors and a set of patients. With each patient, a series of various tests
and examinations are conducted. On the basis of preliminary report
patients are admitted to a particular specialty ward.
This question has 0 answers so far.


a) Explain the differences among extenal, internal and conceptual schemas.
This question has 0 answers so far.


Related with database, explain the term: i) Data integrity
This question has 0 answers so far.


Related with database, explain the term: ii) Concurrency
This question has 0 answers so far.


Related with database, explain the term: iii) Data independence
This question has 0 answers so far.


Related with database, explain the term: iv) Referential integrity
This question has 0 answers so far.
