In Relational Database Management Systems (RDBMS) data are represented using tables (relations). A query issued against the RDBMS also results in a table. A table has the following structure:

A table is uniquely identified by its name and consists of rows that contain the stored information, each row containing exactly one tuple (or record). A table can have one or more columns. A column is made up of a column name and a data type, and it describes an attribute of the tuples. The structure of a table, also called relation schema, thus is defined by its attributes. The type of information to be stored in a table is defined by the data types of the attributes at table creation time.

SQL uses the terms table, row, and column for relation, tuple, and attribute, respectively. A table can have up to 254 columns which may have different or same data types and sets of values (domains), respectively.

Before creation of the database we will find out the Tables, Table attributes and data types of the attributes. We will take the example of School Management System Database. This includes the details about the teachers, courses, students and marks. The following are structures of the tables in the system: -

Tables Used in the Database: - Teacher, Course, Student, Marks
Structure of the tables: -

Teacher

Course

Student

Marks

• Printer Friendly
• Email to a friend
• Add to my Favourites
• Download PDF version
• Report Bad Submissions
• Submit Feedback