In: Computer Science
Part 1: Terminology
In your own words, define/describe what each of these terms means
in a database context. Do not attempt to copy specific sentences
from the video word for word. Examples to support definitions and
descriptions are welcome, but are insufficient on their own. You
should establish that you understand the significance of each
term.
1. Database Functionality:
a. Massive
b. Persistent
c. Safe
d. Multi-user
e. Convenient
f. Efficient
g. Reliable
2. database concepts:
a. data model
b. schema vs. data
3. purpose of languages associated with a database:
a. data definition language
b. data manipulation language
c. query language
4. database-related jobs:
a. DBMS implementer
b. designer
c. application developer
d. database administrator
Answer:
1) Database Functionality:
a) Massive -is a term that describes the large volume of data
b) Persistent- The opposite of dynamic—it doesn't change and is not accessed very frequently.Data that exist from one instance to another stored in actual format and stays there
c) Safe: - Ensure physical database security
d) Multi-User - database are accessible from multiple computers simultaneously
e) Convenient - means easy to process or access the database
f) Efficient- performing or functioning in the best possible manner with the least waste of time and effort
g) Reliable-the database performs consistently without causing problems
2) Database Concept:
a) Data model: Data models define how the logical structure of a database is modeled. Data Models are fundamental entities to introduce abstraction in a DBMS. Data models define how data is connected to each other and how they are processed and stored inside the system.
b) Schema vs Data : A database schema is the skeleton structure that represents the logical view of the entire database. It defines how the data is organized and how the relations among them are associated. It formulates all the constraints that are to be applied on the data.
3) Purpose of languages associated with database:
a) Data Definition Language:A data definition language (DDL) is a computer language used to create and modify the structure of database objects in a database. These database objects include views, schemas, tables, indexes, etc. DDL commands are used for altering the database structure such as creating new tables or objects along with all their attributes (data type, table name, etc.).
b) Data Manipulation Language:A data manipulation language (DML) is a family of computer languages including commands permitting users to manipulate data in a database. This manipulation involves inserting data into database tables, retrieving existing data, deleting data from existing tables and modifying existing data. DML is mostly incorporated in SQL databases.
c)Query Language: Query Language (QL) refers to any computer programming language that requests and retrieves data from database and information systems by sending queries. It works on user entered structured and formal programming command based queries to find and extract data from host databases.
4) Database related jobs
a) DBMS Implementer: A DBMS Implementer isnstall the DBMS.Tune the setup variables according to the hardware, software and usage conditions.Create the database and tables.Load the data.Set up the users and security and implement the backup regime.
b) Designer :The database designer isresponsible for defining the detailed database design, including tables, indexes, views, constraints, triggers, stored procedures, and other database -specific constructs needed to store, retrieve, and delete persistent objects
c) Application developer:An Application developer responsible for developing and modifying source code for software application .
d) Database administrator:The database administrator (DBA) is the person who manages, backs up and ensures the availability of the data produced and consumed by today's organizations via their IT systems