Question 1) How are relationships between tables expressed in relational database?
b) Write down 10 potential benefits of the database approach over conventional file system.
Question 2a) Write a comparison between the enterprise data model, conceptual data model and a physical data model.
b) Is it possible that during physical database design and creation step of database development you might want to return to logical database design activity? Why or why not? If it is possible, write the example of what might arise during physical database design and creation which would cause you to want to reconsider the conceptual and external database designs from prior steps.
Question 3) Assume you are designing database of students result management system for BS (CS). Develop sample tables and apply normalization on it and also explain that to which level of normalization is applied.
Question 4) Explain in detail layers of database administration with the help of suitable examples.
Question 5) Describe database administration functions and responsibilities in detail with the help of suitable examples.
Question 6) What is the database integrity? Explain the significant integrity rules.
Question 7) Describe database security in detail with the help of examples.
Question 8) Explain significant reasons of database failure. Also explain database recovery methods.
Question 9) Assume you are a database administrator of an organization how can you deal with concurrency control issues of that organization? Sate your answer in the context of sample case study.
Question 10) State distributed databases with the help of appropriate examples. Also write down the advantages and disadvantages of distributed databases.