Describe Database
what is the meaning of Datatbase?
A structured set of data which is stored ,update , retrieving of data in a computer.SET
It is a collection of distinct or different objects.
For instance even number or odd number set consists of some elements.So Even number set has {2,4,6,8,10 }.
So odd number set has {1,3,5,7}
Even number set has 5 different objects when considered separately.
odd number set has 4 different objects when considered separately.But when considered collectively it is formed as a single set.
In Mathematics SET is a collection of objects.
In Database Set is relation.The relation is also known as table.In table we have entities or attributes in the header of a table.In the body of a table we have set of n number of tuples or records.
Records
It is a collection of ordered set of attribute values in the relation or table of a row.attributes
- it is real world entity or object.for example Student has attributes.
- They can be their name,age,sex,salary etc.set of these attributes values in a row is the record.
Structured Data
entity is real world object or being existed.Data modelling can also be Entity relationship model.Relation is also known as table in sql.
Schema
Databases has tables or relations,records,attributes.
So DB1 has customers ,products tables is the one example of database.