Home » Developer & Programmer » Designer » Problem in design a data model (Oracle Linux 6.7, Oracle
Problem in design a data model [message #672088] Tue, 02 October 2018 07:53 Go to next message
Messages: 112
Registered: November 2011
Senior Member
Hi experts,

I have a problem in designing data model in database.
The issue is that product information should be keep in database (So we should have a table with name of "Products"), the products come from different sources(So we should have a table with name of "Source_Types"), but one of the sources is divided into several parts itself ( we have a table with name of "Source_A"). The Tables structures are like:
Source_Type Table
Source_Type_ID (PK) int NOT NULL
Source_Name varchar2(50) NOT NULL

1 Source_A
2 Source_B
3 Source_C

Source_A Table
Source_A_ID (PK) int 
Name  Source_A_Name varchar2(50) 
Location_ID  int
Description varchar2(50) 

1 Source_A_1
2 Source_A_2
3 Source_A_3

And the products table is like this(the problem is here that I think design is wrong):

Product_ID  (PK) int NOT NULL
Source_Type_ID FK To Source_Type Table
Source_A_ID FK To Source_A Table
We need to partition the Products table by source_Type_id(not Source_A table),but we also need to know that the product come from which source_A. I mean partitions should be:
What do you suggest for resolving the issue?
Re: Problem in design a data model [message #672089 is a reply to message #672088] Tue, 02 October 2018 09:11 Go to previous messageGo to next message
Messages: 26763
Registered: January 2009
Location: SoCal
Senior Member
Neither TABLE_NAME nor COLUMN_NAME should ever contain application specific details; SOURCE_A

Normalize data to Third Normal Form.

IMO, partitioning should NOT be part of any initial design consideration.
Any partitioning should be transparent to the application & not be hard coded into the application
Re: Problem in design a data model [message #678514 is a reply to message #672089] Tue, 10 December 2019 06:13 Go to previous message
Messages: 1
Registered: December 2019
Junior Member
great to know that
Previous Topic: Activer et desactiver Menu item
Goto Forum:

Current Time: Tue Apr 20 04:48:48 CDT 2021