Database Systems is a required textbook for my class, Data Management – MSBA 630 at the University of Louisville’s Master in Business Analytics program.
DataBase Systems: Design, Implementation, & Management.
By Carlos Coronel and Steven Morris
13th Edition 2019
1Why Databases?
Because databases make data persistent and shareable in a secure way, they are the best way to store, manage, and retrieve data very quickly.
Data: Raw facts, or facts that have not yet been processed to reveal their meaning the the end user.
Information = The result of processing raw data to reveal its meaning and facilitate decision making.
knowledge = The body of info and facts about a specific subject.
metadata = Data about data; data about data characteristics and relationships.
ad hoc query= a ‘spur-of-the-moment” question.
Types of Databases:
Single-user, desktop, multi-user, workgroup, enterprise, centralized, distributed, cloud, general-purpose, discipline-specific, and operational database.
Basic File Terminology:
Field
Record
File