Question: What is database?
Database is a collection of information which are stored in organised way.
Question: What is DBMS?
Full for of DBMS is Database Management System.
It is Management System which manage the databases and its table.
Question: What are the advantages of using DBMS?
- Backup and Recovery
- It contains two-dimensional tables with rows and columns.
- Integrity constraints
- Redundancy can be reduced
- Give Access to User in controlled way.
Question: What are the disadvantage in File Processing System?
- Data redundancy and inconsistency.
- Data integrity.
- Security Problems
- Data isolation.
- Difficult in accessing data.
Question:What is Data Model?
A collection of conceptual tools for describing data, data relationships, data semantics & constraints.
Question: What is normalization?
Normalization is the process of organizing tables in such a way that the results are always unambiguous, accurate and fast.
Question: What is BCNF (Boyce-Codd Normal Form)?
A relation schema R is in BCNF if it is in 3NF and satisfies an additional constraint that for every FD X A, X must be a candidate key.
Question: What is RDBMS?
Relational Database Management system (RDBMS) is a database management system (DBMS) that is based on the relational model.
Question: What is SQL?
Structured Query Language is a language designed specifically for communicating with databases to get the required results.
Question: What is a Record in a database?
A record is the collection of values / fields of a specific entity: i.e. an Employee.
It have employee details like employee id,name, email and address etc.
Question: What is Object Oriented model?
This model is based on collection of objects.
Question: What is an Entity?
small independent things.
Question: What is an Entity type?
It is a collection (set) of entities that have same or different attributes.
Question: What is Weak Entity set?
An entity set may not have sufficient attributes to form a primary key.
Question: What is DDL?
Full form of DDL is Data Definition Language.
DDL is a standard for commands that define the different structures in a database.
DDL statements create, modify and remove database objects such as tables, indexes, and users.
Most Common DDL statements are CREATE, ALTER and DROP.
Question: What is Data mining?
Data mining is a process of analyzing current data and summarizing the information in more useful.