Scribd
Upload
5 views2 pages

Understanding Relational Databases and SQL

Relational databases store data in tables, such as product and sales tables, with records linked by identifiers like prod_ID. Data normalization is a process that refines the database structure to minimize redundancy while organizing data objects and their relationships. SQL commands allow users to query and manipulate data, such as fetching specific columns or filtering records based on conditions.

Uploaded by

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

Understanding Relational Databases and SQL

Relational databases store data in tables, such as product and sales tables, with records linked by identifiers like prod_ID. Data normalization is a process that refines the database structure to minimize redundancy while organizing data objects and their relationships. SQL commands allow users to query and manipulate data, such as fetching specific columns or filtering records based on conditions.

Uploaded by

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

Relational databases:

Data is primarily stored in the form of tables. Say for e.g. there is a product table. The data is
contained as fields, prod_ID, Product _name, color…and there will be a sales table. A new record is
created for each sale. Each sales wil have the prod_ID

Data Normalization:

[Link]

While data normalization rules tend to increase the duplication of data, it does
not introduce data redundancy, which is unnecessary
duplication. Database normalization is typically a refinement process after the
initial exercise of identifying the data objects that should be in the relational
database, identifying their relationships and defining the tables required and the
columns within each table.

[Link]

SQL Codes:

Select * <from Table name> = This will essentially fetch all the columns in the table

Select <column name 1> <Column name 2> from <Table name> = This will essentially fetch only
the selected columns

We can simply drag and drop or type (Intellisense will help)


select
*
from
[dbo].[Customer]
where
TotalChildren >= 4 or
[YearlyIncome] <= 60000 or
[HouseOwnerFlag] = '1'

Take home – 4850


Hsg = 800 – Munich – 1200
250- soaps
100 – pkt
Travel – 64
40

You might also like