AKSUM INSTITUTE OF TECHNOLOGY (AiT)
Faculty of Computing Technology
Department of Information Technology
Course Name: Advanced Database Systems
Course Code: ITec2072
Target Group: IT 2nd Year
Assignment Deadline for submission: Megabit 30/2017 E.C
N.B: Submission after deadline is not acceptable.
1. Define distributed databases?
I. Replication and consistency
II. Distributed query processing
III. Applications of distributed databases
2. NoSQL databases?
I. NoSQL data model
II. Design schema in NoSQL
III. Describe key-value, document store, time-Series Databases:
3. Big data and databases?
I. Discuss the challenges of managing and processing big data in traditional relational
databases. How do technologies like Hadoop and Spark address these challenges?
II. Describe the Hadoop echo-system in big data concept
4. What is OLAP (Online Analytical Processing)?
I. Applications of OLAP systems
II. Multi-dimensional data model
5. What is OLTP (Online Transaction Processing)
I. Key features of OLTP
II. Applications of OLTP
6. Describe the Database Management Challenges in E-Commerce
I. What are the database models for e-commerce
II. Database tools and technologies in e-commerce
7. Define characteristics of data warehousing?
I. Components of data warehouse?
II. Types of data warehouse?
III. Challenges of data warehouse?