Data are basic facts and values which can be either character or number and the combination of both. The task carry out by any system it carry out the data in some way. User play with the data and without data our systems are not of any use. List of the data are unorganized so there are various method and advanced technology invented by researchers to make the scattered data organized and access it more efficiently. Data is different from programs which is a set of instructions that deal to execute the task for the computer to perform.
As we know database is an organized collection of data so it provide structure to organize the data instead of an unordered list of data. So database provide one of the most common structure of tables i.e. Database tables which consist of rows and columns, rows are aligned horizontally and columns are aligned vertically. We can say table as a Two-dimensional array consist of data that are organized in rows and columns. There are some other terminologies that make a structured database. A record is a single row data that determine the details about a particular thing so a database table is a collection of records that sometimes also known as entity or object. A field is a column in the table which represent a single value for each record, in other words it also termed as attributes. So we can say a record is a collection of related attributes that make a single database entry.
Schema are stored in the data dictionary and defined in the text database language. We can say schema is a graphical depiction of the data structure. Schema define the tables and the field in each table and associated relationships between both the two. Schema is mainly of three types: Physical, logical and view schema. In physical schema data is stored in blocks of storage, and logical schema determine the design of database at logical level. View Schema determine the design of the database at view level which describe the interaction of end users with the database.
We can define column as a set of data values, and the value must be of single type in a table. In database columns are from top to bottom and contain complex data like images, whole documents, video clip also. One of the goal of column representation database is to efficiently read and write data to and from hard disk to speed up the time taken to return the result of the applied query.
Row is also another data record within the table which specify the complete information of the particular record. It is sometimes also known as tuples. Rows values are aligned horizontal within a table which contain multiple field that are defined by column. Row is different from record, because record is considered as each row in a table to a specific person or employee. So we can say a row contain multiple columns in database.
Data type define the type of data that are going to be stored in the database which is mainly of three types Alphanumeric, Numeric and data and Time. Alphanumeric data types contain values like character, numbers, special characters or the combination of any two. Arithmetic functions performed by using numeric value cannot stored in alphanumeric field. Whereas numeric data type are used to store numeric data and Data and Time are used to store date and time values.
Keys in database plays a vital role in the structure of a table. Keys are used to ensure each record in the table can be uniquely identified by one or a combination of fields within the table. This will help to ensure integrity and also help to identify relation between them. There are many types of keys but we are going to discuss the major one that help to design a structured database.
There are many more keys in database like super key, candidate key, composite key, secondary or alternative key to know more about the keys in database get help in Database management help or you can also take help from our online tutors by click here.
As we know databases are divided into many tables and most of them are related to each other like an organization have a database table of each employee department wise and how an employee of one department connect to another department employee recoded in another table which shows the relationship table. So now the purpose of separating data into tables is to establish such table which reduce data redundancy. So there are three types of relationships in database.