assignment 1 on database management system, Assignments of Database Management Systems (DBMS)

Download assignment 1 on database management system and more Assignments Database Management Systems (DBMS) in PDF only on Docsity!

DATABASE MANAGEMENT SYSTEM

CSI37M

ASSIGNMENT

BY

MKILE H. (219414424)

HLATSHWAYO B (219422648)

A) I) No, it is not wise. The university will have two campuses and various entities to track. Flat files are simple text files where data is stored in a tabular format, and each line represents a record. Flat files have several limitations. For example, they do not support complex data types such as arrays or nested structures. They also do not support transactions, which means that if a failure occurs during a write operation, the data may become inconsistent. In addition, flat files do not provide any security features such as access control or encryption. B) A better approach would be to use a database management system (DBMS). A database management system (DBMS) is a software tool that enables users to manage a database easily. It allows users to access and interact with the underlying data in the database. These actions can range from simply querying data to defining database schemas that fundamentally affect the database structure. DBMSs are designed to store and manage large amounts of data efficiently and securely. They support complex data types and provide features such as transactions, indexing, and backup and recovery. They also provide security features such as access control and encryption. Based on these classifications, Dr Zolisa Mujoli should adopt a DBMS for his university’s data management system. RDBMSs are widely used and have proven to be reliable and efficient for storing and managing large amounts of data. They also provide a flexible and powerful query language that can help Dr Mujoli retrieve data from the database in a way that meets his needs.

entity, which would have attributes like "learner_id," "course_number," and "grade."

4. Lecturers can teach multiple course offerings, and each course offering has one or more instructors. This forms a many-to- many relationship between "Lecturers" and "Course Offerings."
5. It's assumed that each entity (Courses, Course Offerings, Learners, Lecturers) has a primary key, which is not explicitly shown in the diagram. Primary keys uniquely identify each record in the database table.
6. The "Program" attribute in the "Learners" entity represents the academic program that the learner is enrolled in (e.g., Computer Science, Engineering, etc.).