CS8492 Important 16 Mark Questions Database Management Systems
CS8492 Important 16 Mark Questions Database Management Systems Regulation 2017 Anna University free download. Database Management Systems Important 16 Mark Questions CS8492 pdf free download.
Sample CS8492 Important 16 Mark Questions Database Management Systems:
1.Briefly explain about Database system architecture:
2.Explain about the Purpose of Database system.
3. Briefly explain about Views of data. CS8492 Important 16 Mark Questions Database Management Systems
4. Explain E-R Model in detail with suitable example.
5. Explain about various data models.
6. Draw an E – R Diagram for Banking, University, Company, Airlines, ATM, Hospital, Library, Super market, Insurance Company. CS8492 Important 16 Mark Questions Database Management Systems
7. Explain 1NF, 2Nf and BCNF with suitable example.
8. Consider the universal relation R={ A,B,C,D,E,F,G,H,I} and the set of functional
dependencies F={(A,B)->{C],{A}>{D,E},{B}->{F},{F}->{G,H},{D}->[I,J}.what is the key for Decompose R into 2NF,the 3NF relations.
9. What are the pitfalls in relational database design? With a suitable example, explain the role of functional dependency in the process of normalization.
10. What is normalization? Explain all Normal forms. CS8492 Important 16 Mark Questions Database Management Systems
11. Write about decomposition preservation algorithm for all FD s.
12.Explain functional dependency concepts
13.Explain 2NF and 3NF in detail CS8492 Important 16 Mark Questions Database Management Systems
14.Define BCNF .How does it differ from 3NF.
15.Explain the codd s rules for relational database design
1.How the records are represented and organized in files . Explain with suitable example
2.Write about the various levels of RAID with neat diagrams
3. Construct a B+ tree with the following (order of 3)
5,3,4,9,7,15,14,21,22,23 CS8492 Important 16 Mark Questions Database Management Systems
4. Explain detail in distributed databases and client/server databases.
5.Explain in detail about Dataware housing and data mining
6.Explain in detail about mobile and web databases
| Subject name | Database Management Systems |
| Short Name | DMS |
| Semester | 4 |
| Subject Code | CS8492 |
| Regulation | 2017 regulation |
CS8492 Database Management Systems Important 16 Mark Questions Click Here To Download
CS8492 Database Management Systems Important 2 Mark Questions
CS8492 Database Management Systems Syllabus
CS8492 Database Management Systems Notes
CS8492 Database Management Systems Question Bank