1- What is a database- Give some examples- 2- What is a database manag.docx

1. What is a database? Give some examples.
2. What is a database management system? Give some examples
3. How a database is structured? What is a primary key?
4. An application runs on specific operating system that stores and retrieves data on a database yo produce information. Explain with a diagram.
5. Explain the basic database applications in CRUD.
Solution
1) Database : Its basically collection of information or say data which we want to store so that we can access or update it as and when required. Like storing data about employee in an organisation
2) Database Management System : The system which handles database. It provides user/programmers a systematic way of storing , accessing, retrieving and managing data. Eg : Oracle
3) Database is structured in form of tables which stores relevanty data like employee table wich can have colums to store employee name, address, contact details , salary etc.
Primary key : its the attribute to uniquely identify a row and for eg in Employee table uniquely identify a employee.
5) CRUD : basically the four major operations in database to handle the data
C: Create , the operation to create table/store data in table
R : Retrieve - the operation to access the stored data
U : Update : the operation to update the already stored data
D : Delete : the operation to delete the stored data
.

1. 1. What is a database? Give some examples.
2. What is a database management system? Give some examples
3. How a database is structured? What is a primary key?
4. An application runs on specific operating system that stores and retrieves data on a database
yo produce information. Explain with a diagram.
5. Explain the basic database applications in CRUD.
Solution
1) Database : Its basically collection of information or say data which we want to store so that we
can access or update it as and when required. Like storing data about employee in an
organisation
2) Database Management System : The system which handles database. It provides
user/programmers a systematic way of storing , accessing, retrieving and managing data. Eg :
Oracle
3) Database is structured in form of tables which stores relevanty data like employee table wich
can have colums to store employee name, address, contact details , salary etc.
Primary key : its the attribute to uniquely identify a row and for eg in Employee table uniquely
identify a employee.
5) CRUD : basically the four major operations in database to handle the data
C: Create , the operation to create table/store data in table
R : Retrieve - the operation to access the stored data
U : Update : the operation to update the already stored data
D : Delete : the operation to delete the stored data