DBMS
A Database Management System is called DBMS. DBMS is tool to store, edit and organise data in rows and column.
It's have some features:
1. Stores data in one central location.
2. Allows data to be shared by many users.
3. Provides user interfaces (UI) to work with the data
4. Controls who can access and edit the data.
Benefits using a DBMS:
1. Integrity
2. Efficience
3. Consistency
4. Backups
5. Security
6.Customisation
Examole of database:
1. Two individual database.
Example: Online sales.
Booking office sales.
2. Create a system where the costumer and product data could be held in one database.
Example: Could be an application for the booking office and the online sales which would allow both of them to access the database.
Different views of database:
There are three types of database
1. External
-Bird type
- Time of year
- date
- location
2. Conceptual
- Presented using SQL
3. Internal view
- Include hex or binary Reference to bytes
It's have some features:
1. Stores data in one central location.
2. Allows data to be shared by many users.
3. Provides user interfaces (UI) to work with the data
4. Controls who can access and edit the data.
Benefits using a DBMS:
1. Integrity
2. Efficience
3. Consistency
4. Backups
5. Security
6.Customisation
Examole of database:
1. Two individual database.
Example: Online sales.
Booking office sales.
2. Create a system where the costumer and product data could be held in one database.
Example: Could be an application for the booking office and the online sales which would allow both of them to access the database.
Different views of database:
There are three types of database
1. External
-Bird type
- Time of year
- date
- location
2. Conceptual
- Presented using SQL
3. Internal view
- Include hex or binary Reference to bytes
You have demonstrated you understanding of the theory of a database concept. Next you need to think about the type of a database that you will be using to manage the customers orders & product inventory on your E-Commerce website.
ReplyDeleteYou need to add the Customer Order Database & Customer Database to your Digital Notebook and show your understanding of those and how they can be investigated and formatted.
ReplyDelete