Notes

1- (DBMS) software used for: Creation of databases, Insertion, storage, retrieval, update, and deletion of the data in the
database, maintenance of databases
2- (Database metadata) – represents the structure of the database, database content that is not the data itself data about the data Contains: Names of data structures, Data types, Data descriptions
3- (Database State) - The database content at a particular moment in time
4- (Data Definition Language) - Used by the DBA and database designers to specify the conceptual schema of a database.
5- (Conceptual database Design) - creation of the database model that is implementable by the DBMS software Logical database modeling follows conceptual database modeling
6- (Database administration and maintenance) - performing activities that support the database end user, including dealing with technical issues, such as: Providing security for the information contained in the database
7- (Database analysts) - involved in the requirements collection, definition, and visualization stage.
8- (Database designers) - involved in the database modeling stage Responsible to define the content, the structure, the constraints, and functions or transactions against the database.
9- Entity relationship diagram (ERD) are output from the following database design phase.
10 - The values appearing in given attributes of any tuple in the referencing relation must likewise occur in specified attributes of at least one tuple in the referenced relation, according to ( Referential ) integrity constraint.





( True ) - Data visualization is the graphical representation of information and data.
( True ) - Database analysts involved in the requirements collection, definition, and visualization stage.
( True ) - Operational database collects and presents operational information in support of daily operational procedures and processes.
( True ) - Advantages of Database Management System are better data integration, Batter data security and Faster data access.
( True ) - DBMS is used to create a database, to insert the data in the database, to retrieve the data from the database and to change or delete the data in the database.

( False ) - Front-end application "analyst" in charge of creating the front-end applications . True = "Developer"
( False ) - "DML" Commands for setting up the schema of a database. True = "DDL"
( False ) - "Database" is data that describes the structure and the properties of the data. True = "Metadata"
( False ) - The "first and the most" critical step in the development of the database is database modeling. True = "first"
( False ) - "Database" are includes dealing with technical issues, such as: Providing security for the information contained in the database, Ensuring sufficient hard-drive space for the database content and Implementing the backup and recovery procedures. True = "Database administration and maintenance"