Database Tutorial

IS3331 Data Management

Tutorial 1 – The Database Environment

Please write down your answers in this document and submit it to BlackboardAssignmentWeek01 Tutorial Exercise by the end of this tutorial.

Activity 1. Grouping

Please form a group of 4-5 members. Take some time to introduce yourself to each other and complete the form below.

Please exchange contact information (email, phone number, etc.) with your teammates.

Group Name: ________________________________________

Student ID | Student Name |

| |

| |

| |

| |

| |

Activity 2. Match the following terms and definitions

| Data | a. Data placed in context or summarized |

| Repository | b. Facts, texts, numbers, graphics, images, etc. |

| Metadata | c. Organized collection of related data |

| Data warehouse | d. descriptions of data properties or characteristics |

| Information | e. centralized storehouse for all metadata |

| Database management system | f. separation of data description from programs |

| Data independence | g. a business management system that integrates all functions of the enterprise |

| Database | h. a software application that is used to create, maintain, and provide controlled access to user databases |

| Enterprise resource planning (ERP) | i. integrated database of historic data that aims to support decision making |

| Systems development life cycle | j. a structured, step-by-step approach to systems development |

Activity 3. Database is organized collection of related data. Data models capture the nature and the relationships among data. We are going to learn about data modeling in detail in next a few weeks. This exercise is for you to warm up to the concepts and fundamentals.

A typical data model is made up entities, attributes, and relationships. The most common data modeling method is entity-relationship (ER) model. The following figure represents a segment of a data model.

Entities An entity is like...