in sql connecting transaction table with different kinds of transactions?

I am making a mysql database for a restaurant. I have a table called: *tbl_contents* which stores all the contents ...

Relationships between Master and Transaction tables?

In my database design, I've defined Master tables (data definition tables, static in nature) which will be used to g...

Hotel Management Database Design Problems?

I am trying to get started with Web Development by trying to develop a Hotel Management System. I am using MySQL 5....

MySQL Database Schema for role based system?

We are developing a platform for NGOs (N) to get their work done via Individual Volunteers (V) or Volunteers via a C...

Abstract Class from UML to ER diagram. Possible ? How??

I have the below UML class diagram with Abstract Class, and sub-Classes that extends from it. and i want to make an ...

Database normalization for School Management System?

I am creating system for a school management system and come up with the attached database schema. Following is ho...

Relational Database design issue?

While designing a relational database I got the questoin in my head if the design I made could be made easier. The d...

Designing a database for time table for a school management system?

Hello I'm about to create a school management system where it should assure the relashionship between teachers, clas...

How to structure a database with multiple join tables?

This is the first time I'm trying to store a more complex object into a database. I need some help with the design o...

How are these tables related??

Say I run an online business where you can order products from my website, and I have a database with two tables: T...

Attendance and invoice database design?

I am designing a database for managing a small private school (~15 teachers, 250 students). The student and teacher ...

Database Design for Invoices With Monthly Installments?

This question is an extension/expansion of an already answered question on StackOverflow: Database Design for Invoic...

How to Insert Checkboxes in each cell of codeigniter calendar?

I am building attendance system for employees. where i would like to store the records of the days into sql if it a ...

How to design a survey database schema that includes matrix questions??

I'm working on a complex survey form for a client and will be used only once, the survey is going to be anonymous so...