Answer the following questions:
1. Define database.
2. Define Database Management System.
3. Define RDBMS.
4. Define 2NF.
5. What is an entity?
6. State two advantages of RDBMS.
7. Write down two disadvantages of File based system.
8. What is data modeling?
9. Define Second Normal Form (2NF).
10. What is metadata?
11. Define the terms
Metadata and Schema.
12. Write two
disadvantages of file system over DBMS.
13. Differentiate between
Database and DBMS.
14. What is data
redundancy and inconsistency?
15. Define Functional
Dependency.
16. What is partial Dependency?
17. What is primary key?
18. What is the use of
primary key?
19. What is composite key?
Give one example.
20. Define Natural join.
21. Define primary key.
22. What is a view?
23. What is a database?
24. What is Relational
Algebra?
25. What is Cartesian
product?
26. Define the term ‘Data
Dictionary’.
27. Write two advantages
of SQL.
28. Write the SQL command
to delete all the rows in a table.
29. Write down the syntax
for update and select command in SQL.
30. Give two examples of
DDL command.
31. State two benefits of
SQL.
32. Define the following term:
(i) Database (ii) DBMS (iii) Relation
(iv) Tuple (v) Domain (vi) Degree
(vii) Cardinality
33. Explain the
three-schema (3-schema) Architecture of database.
34. Explain the components
of an ER diagram.
35. What is natural join?
Give example.
36. Explain Primary,
Foreign and Composite key.
37. Differentiate full
functional dependency from Partial Dependency.
38. Explain select and
project operation of Relational Algebra.
39. Describe the three-tier
architecture of DBMS.
40. What are the benefits
of having Foreign keys?
41. Define 1st
Normal Form and 2nd Normal Form with example.
42. What are the
components of E-R diagram? Explain with example.
43. Write down five
advantages of RDBMS over File based system.
44. Explain the use of
foreign keys with examples.
45. Describe the first
three Normal Forms.
46. Define JOIN operation.
What is EQUIJOIN and NATURAL JOIN.
47. Give examples of two
aggregate functions.
48. What is RDBMS? Explain
the concept of DOMAIN and TUPPLE with examples.
49. Explain the Aggregate
function of SQL with example.
50. Explain the use of any
five data types used in MySQL. Give example.
51. Explain the use of
Natural Join with example.
52. Explain the set
operators of relational algebra with example.
53. Explain the select and
project operations in Relational Algebra.
54. Explain the elements
of an ER diagram with examples.
55. Explain the concept of 1NF and 2NF.
56. Explain the differences between full functional dependency and partial dependency.
57. Describe all the set Theoretic
operations of Relational Algebra.
58. Explain the
advantages of VIEW.
59. Explain the concept of
Relational DBMS.
60. Define Normalization. Explain the concept of the following:
a. Unnormalized data
b. 1NF
c. 2NF
61. Briefly describe about
different RDBMS terminologies.
62. Define First, Second
and third Normal Form.
63. Explain the advantages
of RDBMS.
64. Explain four different
data types used in MySQl.
65. Differentiate 1NF from
2NF.
66. Briefly write about
different components of an ER diagram.
67. Explain the procedure
of creating views from two different relations.
68. Explain different data types used in MySQL.
69. Explain some constraints of MySQL.
70. Draw an ER diagram for Hospital Management System with your own assumption of relevant entities.
71. Draw an E-R diagram of company database with entity types employees, department, project, works-on with appropriate relationship.
72. Draw an ER diagram for Hospital Management System.
73. Draw an ER diagram for a Hospital with following entities: DOCTOR, PATIENT & TEST.
74. Draw an ER diagram for
Hospital Management System with Entities Doctor, Patient and Test.
75. Draw an E.R. diagram for a company with following tables:
Employee (emp_id, f_name, m_name, l_name, salary, dno, phone_no)Department (dep_id, d_name, hod)
Project (proj_id, proj_name).
76. Draw an E.R diagram
for a hospital with entities Doctor, Patient and Test.
77. Prepare an ER diagram
for a Bookstall management system.
78. Explain DDl, DML and
DCL with examples.
79. Write SQL for creating
a table having Primary key, Unique, NOT NULL, Default and Foreign key.
80. Define DDL, DML and DCL with examples.
81. Create a table using SQL where table name is Employee and the field names are emp-id, f-name, m-name, l-name, dob, salary, doj, phone. Write SQL for-
(i) Retrieve all the employee name having salary less than 10000.
(ii) Retrieve all the employee name whose dob is befor 10-02-1990.
82. Discuss DDL, DML and DCL
with examples.
83. Explain the use of
VIEW statement in SQL. Give example.
84. Write SQL to create a table (department) with attributes (dep_id, dep_name, hod, est_date). Write S.Q.L to find out the dep_id of “MATH” department.
0 Comments
if you have any doubts plz let me know...