3.1- Data Management & Retrieval using data analytics techniques

data analytics and Management

1. Department of Computer Science III BSc (CS) ODD Semester: 2024 -2025
1
CORE 8: RDBMS & ORACLE Unit –3 Data Management & Retrieval
Data Management and Retrieval
Course: RDBMS Sub Code: 53A
Google Classroom: efxznbm Programme: BSc CS
Unit: III Hour : 1
Googlesite
:https://sites.google.com/skacas.ac.in/rdbmsst/semester-v/st-rdbms

2. Department of Computer Science III BSc (CS) ODD Semester: 2024 -2025
2
CORE 8: RDBMS & ORACLE Unit –3 Data Management & Retrieval
VISION & MISSION

3. Department of Computer Science III BSc (CS) ODD Semester: 2024 -2025
3
CORE 8: RDBMS & ORACLE Unit –3 Data Management & Retrieval
Toprovideexcellentinfrastructure
and educational prospects
throughinnovation,creativity,and
integrity,fosteringholisticstudent
excellenceinacademicandcareer
pursuits.
VISION

4. Department of Computer Science III BSc (CS) ODD Semester: 2024 -2025
4
CORE 8: RDBMS & ORACLE Unit –3 Data Management & Retrieval
Empowering thenationby
impartingstudentswithabroad
spectrumofknowledge,attitudes,
skills,andpractices,while
integratingthelatesttrendsin
advancingtechnologies.
MISSION

5. Department of Computer Science III BSc (CS) ODD Semester: 2024 -2025
5
CORE 8: RDBMS & ORACLE Unit –3 Data Management & Retrieval
COURSE OUTCOME
UnderstandthebasicconceptsofRelationalData
Model,Entity RelationshipModelandprocessof
Normalization.
UnderstandandconstructdatabaseusingStructured
QueryLanguage(SQL)inOracle9ienvironment

6. Department of Computer Science III BSc (CS) ODD Semester: 2024 -2025
6
CORE 8: RDBMS & ORACLE Unit –3 Data Management & Retrieval
Unit III -SYLLABUS
WorkingwithTable:DataManagementandRetrieval:DML
–addinganewRow/Record–CustomizedPrompts–
UpdatingandDeletinganExistingRows/Records–
retrievingDatafromTable–ArithmeticOperations–
restrictingDatawithWHEREclause–Sorting–Revisiting
SubstitutionVariables–DEFINEcommand–CASE
structure.FunctionsandGrouping:Built-infunctions–
GroupingData.MultipleTables:JoinsandSetoperations:
Join–Setoperations.

7. Department of Computer Science III BSc (CS) ODD Semester: 2024 -2025
7
CORE 8: RDBMS & ORACLE Unit –3 Data Management & Retrieval

8. Department of Computer Science III BSc (CS) ODD Semester: 2024 -2025
8
CORE 8: RDBMS & ORACLE Unit –3 Data Management & Retrieval
SNAP TALK

9. Department of Computer Science III BSc (CS) ODD Semester: 2024 -2025
9
CORE 8: RDBMS & ORACLE Unit –3 Data Management & Retrieval
LECTURE AGENDA
DML
Adding a new Row / Record
Inset command
Null values
Substitution variables
examples

10. Department of Computer Science III BSc (CS) ODD Semester: 2024 -2025
10
CORE 8: RDBMS & ORACLE Unit –3 Data Management & Retrieval
DML
Row
Insert
Nullvalues
substitution
Commit
Rollback
Default
keywords

11. Department of Computer Science III BSc (CS) ODD Semester: 2024 -2025
11
CORE 8: RDBMS & ORACLE Unit –3 Data Management & Retrieval
Agenda
Working with Tables: Data Management and Retrieval
DataManipulationLanguage(DML)
AddingaNewRow/Record
Syntax
RoundingbyInsert
EnteringNullValues
ImplicitMethod
ExplicitMethod
EnteringDefaultValues
SubstitutionValues

12. Department of Computer Science III BSc (CS) ODD Semester: 2024 -2025
12
CORE 8: RDBMS & ORACLE Unit –3 Data Management & Retrieval
DML
SQL’sDataManipulationLanguage(DML)consistsof
threestatements–SELECT,INSERT,UPDATEand
DELETE
DataRetrievalLanguageorSubsetofDMLconsistsof
SELECT.
AnewrowaddedwiththeINSERTcommand.
AnexistingrowarechangeswiththeUPDATE
command.
ToremovearowfromtablewiththeDELETEcommand.
TheSELECTretrievesdatafromtables.
DMLstatementsarenotwrittenpermanentlytothe
databaseunlesstheyarecommitted.

