3: F.1. Databases Flashcards
(15 cards)
What are the types of databases?
- Relational database: it’s the most common type which means that the datais stored in tables
- Data Hierarchy: and this is 4 levels
1- filed
2- record
3- file
4- Database
What is the primary key?
its a uniqe number that is attached to every employee record to distegush from the other employees
What is the Foreign Key ?
its a key that used to like a specific information to another record or file
What is entry relationship Modeling?
It’s a Model to plan the relationship between and among databases, one-to-one, one-to-many, many-to-many; these relationships are known as database cardinalities,
it can be app or anything that help in doing the diagram and the relationships
What is the Database Management System?
It’s a software program that acts like a middleman between the user and the data, like MySQL, Oracle It’s a big place that hides all the data, so we can use it later
True/False
Is the DBMS the same as a Database?
False
The DBMS is not the same as a database; the DBMS contains the database, which contains the data, and the DBMS manages this data and controls it
What is the SQL language?
its a language that use to communicate with the Database
Which of the following are true about a Schema in database development?
A) It represents the full structure of the entire database
B) It is limited to only one user’s view of the data
C) It includes table names, fields, and relationships
D) It is used to define what data a specific user can access
E) It is created using Data Definition Language (DDL)
Correct Answers: A, C, E
Which of the following best describes a Subschema (View)?
A) It provides full access to all data in the database
B) It is also known as a “view”
C) It limits the user’s access to certain data only
D) It controls how the database is physically stored
E) It is useful for protecting sensitive information
Correct Answers: B, C, E
How does a Schema differ from a Subschema?
A) A schema is the overall design; a subschema is user-specific
B) A schema includes the entire database structure
C) A subschema is used to create tables and relationships
D) A subschema may allow only read-only access to certain users
E) A schema limits user access to protect data
Correct Answers: A, B, D
What is the Data Manipulation Language (DML)?
When someone plays with the data by inserting, developing, and deleting data and its part of the Data maintains
What is the Structured Query Language (SQL)?
It’s used by the Database administrator (DBA) to make a structure of tables, fields, and relationships
What are the types of Database Management System (DBMS)
1- Database development
2- Database Maintenance
3- Database interrogation
4- Database application
what is the language that used for creating tables, defining columns, creating database schema, deleting or modifaying tables?
Data difinition Language (DDL)
What is the language that used for, adding, deleting data, inserting new records, ubdating existing data.
Data manupulation Language (DML)
