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

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

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

Database schema dilemmas?

I am developing database scheme for recipes database. Do you have some ideas how to enchance my existing model? My b...

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

Would you mind sorting through a few Beginner SQL invoice database creation questions??

I'm somewhat new to SQL. I need to make an invoice that can be queried to create a document that looks something li...

Attendance and invoice database design?

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

Data modelling draft/quote/order/invoice?

Im currently working on a small project in which I need to model the following scenario: Scenario Customer calls,...

Database Design for Invoices With Monthly Installments?

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

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

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

Schema Definition For Audit-like Asset Tracking (Entity Framework)?

I'm having trouble designing the relationships between entities in my schema. The issue is that each Asset (projecto...

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

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