13. Department of Computer Science III BSc (CS) ODD Semester: 2024 -2025
13
CORE 8: RDBMS & ORACLE Unit –3 Data Management & Retrieval
Adding a new Row/Record
•Thedatamanipulationlanguage(DML)statement
insertisusedtoinsertanewrow/recordintoatable.
Ausercaninsertvaluesforallcolumnsoraselected
listofcolumnsinarecord.
Syntax:
INSERT INTO
schema.table_name[(column1,column2,…)]
VALUES(value1,value2,…);
Eg:-INSERT INTO student(studentid, name, street,
DOB, mobile) VALUES(‘0101’, ‘ Kumar’,
‘Terminals’, ‘12-FEB-90’, ‘9785789798’);

14. Department of Computer Science III BSc (CS) ODD Semester: 2024 -2025
14
CORE 8: RDBMS & ORACLE Unit –3 Data Management & Retrieval
Adding a new Row/Record
•RoundingbyINSERT
Ifweinsertvalue543.876inaNUMBER(6,2)column
,theprecisionis4,andthescaleis2.Theresultingvalueswillbe
543.88,roundedtotwodecimalplaces,orascaleof2.Therounded
valuewillbeenteredintothecolumn
•EnteringNULLValues
•Nullvaluesareallowedinnon-primarykeycolumnsthatdonot
haveaNOTNULLConstraint.
•ImplicitMethod
–INSERTINTOdept(Deptid,DeptName)VALUES(50,‘
Production)
•ExplicitMethod
–INSERTINTOdept(Deptid,DeptName,Location,EmpID)
VALUES(60,’Personnel’,‘Chicago’,NULL);

15. Department of Computer Science III BSc (CS) ODD Semester: 2024 -2025
15
CORE 8: RDBMS & ORACLE Unit –3 Data Management & Retrieval
Adding a new Row/Record
SubstitutionVariables
SQLlanguagehavesubstitutionvariables,which
enableyoutocreateaninteractiveSQLscript.
Theampersand(&)characterisusedbeforethe
substitutionvariablesinthequery.
ThesubstitutionvariablesforCHARandDATE
columnsareenclosedwithinapairofsinglequotation
marks.
–Eg:INSERTINTOdept(depid,deptname,location,
empid)VALUES(&depid,‘&deptname’,‘&location’,
&empid);
Ifuserwantstoaddmanyrows,thenslash(/)hasto
typetoreexecutethestatementfrombuffer.

16. Department of Computer Science III BSc (CS) ODD Semester: 2024 -2025
16
CORE 8: RDBMS & ORACLE Unit –3 Data Management & Retrieval
Points To Remember
•SQL’s Data Manipulation Language(DML)
consists of three statements –INSERT,
UPDATE and DELETE.
•Data Retrieval Language or Subset of DML
consists of SELECT.
•A User can enter a COMMIT statement
anytime to write DML statements to the disk.
•To undo the last set of DML statements by use
of ROLLBACK statement.

17. Department of Computer Science III BSc (CS) ODD Semester: 2024 -2025
17
CORE 8: RDBMS & ORACLE Unit –3 Data Management & Retrieval
Multiple Choice Questions
1. SQL’s Data Manipulation
Language(DML) consists of
____statements.
a.4
b.3
c.2
d.1

18. Department of Computer Science III BSc (CS) ODD Semester: 2024 -2025
18
CORE 8: RDBMS & ORACLE Unit –3 Data Management & Retrieval
Multiple Choice Questions
2. The ______character is used before the
substitution variables in the query.
a.$
b.*
c.&
d.#

19. Department of Computer Science III BSc (CS) ODD Semester: 2024 -2025
19
CORE 8: RDBMS & ORACLE Unit –3 Data Management & Retrieval
Multiple Choice Questions
3. A User can enter a ______statement
anytime to write DML statements to the
disk.
a.Rollback
b.Commit
c.Savepoint
d.none

20. Department of Computer Science III BSc (CS) ODD Semester: 2024 -2025
20
CORE 8: RDBMS & ORACLE Unit –3 Data Management & Retrieval
Multiple Choice Questions
4. To undo the last set of DML statements
by use of ______statement.
a.Rollback
b.Commit
c.Savepoint
d.none

21. Department of Computer Science III BSc (CS) ODD Semester: 2024 -2025
21
CORE 8: RDBMS & ORACLE Unit –3 Data Management & Retrieval
Multiple Choice Questions
5. ____values are allowed in non-primary key
columns that do not have a NOT NULL
Constraint.
a.Notnull
b.Null
c.Zero
d.None

22. Department of Computer Science III BSc (CS) ODD Semester: 2024 -2025
22
CORE 8: RDBMS & ORACLE Unit –3 Data Management & Retrieval
Multiple Choice Questions
Answer
1. 4
2. &
3. Commit
4. Rollback
5. Null

23. Department of Computer Science III BSc (CS) ODD Semester: 2024 -2025
23
CORE 8: RDBMS & ORACLE Unit –3 Data Management & Retrieval
Next Session
Customized Prompts