Initial Idea 1: Database Design and Implementation

 DATABASE DESIGN AND IMPLEMENTATION

First of all, 

What is DATA?

Data are facts or pieces of information about the object under review. For instance, the person's name, age, height, weight, ethnicity, hair color, and birthdate, are examples of personal data. Data encompasses more than just written facts; it also includes photographs, images, and files. (CFI, 2022)

(Twinkl, 2022)

There are a few terms for understanding the connection between data and databases.

-Fields

Fields store the most specific details of information about the data.

-Record

Record is the storage of connected data.

-Table

Table is the storage of connected Records.

-Database

A collection of Tables, but...

What is a Database?

A database is a collection of logically connected data that is arranged in a way that makes it easy to access, manage, and change. Databases are typically accessed electronically through a computer system and managed by a database management system (DBMS). (CFI, 2022)

(CFI, 2022)

What is Database Design?

Database design refers to a set of procedures that make it easier to plan, create, implement, and maintain enterprise data management systems. A well-designed database is simple to manage, increases data consistency, and saves money on disc storage space. The database designer determines how data items relate to one another and what information must be saved. (Peterson, 2022)

The primary goals of database structure in DBMS are to create logical and physical models of the database system under consideration. (Peterson, 2022)

For instance, the Database development lifecycle below does show the orders of creating a structure;

(marigranula, 2022)

Reference(s); 

CFI, 2022. Database. [online] Corporate Finance Institute. Available at: <https://corporatefinanceinstitute.com/resources/knowledge/data-analysis/database/> [Accessed 7 May 2022].

marigranula, 2022. Database development lifecycle. [online] 123RF. Available at: <https://www.123rf.com/photo_24067614_database-development-lifecycle.html> [Accessed 7 May 2022].

Peterson, 2022. Database Design in DBMS Tutorial: Learn Data Modeling. [online] Guru99. Available at: <https://www.guru99.com/database-design.html#:~:text=Database%20Design%20is%20a%20collection,terms%20of%20disk%20storage%20space.> [Accessed 7 May 2022].

Twinkl, 2022. [online] Twinkl.co.uk. Available at: <https://www.twinkl.co.uk/teaching-wiki/data> [Accessed 7 May 2022].