DBAS27198 Study Guide - Midterm Guide: Data Redundancy, Sql, Unstructured Data

• School: Sheridan College
• Department: Database Design and Administration
• Course: DBAS27198
• Professor: Burgess

Document Summary

This document provides an outline of the things to know for the midterm test. The test is primarily about relational databases and the structured query language (sql: define each of the following terms, data. Data is stored representations of meaningful objects and events. Structured data is numbers, texts, and videos but unstructured data are images, videos, and documents: information. Information is data processed to increase knowledge in the person using the data: metadata. Metadata is data about data, and it describes the properties and context of user data: database. A database is an organized collection of logically related data: relation. A relation is a relationship between entities, can be one to many, or many to one: database management system. A dbms is a software system that is used to create, maintain, and provide controlled access to user databases. A dbms manages data resources like an operating system manages hardware resources: relational database management system.