Posts

Showing posts with the label Database

Database: Concepts and Advantages

Image
(Rawpixel, 2021) According to Oracle, a database is a well-organized assortment of structured information or data, which is often stored digitally in a computer system. To manage the data, a database management system (DBMS) is usually employed. The combination of the data, the DBMS, and the associated applications is referred to as a database system or simply a database. ( Oracle, no date) It ensures that the user can perform the following tasks: Create Read Update; and Delete Most databases today are designed using tables with rows and columns to enable efficient processing and data querying. The data can be easily accessed, manipulated, updated, controlled, and arranged using a DBMS. Structured Query Language (SQL) is the most widely used language for writing and querying data in databases. ( Oracle, no date)   Examples of Databases Below are some examples of Databases Microsoft SQL Server "SQL Server, developed by Microsoft, is a Relational Database Management System. It is bu...

Customer/Product Database Creation

Image
Storyset (2019) As a prerequisite for this module, I had to create a customer database. In the creation of this data base I had to create fields for "Customer ID/Number", "Customer Name", "Last name", "Phone number" and "Post code". I will be highlighting the processes I took in creating the customer database. The first step I took was to create the field headings, as listed in the introduction paragraph above. After crating these headings, I filled them with randomized values for the names, phone numbers, and postal codes. The table was beginning to look substantial. Finally, I formatted the data as a table. MS-Excel automatically created a bold border around the table, with the headings on it, as dropdowns. I added thinner lines between each column to make the values more distinguishable. Having done this, I saved my progress and stored it as my customer database file. Product Database Similar to the customer database, I also created ...