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...

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...

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...

SQL Server database design users, groups, roles, memebers?

I have the following SQL Server db with one table so far. ---------------- |Users | ---------------- | Use...

Convert from ER to Relational Database - Mapping Weak entity types?

I am trying to map the weak entity CatalogueEntry into a relational schema, and I am unsure which of the entities ar...

relationships between 3 entities in ER diagram--is a ternary enough or are 2 binaries also needed??

I'm trying to draw an ER diagram for my project management software describing the following. It contains these enti...