DBMS basic terminology and concepts
Basic Concepts: Data is organized in a data storage hierarchy of increasingly complex levels: bits, bytes (characters), fields, records, files, and databases. A character is a letter, number, or special character. A field consists of one or more characters (bytes). A record is a collection of related fields. A file is a collection of related records. A database is, as mentioned, an organized collection of integrated files. Important to data organization is the key field, a field used to uniquely identify a record so that it can be easily retrieved and processed. Introduction to database Every one deals with data every day. When anyone wants to listen to his/her favorite songs, he opens his playlist from the smartphone. In this case, the playlist is a database. When you take a photo and upload it to your account in a social network like Facebook, your photo gallery is a database. Databases are everywhere. So what is a database? By definition, a databas