How much of your computer 's power consumption ? you can know…….
Power consumption Desktop computers Relatively much lower than the laptop Most of the laptops need 15-45 watts of electricity consumption What is my computer’s power consumption How can I count?
Link at the bottom of your Power Supply to calculate. The type and size of your monitor According to the calculation of Walt then Add it up.
17-19 " CRT - 56-100 W
17-19 " LCD - 19-40 W
0 - 4 " LCD - 1772 W
Let's you 've got a 185 w In Power Supply and 60 W at the monitor.
Now we get to add twice 120 60 = 180 watts. Now we divide 180 watts by 1000. And result will come up 0.18 Kilowatts.
The cost of the month = Watts x time x per kilowatt- hour rate X number of days in the month.
Necessary Definition of Database
- Database
Management System : Interrelated data and a sets of
program by which we can access and manipulate those data is called Data
Management System.
- Data: Data
is sequence of digit. data is those elements which will be information
after processed.
such as i) Numeric
ii) Textual
iii) Graphical
- Information
: information is processed data.
- Data
structure : Organized Collection of data and a set of operation
on them is called data structure.
- File
: If we think a unit of interrelated information or records is
called file.
- Database
: All structured data of a organization store in a computer
system is called database.
I) Hierarchical
DBMS
II) Network
DBMS
III) Relational
DBMS
IV) Inverted
DBMS
- Database
Integrity: if data are interconnected with each other in the database
is called data integrity.
- Database
redundancy : If homologues data are stayed in defferent place in
the database is called database redundancy.
- Data
Model : Data Model is a collection of same conceptual tools which
describe data, data relationship, data semantics, and data constraints.
data Model is main base of data structured.
I) Object
based logical model
II) record
base Logical Model.
III) Physical
Model
- Relational
Data Model: the Data Model which use some table to express
relation among data of record base logical model
- Data
Schema : Overall design of database is called database schema
- Data
Dictionary: After Compilation of data definition language we get a set
of table. Those are stored in a file. This file is called data dictionary.
- Data
Entity : Data Entity is some objects which has existence ad we
can distinguish them form each other.
- Entity
set : a Group of similar object which has similar properties.
- Primary
key : An unique identifier which identify the entity
differently is called primary key.
- Formal
Query Language : Formal Query Language is a language by which we
can get procedural or non procedural benefit.
- Commercial
Query Language: Commercial Query Language is a language by
which we can get procedural and non procedural benifit.
- Most
Popular Query Language are:
I) SQL
( Structured Query Language)
II) QBE
( Query By Example)
III) Quel
( ( Query Language)
IV) Datalog.
- Several
Parts of SQL
I) DDL
(Data definition Language)
II) DML
( Data Manipulation Language)
III) Embeded
DML
IV) View
Definition
V) Authorization
VI) Integrity
VII) Transaction
Control
- There
are three clause of SQL
I) select
II) from
III) where
- Aggregate
function of SQL
I) average
: avg
II) minimum
: min
III) Maximum:
Max
IV) Total
: SUM
V) Count
: Count
- Parallel
Database system
- Distributed
Database System
Subscribe to:
Posts (Atom)