Database Design & Implementation - Course Details only

...

- Explain in detail how a Dimensional Model (DM) differs from an Entity– Relationship (ER) Model.[15 marks] JUNE 2009 p 1186

- You have been consulted by a team of developers building a data warehouse for a large international company with many specialised departments all over the country who would maintain some degree of autonomy. The team’s main objective is to provide access to vast quantities of data in a cost-effective manner for a large number of users.

(a) Explain a suitable implementation strategy that could be used to achieve this objective and identify any issues associated with the development of this strategy. [10 marks] DEC 2008

(b) Discuss the advantages that could be gained by implementing the proposed strategy and give examples to illustrate your answer. [12 marks] DEC 2008

(c) Contrast your proposed implementation strategy in (a) above to a similar technique that is used in building a Distributed Database to gain similar advantages. [8 marks] DEC 2008

- Data Warehousing emerged as a result of advances in the field of information systems over several decades. Most of these information systems are distributed over a number of sites, with each site possibly storing data differently, but organisation management still require a consolidated view of data for decision support purposes. Today, two major factors drive the need for data warehousing in most organisations. The first is the need for an integrated, company-wide view of quality information and the second is the need to separate operational systems from information systems.

In trying to meet the need for businesses to have an integrated, company-wide view of quality information, data warehouse designers have to resolve at least two aspects of data integration. Name the two aspects of integration and use an appropriate example to describe each of these two aspects of integration. [15 marks] June 2008

Topics Need to Cover

Ch-1

- Database page-15

- Database Management System p16

- Benefits of View p18

- Data & Database Administrator p22

- Logical/Physical Database Designer 22-23

- Advantage & Disadvantage of DBMS 26

CH-2

- 3 Level ANSI-SPARC, External, Conceptual, Internal 34-36

- Logical / physical Data independence 39

- Functions of DBMS 48

- Components of DBMS 53

CH-3

- Relation, attribute, domain, tuple, Degree, Cardinality-73

- Relational Key 78

- Entity integrity, referential, General constrains-82

- Purpose of View-84

Ch-4

- Theta, equi join, natural, outer, semi join p95

CH-6

- Discretionary & Mandatory Access Control 189

Ch-11

- Entity Occurrence, Relationship Occurrence, degree,

- Structural constrains 356-361

- Fan & Chasm traps p364

CH-13

- Functional Dependency 393

Ch-19

- Discretionary & Mandatory Access Control P547

- Countermeasures 545

- Backup & Recovery 550

- Encryption 551

- Proxy 563, Freewall,563, Digital Signature, Certificate, 564, SSL,565

Ch-20

- Properties of Transaction (ACID)-575

- 3 types of Concurrency control 578

- Schedule Serial, non serial schedule 580

- 2 types of locking 587-588

- Deadlock, prevention, detection, recovery from deadlock 594-595

- Database recovery 605, recovery facility 609

- Check pointing 611, Recovery technique 612

- Deferred update, immediate update, shadow paging 613-614

Ch-22

- Distribute processing 691,

- Advantage/ Disadvantage of DDBMS 693

- Homogeneous, Heterogeneous DDBNS-697

- Functions of DDBMS 703

- Types of Fragmentation 711

- Transparencies in DDBMS-719

Ch-25

- Weakness of RDBMS-809

- Object-Oriented concept-814

- Advantage of Using OID-817

- Comparison between Object-oriented data modeling and Conceptual data modeling -830

Ch-30

- What is semi structured data? Discuss the difference between semi structured and structured data. Give examples to illustrate your answer. 1066

- Discuss how XML can be transferred into a database. 1129

- Advantage of XML 1074

Ch-31

- Discuss how OLTP differ from Dataware house 1153

- Subject Oriented, Integrated……1151

- Benefits of Data warehouse..1152

- Problems of Data warehousing..1154

- Data WareHouse tools..1171

- How data mart differ from data warehouse1171

- Reason for creating a Data mart 1173

-