CIT$4163$ MANAGEMENT INFORMATION SYSTEMS

Tutorial $5$ Foundations of Business Intelligence: Databases and Information Management

$1.$ You are working as an IT manager in Multimedia College. The CEO of your college wants you to create a database to manage records of their students.

a$)$ What is primary key? Provide ONE example of primary key for a student record.

b$)$ List THREE attributes in a student record.

$2.$ The book publishing company you work for wants to create a new database for storing information about all of their books.

a$)$ Given the above scenario, provide TWO examples of entity. State ONE example of attribute for each of the entity.

b$)$ You are given the task to design the database to store the book information. Explain the type of diagram that will help you to document the data model.

$3.$ You are working as an information system specialist in a private hospital. The management in the hospital wants to implement a Database Management System $($DBMS$)$ to replace the traditional file environment.

a$)$ List FOUR weaknesses of the traditional file environment.

b$)$ Describe the THREE basic operations that are used to develop useful sets of data in a relational DBMS$.$

c$)$ You suggest that the DBMS should allow doctors and medical staffs to access the internal database by using the Web. What are the THREE advantages of using the Web for database access?

$4.$ You are working as an information system specialist in a private hospital. Your job is to manage the Database Management System $($DBMS$)$ of the hospital.

a$)$ Given the above scenario, provide TWO examples of entity. State ONE primary key for each entity.

b$)$ Distinguish between a data warehouse and a data mart. Explain why they are important to the hospital.

$5.$ You own a dental clinic. Explain the most suitable type of database that you would use to keep records of your patients.

$6.$ You are the IT coordinator in Centre for Diploma Programme. You want to create a database to store information about probation students and their remaining subjects. List:

a$)$ TWO possible tables

b$)$ TWO attributes for each table

c$)$ the primary key for each table