Lesson 13- 16

By lancejulianreyes28 | Updated: June 22, 2024, 7:49 a.m.

Slideshow Video

SHARE THE AWESOMENESS

Education

create your own animated videos for free

_abc cc

* Powtoon is not liable for any 3rd party content used. It is the responsibility of each user to comply with 3rd party copyright laws.

Embed code

Select a size, the embed code changes based on your selection.

_abc Powtoon Transcript

DATABASE METADATA (DATABASE SCHEMA)
• The database schema represents a logical view of the entire database. It defines how the data is organized and how the tables within the database are related to one another.
DATABASE METADATA (DATABASE SCHEMA)
• You represent the “one” side of a one-to-many relationship by drawing a 1 beside the parent key, and you represent the “many” side of a one-to-many relationship by drawing an infinity symbol (∞) beside the foreign key.
DATABASE QUERIES
Queries work by checking table fields for entries that meet the criteria that you specify. Criteria can be strings of text, dates, or a number or range of numbers that you enter.
DATABASE QUERIES
The result set or dynaset (dynamic subset) is not a static snapshot of records, but a dynamic changing subset of records.
DATABASE FORMS
Forms are tools that aid data entry and are user-friendly interfaces designed to help users enter specific data without becoming distracted or confused by other data that may be stored in a table.
WHERE ARE DATABASES USED?
• Databases are used almost everywhere you look – medical records, flight reservations, legal pleadings, online orders, Pinterest, Twitter, Facebook and WordPress posts – are all stored in databases.
• The Web is replete with databases because databases are extremely flexible and scalable – they can store millions and millions of records, and they can present data in almost any format you want or need.
There are two basic types of web pages:
⮚ Dynamic – these pages change every time they are loaded in the browser window. They change their content based on user actions.
⮚ Add Static – these types of pages display content that does not change (unless the web page developer edits what is on the page).
• Banking web sites use database driven pages. You log in and view your account, and the web page connects to a database where all your account information is stored.

Lesson 13- 16

Copy this link to share with friends and colleagues:

WELCOME TO POWTOON!