Good db table design: One table mixing different entities or separate table for each entity


surfsatwerk
HOME ยป Programming Languages

What is better database design?


Having one big table that could contain different "types" of records eg: employees, cars, cell-phones, and in order to identify each type of record, we have a column called type.


So the table would have columns that look like


id | type | name

1 | car | Ford


2 | car | Toyota


3 | phone | motorola


4 | employee | Jack


5 | employee | Aneesh


6 | phone | Nokia


7 | phone | Motorola


or have different tables for each type


eg:



Related to : Good db table design: One table mixing different entities or separate table for each entity
Good db table design: One table mixing different entities or separate table for each entity
by surfsatwerk in Programming Languages

What is better database design?


Having one big table that could contain different "types" of records eg: employees, cars, cell-phones, and in order to identify each type of record, we have a column called type.


So the table would have columns that look like


id |
Entity Framework 4 - Code First not storing inherited table separate from base table
by kraszie in Programming Languages

With EF Code First CTP 4 I've created a simple project. This project consists of 2 classes, one inherited from other.


I wish to store the data in separate tables, but the default of EF 4 is to map/store these two entities in the same table.


With .ToTable(), I


Best Practice - Mixing Table-Entities with View-Entities in EntityFramework?
by sub-80 in Programming Languages

I have a legacy database that I'd like to interact with Entity Framework.


The database is highly normalised for storing information about flights. In order to make it easier to work with some of the data, a number of SQL Views have been written to flatten data and to pivot certain mul


Is it a good practice to maintain the data in a separate table from the task table?
by teabagbrewster in Programming Languages

In my application there is a module which displays info by reading from a table. This info can be edited. Once edited there is a series of actions needs to be performed. So i am maintaining a task table which will create task for each edit made. In order to execute the task, i need the data modif


Table design with joining tables or separate ID in main table
by Gerhard Miller in Programming Languages

I'm designing a database that has a couple of tables; FAQ's, Bulletins, and Attachments. Bulletins and FAQ's could have an attachment associated with them, so my initial thought was to create a joining table with the two primary keys as a composite key:


Bulletin
--------
TAGS: Table design with joining tables separate
table design question? linking table with or without separate primary key?
by Mandaris in Programming Languages
table design question? linking table with or without separate primary key?
 
I have several tables:
HOUSE
house_ID
address
OWNER
owner_ID
name
telephone...
HOUSE_OWNER_JOIN
houseID
ownerID
ownershipDate //date they bough
Adding property to entity in Azure Table Storage seems to add null property to all entities in table
by Triumph in Programming Languages

I'm trying to dynamically add properties to Azure Table Storage using the ReadingEntity and WritingEntity events, as described here: How to add new properties to an entity saved in Azure Table Storage?.


The purpose is to save a List property on my poco into table storage. To accompli


table design question? house table, owner table, code violations table - best way?
by dfrolov in Programming Languages
Given the tables:
HOUSE
house_ID
address
OWNER
owner_ID
name
telephone...
HOUSE_OWNER_JOIN
?
CODE_VIOLATION_HISTORY
house_ID
violation_ID
violationStatement
...
My goal is to be able to track code violations of the house PER
table design question? house table, owner table, code violations table - best way?
by Monev in Programming Languages
Given the tables:
HOUSE
house_ID
address
OWNER
owner_ID
name
telephone...
HOUSE_OWNER_JOIN
?
CODE_VIOLATION_HISTORY
house_ID
violation_ID
violationStatement
...
My goal is to be able to track code violations of the house PER
DB design : members table separate or all in one table?
by 007ELmO in Programming Languages

I want to create a table of friends with personal information and log on details.


What better to separate the members table to 2 tables ,
one contain minimal details ,
second with Other details.


or remain in one table ?


i have a lot of tables that co


Privacy Policy - Copyrights Notice - Feedback - Report Violation - RSS 2014 © bighow.org All Rights Reserved .