Online College Courses for Credit

+
Definition of Database

Definition of Database

Rating:
Rating
(0)
Author: Devmountain Tutorials
Description:

Recognize the purpose of a database.

(more)
See More
Fast, Free College Credit

Developing Effective Teams

Let's Ride
*No strings attached. This college course is 100% free and is worth 1 semester credit.

37 Sophia partners guarantee credit transfer.

299 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 32 of Sophia’s online courses. Many different colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial
what's covered
This section will explore the purpose of databases by discussing:
  1. DEFINITION OF DATABASE

DEFINITION OF DATABASE

A database is the rawest form that data can take in a web application, and it’s often referred to as the “source of truth”. Without a database, a web developer has no means of programming user sessions that refer back to one another, such as when a user logs in and performs a set of actions that they expect to be accessible next time they login. From saving basic user data such as usernames and emails to saving more complex data such as documents and product purchases, a database enables a wide variety of dynamic functionality.

Before a web developer can store and retrieve data from a database, the database needs to be designed and created. This task is yet another case where coding takes on a more creative, design-oriented quality. The design of a database is not only critical to any applications’ future functionality, but it also is difficult to modify once it’s been designed, so it has lasting consequences for potentially years to come.

Thankfully, the basic building materials for a database are relatively few.

You have tables, which are like buckets that contain sets of uniform items. Items in a table are called records—each record is can be likened to a row in a spreadsheet. Records have fields, which are attributes of the record—not unlike the column in a spreadsheet. Lastly, tables can have relationships to other tables.

So, in order to complete a basic database design, a web developer would need to specify which tables need to exist, and within each table, which fields will pertain to the records in each table. Lastly, the developer would need to decide, or determine, what the relationships between the tables should be.

terms to know

Database
Resource that saves basic user data such as usernames and emails, as well as saving more complex data such as documents and product purchases. A database enables a wide variety of dynamic functionality.
Table
Data collection objects that are like buckets that contain sets of uniform items, or records.
Record
An item in a table that can be likened to a row in a spreadsheet, including attributes of the record called fields.
Field
Attributes of the record—not unlike the column in a spreadsheet.
Relationships
Developers determine the connections between tables and how they relate to each other.


Terms to Know
Database

Resource that saves basic user data such as usernames and emails, as well as saving more complex data such as documents and product purchases. A database enables a wide variety of dynamic functionality.

Field

Attributes of the record—not unlike the column in a spreadsheet.

Record

An item in a table that can be likened to a row in a spreadsheet, including attributes of the record called fields.

Relationships

Developers determine the connections between tables and how they relate to each other.

Table

Data collection objects that are like buckets that contain sets of uniform items, or records.