• views: 82
• date: 7 December 2024
• posted by: AD-TEAM

VNSGU BCA Sem 1: Data Processing and Analysis - DPA

What you'll learn

Fundamentals of Workbook and Spreadsheet

Concepts of workbook, adding worksheet rename sheet

Insert, delete, column, rows, cells

Format Cells, cell address, formula bar

Format Page Insert Header & Footer

Split, Hide and freeze panes in worksheet.

Creating 2D and 3D charts ( Columns, Line, Pie, Bar, Scatter)

Functions Power, Sqrt, Abs, Floor, Celling, Int, Trunc, Round, sum, average, count, max, min, sumif, pmt, stddev, if, AND, OR, NOT,

Sort Data, Filter Data, Conditional Formatting, Cell validation,

Introduction of DBMS, Database characteristics

Data Independence ( Logical and Physical), Components of Database , Components of Database

Database Models ( Hierarchical, Network, E/R, Relational)

Schema and Instance, Entity, Relationship, Attribute, Types of Attribute

E/R Diagram, Aggregation,

Mapping Cardinalates: One to one, one to many , many to one, many to many Mapping

Total and Partial Participation, Weak entity set, Types of Relationship

Super key, candidate key, Primary key, Composite key, Unique key, Foreign key

Need of normalization ( Insertion, Updating, Deletion anomalies)

Functional Dependency, Armstrong Axioms, Closure of a set of FD

Prime and Non-prime Attribute

1st Normal Form, 2nd Normal Form, 3rd Normal Form

Concepts of Structure Query Language (SQL)

DDL Statements : Create , Drop, Truncate, Rename, Alter

DML Statements : Insert, Update, Delete

DQL(Data Query Language) Statements : select

Constraints ( Table level and Attribute Level), NOT NULL, CHECK, DEFAULT, UNIQUE, Primary Key, Foreign Key, On Delete Cascade

Using where clause and operators with where clause: In, between , like, not in, =, !=, >, =,

   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.