IT inbternatiopnmal business that has ;lots pof differnet recosurces PDF

Preview

Summary

make sure thatyou complete the work up top the best starndatd...

Description

31/01/2022 Online & Local Databases - An online database is a database accessible from a local network or the Internet, as opposed to one that is stored locally on an individual computer or its attached storage (such as a CD). Online databases are hosted on websites, made available as software as a service products accessible via a web browser. Database Management System (DBMS) - A database management system (or DBMS) is essentially nothing more than a computerized datakeeping system. Users of the system are given facilities to perform several kinds of operations on such a system for either manipulation of the data in the database or the management of the database structure itself. SQL - SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system. Data Validation - data validation is the process of ensuring data has undergone data cleansing to ensure they have data quality, that is, that they are both correct and useful. Activity: 1. o o  o o

List two examples of an online database: MySQL Oracle Database List two examples of a local database: Access Paradox

Why might a company use a database management system (DBMS)? Keep track of customers, data inventory, and employees. Maintain application and database performance. Store and organize unique, varied types of data. Automate database processes and procedures.



4. What is the language used by a DBMS? Structured Query Language (SQL) is a database query language that includes both DDL and DML. DDL is more specific than SQL,

31/01/2022

5. What is the technical term for a search in a database? Subject terms, also called controlled vocabulary, are specific words that have been assigned by a database to describe each book or article within. ... It is possible to search for articles using subject terms from database thesauri, rather than using keywords.

  

6. List three examples of data validation: Range check Format Check Uniqueness Check...