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

Getting white icon for instance in SSMS??

I have registered one new server but showing white icon instead of green. But my other colleagues can able to see gr...

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

Onetomany with parent database design?

Below is a database design which represents my problem(it is not my actual database design). For each city I need to...

How do i properly design a data model for Recipe / Ingredient using MongoDB?

Recently i have designed a database model or ERD using Hackalode. So the problem I'm currently facing is that base o...

Recipe database design advice?

I have a problem designing my database. I have to make a table witch contains let's say a Recipe. I have tables that...

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

Database structure for “customer” table having many orders per customer and many items per order?

I am trying to create a database where each customer has several orders(new orders daily) and each order has several...

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

Save data in single byte Kana for japanese language?

I have a situation where I am storing bank name for Japanese culture for Japan. So the problem is we found the Bank ...

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

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

Database Design for enterprise hardware stock and billing?

I have to develop a database for an enterprise to manage its pc hardware and software stocks, PC breakdowns and pc a...