Scribd
Upload
4 views4 pages

Python Programming Lesson 14 Summary Notes

This document outlines the objectives of a lesson on relational databases, including definitions and characteristics of relational databases, SQL programming, and the use of SQLite. It explains how relational databases organize data into tables and how SQL is used to manipulate this data. Additionally, it provides a Python code example for creating a database and an employees table using SQLite.

Uploaded by

kopanomakgeru
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views4 pages

Python Programming Lesson 14 Summary Notes

This document outlines the objectives of a lesson on relational databases, including definitions and characteristics of relational databases, SQL programming, and the use of SQLite. It explains how relational databases organize data into tables and how SQL is used to manipulate this data. Additionally, it provides a Python code example for creating a database and an employees table using SQLite.

Uploaded by

kopanomakgeru
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

2

3 Lesson objectives

3 Relational databases

3 Relational database characteristics

3 SQL database programming

3 SQLite

4 Lesson source code

PYTHON PROGRAMMING
3

By the end of this lesson, you should be able to:

 Define relational databases


 Understand the SQL programming language
 Learn how to create a database using Python and SQLite

A relational database is a type of database that organises data into one or more tables (or "relations") of columns
and rows, with a unique identifier for certain rows. The columns represent attributes of the data, and the rows
represent individual records. Relationships between different tables are established using common columns (keys)
to link the data. This allows for data to be queried and manipulated in a structured and efficient way.

Relational databases consist of tables with a collection of data that is organised in a specific structure, with rows
and columns. Each row represents a single record, and each column represents a field of the record. Tables are
used to store and organise data. They can be used to store data of various types, such as text, numbers, and dates,
and can be queried, updated, and manipulated using SQL (Structured Query Language). Data is usually constrained
with the use of primary and foreign key which serve as unique identifiers.

Structured Query Language (SQL) is a special-purpose programming language for accessing and manipulating
data stored in a relational database. It is used for inserting, updating, querying and deleting data in a database. It
can also be used for creating and modifying the structure of the database such as creating, altering, and dropping
tables, views, and indexes. SQL statements are used to communicate with the database and are the standard
language for relational database management systems.

SQLite is a software library that provides a relational database management system (RDBMS) and is embedded
into a software application. It is a self-contained, serverless, and zero-configuration database engine that is simple
to use and requires minimal setup. It is a popular choice for small to medium-sized applications that need a
lightweight and portable database solution. It is widely used in desktop and mobile applications, as well as
embedded systems and web browsers.

PYTHON PROGRAMMING
4

import sqlite3

#CREATE DATABASE AND CONNECT

conn = [Link](employee_database.db')
print ("Database has been opened");

#CREATE EMPLOYEES TABLE

[Link]('''CREATE TABLE employees


(EMP_ID INT PRIMARY KEY NOT NULL,
NAME TEXT NOT NULL,
DEPARTMENT_NAME CHAR(40)NOT NULL,
REGION CHAR(50),
SALARY REAL);''')

print ("Table created successfully");

#CLOSE DATABASE AFTER CREATE OPERATION HAS BEEN EXECUTED

[Link]()

PYTHON PROGRAMMING

You might also like