Management Information System · Unit 6
Data Management and Database Technologies
Exam-focused notes for Data Management and Database Technologies (Management Information System, BIT353): what the TU syllabus asks and how it has actually been tested, with 5 solved past questions from this unit.
What this unit covers
- Problems with traditional file environment
- Relational databases
- Nonrelational databases
- Cloud databases and benefits
- Data accuracy, consistency, and reliability
- Blockchain technology and distributed ledgers
Problems with traditional file environment
What are the problems with traditional file environment? [5]
The traditional file environment refers to systems where data is stored in separate, independent files managed by individual applications. The major problems are: - Same data is stored in multiple files across different applications - Leads to data duplicat...
Full solved answer →Blockchain technology and distributed ledgers
Explain blockchain technology. How does blockchain works? [5]
Blockchain is a distributed ledger technology that maintains a continuously growing list of records called "blocks." Each block contains a cryptographic hash of the previous block, creating an immutable chain of data. It operates on a decentralized network ...
Full solved answer →Explain blockchain technology. How does blockchain work? [5]
Blockchain is a distributed ledger technology that maintains a continuously growing list of records called "blocks." Each block contains a cryptographic hash of the previous block, a timestamp, and transaction data. This creates an immutable chain of blocks...
Full solved answer →Relational databases
Compare relational and nonrelational databases. How do cloud databases and blockchain technology contribute to modern data management? [5]
- Structure: Data organized in tables (relations) with rows and columns - Schema: Fixed, predefined schema; all records follow the same structure - Query Language: SQL (Structured Query Language) - ACID Properties: Strong consistency, atomicity, isolation, ...
Full solved answer →Cloud databases and benefits
What is cloud database? What are the benefits of using cloud database to store data? [5]
A cloud database is a database service that is hosted on cloud computing platforms and accessed over the internet. It is a database management system (DBMS) deployed on cloud infrastructure where data is stored, managed, and retrieved from remote servers ma...
Full solved answer →Make Unit 6 stick
Practice BIT353 with flashcards & quizzes