Basics of Database Part 02

-

 Normalization


- Decompose larger, complex table into simpler and smaller ones.

- Moves from lower normal forms to higher normal forms.


Normal Forms


- First normal form (1NF)

- Second normal form (2NF)

- Third normal form (3NF)

- Higher normal form (BCNF, 4NF, 5NF)


Need of Normalisation


- In order to produce good database design.

- To ensure all database operations to be efficiently performed.

- Avoid any expensive DBMS Operations.

- Avoid unnecessary replication of information.


Functional Dependency Types


- Partial functional Dependency

- Transitive Dependency


First normal form (1NF)


- All attributes in the relation are atomic (indivisible value)

- There are no repeating elements or group of elements


Second normal form (2NF)


- A relation is said to be in 2NF  if and only if it is in 1st normal form

- No partial dependency exists between non key attributes and key attributes.


Third normal form (3NF) 


- It is in 2NF. no transitive dependency exists between non key attributes and key attributes through another non key attributes.


What is SQL?


Programming language specifically designed for working with database to

- Create

- Manipulate

- Share/ Access


Why SQL?


- Allows users to communicate i.e. access and manipulate the database

- Allows users to retrieve data from database

- Allow users to create, update, modify and delete the database.


SQL Terms


Data: Data is defined as facts or figures or information that's stored in or used by a computer.


Database: A database is a organised collection of data/ Information so that it can be easily accessed managed and updated.


SQL Data Types


Numeric: bit, tinyint, smallint, int, bigint, decimal, numeric, float, real.


Character/ String: char, varchar, text


Date/Time: Date, Time, Datetime, Timestamp, Year.


Miscellaneous: Json, XML


SQL Constraints


Not Null: Ensures that a column does not have null value.


Default: Provides a default value for a column when none is specified.


Unique: Ensures that all the values in a column are different.


Primary: Identifies each row/ record in a database table uniquely.


Check: Ensures that all values in a column satisfy certain conditions.


Index: Create and retrieves data from the database very quickly.


 #design #sql #data #share #database #programming #language #day2


Mail id: arpitmishra1629.ftp@gmail.com

Contact no: 8127430702

Linkedin: https://www.linkedin.com/in/arpit-mishra-9319b5131



Comments

Post a Comment

Popular posts from this blog

Self Discipline Benefits and Importance

-
Image
                                       Self Discipline Benefits and Importance Welcome to my blog and thank you for this much support. So let's start. Today's blog is based on " Self Discipline Benefits and Importance ". Self-discipline is one of the most important and useful skills everyone should possess. This skill is essential in every area of life, and though most people acknowledge its importance, very few do something to strengthen it. Contrary to common belief, self-discipline does not mean being harsh toward yourself or living a limited, restrictive lifestyle. Self-discipline means self-control, which is a sign of inner strength and control of yourself, your actions, and your reactions. Self-discipline gives you the power to stick to your decisions and follow them through, without changing your mind, and is, therefore, one of the important requirements for achieving goals. The possession of this skill enables you to persevere with your d
Read more

The curriculum of our current education system

-
Image
                                        The curriculum of our current education system Today's blog is based on " The curriculum of our current education system ". I wholeheartedly agree that the tight curriculum of our current education system leaves no room for imagination and creativity. The academic pressure is so much on them, they have forgotten their innate creativity and imagination. They are always under the pressure of studies. This pressure is put on them from the beginning of the session. Formative assessment activities of all the subjects, studies and their assignments of all the subjects, unit tests, co-curricular activities, homework, classwork, projects, practical exams, summative examination, date sheet, result, again the new term, etc. So much of pressure on the young growing children! Are we educating them or training them in the art of being stressful throughout their childhood? Even while studying inside the class, they feel so burdene
Read more

Blog 1.2

-
Image
                                                      Journey..... Welcome to my blog and thank you for this much of support. so let's start. I was in the first year when I joined NCC as a cadet. I was not aware of what is NCC? but I knew one thing that for NCC I have to wear a uniform. I was excited. After a few months, people started noticing that there is a cadet name Arpit Mishra he is very punctual and he can do anything. Major Neeti Prakash was NCC Officer. She worked in PSIT as a registrar. She called me one day and asked me, do you want to work with me in an event? I said yes ma'am why not. I managed my first event as a coorganizer and that event was TedX. She was very happy while seeing my hard work and dedication to my work. We organize many events together. After a few months I got my first NCC Rank and that was Under Officer. I can't forget that day. after a year I got my second and higher rank in NCC and that was Senior Under Officer. I trained many jun
Read more