- What is a Database - A database is an organized collection of structured information, data, typically stored electronically in the computer system. Controlled by a database management system (DBMS). Operation in databases is modeled in rows and columns in a series of tables to make processing and data querying efficient.
Oracle.com, 2022. What is a database?. [online] Oracle.com. Available at: <https://www.oracle.com/uk/database/what-is-database/> [Accessed 22 February 2022].
- the advantages of using a database are :
- Better Data Transferrring.
- Better Data Security.
- Better data integration
- Minimized Data Inconsistency.
- Faster data access.
-Better Decision making.
- Increased end-user producitivity.
geeksforgeeks.org, 2022. Advantages of Database Management System - GeeksforGeeks. [online] GeeksforGeeks. Available at: <https://www.geeksforgeeks.org/advantages-of-database-management-system/> [Accessed 22 February 2022].
- give examples of databases:
Some examples of popular database software or DBMSs include MySQL, Microsoft Access, Microsoft SQL Server, FileMaker Pro, Oracle Database, dBase.
Oracle.com, 2022. What is a database?. [online] Oracle.com. Available at: <https://www.oracle.com/database/what-is-database/#:~:text=Some%20examples%20of%20popular%20database,%2C%20Oracle%20Database%2C%20and%20dBASE.> [Accessed 8 April 2022].
- what is primary key:
A primary key is a special relational database table column ( or combination of columns) identify each table record. Key is used as a unique identifier to quickly parse data within the table. A tab than one primary key.
Main features are:
- Must contain a unique value for each row of data.
- It cannot contain null values.
- Every row must have a primary key value.
Techopedia.com, 2022. What is a Primary Key? - Definition from Techopedia. [online] Techopedia.com. Available at: <https://www.techopedia.com/definition/5547/primary-key> [Accessed 8 April 2022].
- what is secondary key:
A primary key is the field in database that is the primary key used to uniquely identify a record in database. Secondary key is an additional key or alternate key, which can be use in addition to the primary key to locate specific data.
The following is not supported for secondary keys:
- Provisioning of busy hours with secondary keys.
- Complex summaries.
Reports with KPIs (Key Performance Identicator) based on traffic tables contaning secondary keys and traffic tables not containing secondary keys. For a report with KPIs based on traffic tables having a secondary key tables, KPIs must be associated with the same KPI group.
Ibm.com, 2022. IBM Docs. [online] Ibm.com. Available at: <https://www.ibm.com/docs/en/tnpm/1.4.4?topic=administration-secondary-keys> [Accessed 8 April 2022].
Comments
Post a Comment