answersLogoWhite

0

Probably start with a data model preferably a class diagram of the modules involved in school management system. Just keep minimum modules to avoid complexity. For eg. Teacher, Students, Classrooms, Subjects & Library.

How you define relationships between different entities would define the tables and relationships between them for eg Library Table should have student id as foreign key & borrowed field as boolean (yes or no). If book is borrowed it will look into the student table for ID based on foreign key.

Just remember to keep it simple. Don't get too bogged down by complex relationships and focus on simple yet elegant tables

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

WHAT DOES THE TABLE MEAN IN DATABASE?

this means a table when you can record data ie name,DOB,school,address,animals and family member :}


What are the importance of table form query in database?

In database system the data is stored in the form of table. So to store the data in the database, table are very important in a database system.


Why is a table created in database?

Tables are central to a database. A table stores the data. Everything else in the database, such as queries, forms and reports, use the data from the table. Without tables, a database is useless as it would have no data.Tables are central to a database. A table stores the data. Everything else in the database, such as queries, forms and reports, use the data from the table. Without tables, a database is useless as it would have no data.Tables are central to a database. A table stores the data. Everything else in the database, such as queries, forms and reports, use the data from the table. Without tables, a database is useless as it would have no data.Tables are central to a database. A table stores the data. Everything else in the database, such as queries, forms and reports, use the data from the table. Without tables, a database is useless as it would have no data.Tables are central to a database. A table stores the data. Everything else in the database, such as queries, forms and reports, use the data from the table. Without tables, a database is useless as it would have no data.Tables are central to a database. A table stores the data. Everything else in the database, such as queries, forms and reports, use the data from the table. Without tables, a database is useless as it would have no data.Tables are central to a database. A table stores the data. Everything else in the database, such as queries, forms and reports, use the data from the table. Without tables, a database is useless as it would have no data.Tables are central to a database. A table stores the data. Everything else in the database, such as queries, forms and reports, use the data from the table. Without tables, a database is useless as it would have no data.Tables are central to a database. A table stores the data. Everything else in the database, such as queries, forms and reports, use the data from the table. Without tables, a database is useless as it would have no data.Tables are central to a database. A table stores the data. Everything else in the database, such as queries, forms and reports, use the data from the table. Without tables, a database is useless as it would have no data.Tables are central to a database. A table stores the data. Everything else in the database, such as queries, forms and reports, use the data from the table. Without tables, a database is useless as it would have no data.


How do you connect to a database and table using ADODB?

How do you connect to a database and table using ADODB?


When you create a new database which object is created first?

In Access, when you create a new database, a table is created first.


What is the means drop command?

The DROP table command of SQL lets you drop a table from database . The database requires you to empty a table before you eliminate from the database. But there is a condition for dropping a table ; it must be an empty table. syntax: 1st - delete from table-name; 2nd- drop table table-name;


Is a data table the same as a database?

No. A table is the primary object used within a database to store data. A typical database will consist of many tables.


What virtual table in a database is known as a?

A view table.


What is RBDMS?

RDBMS stands for Relational Database Management System. RDBMS data is structured in database tables, fields and records. Each RDBMS table consists of database table rows. Each database table row consists of one or more database table fields.RDBMS store the data into collection of tables, which might be related by common fields (database table columns). RDBMS also provide relational operators to manipulate the data stored into the database tables. Most RDBMS use SQL as database query language.


Relationship between a database and a table?

A table is contained within the database and consists of columns and rows. A table is meant to store data and, in relational databases, are related to other tables within the same database.


What if you delete a database table?

click undo to restore the table


What sequence represents the hierarchy of terms from smallest to largest from field record database and table?

field, record, table, database