problem 1) How are relationships between tables expressed in relational database?
b) prepare down 10 potential benefits of the database approach over conventional file system.
problem 2a) prepare 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, prepare the ex 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.
problem 3) Assume you are designing database of students result management system for BS (CS). Develop sample tables and apply normalization on it and also describe that to which level of normalization is applied.
problem 4) describe in detail layers of database administration with the help of suitable exs.
problem 5) Describe database administration functions and responsibilities in detail with the help of suitable exs.
problem 6) What is the database integrity? describe the significant integrity rules.
problem 7) Describe database security in detail with the help of exs.
problem 8) describe significant reasons of database failure. Also describe database recovery methods.
problem 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.
problem 10) State distributed databases with the help of appropriate exs. Also prepare down the advantages and disadvantages of distributed databases.