Click here to Skip to main content
13,633,537 members
   

Database

 
AnswerRe: sql query to get code with max rank Pin
Richard Deeming27-Feb-18 7:58
mvpRichard Deeming27-Feb-18 7:58 
AnswerRe: sql query to get code with max rank Pin
Paket Wisata Lombok28-Feb-18 6:01
memberPaket Wisata Lombok28-Feb-18 6:01 
QuestionUnable to find Postgresql data source in Entity Data Model Wizard Pin
Sudhir Dehade27-Feb-18 1:19
memberSudhir Dehade27-Feb-18 1:19 
Rant[REPOST] Unable to find Postgresql data source in Entity Data Model Wizard Pin
Richard Deeming27-Feb-18 2:12
mvpRichard Deeming27-Feb-18 2:12 
RantRe: [REPOST] Unable to find Postgresql data source in Entity Data Model Wizard Pin
Richard Deeming27-Feb-18 2:20
mvpRichard Deeming27-Feb-18 2:20 
GeneralRe: [REPOST] Unable to find Postgresql data source in Entity Data Model Wizard Pin
Richard Deeming27-Feb-18 2:26
mvpRichard Deeming27-Feb-18 2:26 
GeneralRe: [REPOST] Unable to find Postgresql data source in Entity Data Model Wizard Pin
Sudhir Dehade27-Feb-18 2:30
memberSudhir Dehade27-Feb-18 2:30 
QuestionTable Database Advice Pin
JackMisani22-Feb-18 0:36
memberJackMisani22-Feb-18 0:36 
Hello everybody,
i'm writing to ask an advice.
In my Access db, I've many tables but the most important table is named "Products".
The Primary Key for this table is the "Product Code".
For every product I've to save different fields. Some fields are descriptives fields that rarely change while other fields are prices fields that change different times per day.

Which is the best way to represent a product? I have these 3 ideas:

1) TABLE1 where I insert only descriptives fields and has the product code as primary key. TABLE2, where i save only prices, that has a relation one to one with the first table and share the primary key with it.
2) TABLE1 where I insert descriptives fields and an integer field at the end which is in relation with TABLE2 where I save prices. In this case the primary key of table2 will be an identity field. Also in this case it will be a one to one relation. I'm sceptic for this solution because I always add and remove products from table1 so, after 1 year it will be possible that I will have 10.000 product in my database but the primary key of TABLE2 will be a very big number like 50.000.
3) Only TABLE1 where I save every fields both desctiptives and prices fields.

Which is the best solution in your opinion? In this moment i've adopted the first solution...

Thank
Giacomo
AnswerRe: Table Database Advice Pin
Richard Deeming22-Feb-18 0:53
mvpRichard Deeming22-Feb-18 0:53 
GeneralRe: Table Database Advice Pin
JackMisani22-Feb-18 2:10
memberJackMisani22-Feb-18 2:10 
GeneralRe: Table Database Advice Pin
Mycroft Holmes22-Feb-18 12:15
professionalMycroft Holmes22-Feb-18 12:15 
GeneralRe: Table Database Advice Pin
JackMisani25-Feb-18 22:43
memberJackMisani25-Feb-18 22:43 
AnswerRe: Table Database Advice Pin
Eddy Vluggen22-Feb-18 6:51
professionalEddy Vluggen22-Feb-18 6:51 
AnswerRe: Table Database Advice Pin
jschell23-Feb-18 13:44
memberjschell23-Feb-18 13:44 
GeneralRe: Table Database Advice Pin
JackMisani25-Feb-18 22:49
memberJackMisani25-Feb-18 22:49 
QuestionError converting data type nvarchar to datetime Pin
indian14321-Feb-18 11:13
memberindian14321-Feb-18 11:13 
AnswerRe: Error converting data type nvarchar to datetime Pin
Mycroft Holmes21-Feb-18 12:11
professionalMycroft Holmes21-Feb-18 12:11 
AnswerRe: Error converting data type nvarchar to datetime Pin
Member 1226788921-Feb-18 19:21
memberMember 1226788921-Feb-18 19:21 
QuestionNeed some suggestion Pin
indian14321-Feb-18 7:58
memberindian14321-Feb-18 7:58 
QuestionDBAs- What is your biggest pet peeve with developers? Pin
Member 1320002419-Feb-18 13:32
memberMember 1320002419-Feb-18 13:32 
JokeRe: DBAs- What is your biggest pet peeve with developers? Pin
Mycroft Holmes19-Feb-18 15:25
professionalMycroft Holmes19-Feb-18 15:25 
AnswerRe: DBAs- What is your biggest pet peeve with developers? Pin
Eddy Vluggen19-Feb-18 17:13
professionalEddy Vluggen19-Feb-18 17:13 
AnswerRe: DBAs- What is your biggest pet peeve with developers? Pin
‭011111100010‬20-Feb-18 2:10
professional‭011111100010‬20-Feb-18 2:10 
AnswerRe: DBAs- What is your biggest pet peeve with developers? Pin
S Douglas8-Mar-18 5:13
professionalS Douglas8-Mar-18 5:13 
QuestionCan a computer install multiple versions of SQL Server Management Studio ? Pin
Member 245846712-Feb-18 15:58
memberMember 245846712-Feb-18 15:58 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Cookies | Terms of Service
Web03 | 2.8.180712.1 | Last Updated 20 Jul 2018
Copyright © CodeProject, 1999-2018
All Rights Reserved.
Layout: fixed | fluid