We are developing a ticket system and for the dashboard we want to show the tickets with it’s latest status. We have two tables. The first one for the ticket itself and a second table for the …
Tag: relational
Database design, customers (companies / individuals) in the same table?
Found possible duplicate : Database design, multiple types of customers in the same table Hi everyone. I’m actually looking for a nice way to create a database with 2 kinds of customers : Individuals and Companies. This is for a website and I’m using CodeIgniter framework (not sure it’s important to precise). I will only write the “important” fields to
Superkey, candidate key & primary key
Can any kind soul clarify my doubts with a simple example below and identify the superkey, candidate key and primary key? I know there are a lot of posts and websites out there explaining the differences between them. But it looks like all are generic definitions. Example: So from the above example, I can know StudentNumber is a primary key.