Digital Infrastructure T-Level

  Data Normalisation     Data normalisation is the term to describe the orga nising of data from raw input. Data is organised into tables going through forms of normalisation.   1 st form deletes duplicate records in the data. For example, data with the same primary keys.   2 nd form makes sure there is only one single primary key in each table of data.   3 rd form gets rid of any indirect relationships between data.   These forms of data normalisation create well organised data that can be managed and queried to by a DBMS. DBMS are also used to structure the data in the forms as well.  

  import sqlite3 con = sqlite3 . connect ( "./e-commerce/e-commerce.db" ) cur = con . cursor () print ( "Welcome to E-commerce DB!" ) print ( "Select action:" ) print () print ( "Add data to customers (1)" ) print ( "Add data to orders (2)" ) print ( "Add data to shipping (3)" ) print ( "Delete data from customers (4)" ) print ( "Delete data from orders (5)" ) print ( "Delete data from shipping (6)" ) print ( "Get data from customers (7)" ) print ( "Get data from orders (8)" ) print ( "Get data from shipping (9)" ) print ( "Get data from products (10)" ) print () selectionPrompt = input ( "Selection: " ) if selectionPrompt == "1" :       customerName = input ( "Input your name: " )     customerAge = int ( input ( "Input your age: " ))     customerAddress = input ( "Input your home address: " )...

  RDBMS (Relational Database Management Systems)   An RDBMS is a program used to manage a relational database. In most cases, it does this through structured query language (SQL) statements. The RDBMS ‘talks’ to the d atabase and gives it instructions such as to insert data, select data from a certain column or delete data. They can also create new tables and even other new databases.   Some examples of RDBMS are:   MySQL – Used by YouTube , X, Netflix   PostgreSQL – Used by Instagram, Spotify, Reddit   Oracle DB – Used by Ebay, Intel, Zoom   Microsoft SQL Server – Used by Stack Overflow, Accenture, doubleS lash   SQLite – Used by Levelset , GRAIL, Sciplay   Application developers choose which RDBMS to use based on their specific requirements.   All RDBMS use either SQL or another form of it to manage databases and maintain their data accuracy.  

  Impacts of Digitalisation     Virtualisation/Cloud Services   Virtualisation enables scalability in a business. Server virtualisation allows one physical server to operate multiple virtual machines. This allows a business to cut costs and become m ore efficient. They can also use network virtualisation to run devices on a virtual network. This allows the business to skip buying expensive networking equipment. Desktop virtualisation also enables organisations to provide software for the specific needs of the employees.   The cloud is useful as it encourages easy data processing and storage. Employees do not have to store data on their own devices which reduces risks of security breaches. Also, cloud solutions are faster to implement than physical solutions. The cloud allows for improved collaboration between employees and reduces the risk of data loss .  

Measuring Digitalisation Value     Many areas of a business will benefit from digitalisation . Here are some examples:   Sales and marketing   This department will be able to promote products online where it can be reached by a wider or more appropriate audience . Marketing can also complete more enhanced market research onlin e. This will benefit a busine ss as they can generate more sales from advertising and market to a wider audience, growing their business.   Operations   Digitalisation allows for automation within the operations department . It can also lead to an increase in data quality and relevance as well as the collection and structure of the data. Communication channels are also enhanced as employees can talk to each other through messaging and email . This will benefit the business as they can increase the productivity of their operations department.   Finance   Automation of c ore financial processes will save the...