Click here to Skip to main content
15,844,673 members
Home / Discussions / Database
   

Database

 
GeneralRe: Knowing if connection failed to sql server in C# Pin
Jörgen Andersson26-Aug-15 3:43
professionalJörgen Andersson26-Aug-15 3:43 
GeneralRe: Knowing if connection failed to sql server in C# Pin
pluss426-Aug-15 9:08
pluss426-Aug-15 9:08 
Questionquestion for my new project Pin
turion8722-Aug-15 6:09
turion8722-Aug-15 6:09 
AnswerRe: question for my new project Pin
Wendelius22-Aug-15 6:58
mentorWendelius22-Aug-15 6:58 
AnswerRe: question for my new project Pin
Mycroft Holmes22-Aug-15 14:37
professionalMycroft Holmes22-Aug-15 14:37 
AnswerRe: question for my new project Pin
Jörgen Andersson23-Aug-15 22:09
professionalJörgen Andersson23-Aug-15 22:09 
AnswerRe: question for my new project Pin
GuyThiebaut25-Aug-15 3:53
professionalGuyThiebaut25-Aug-15 3:53 
QuestionER Diagram Pin
piiinku0021-Aug-15 16:53
piiinku0021-Aug-15 16:53 
I am trying to create an ER diagram for online auction for smart phones.
The brand new phones are only for sale. The sale is in auction style. A new phone can be listed with a starting price and available numbers etc for a few days (e.g. 3 days). During this period, a buyer can put a bid with an offered price for a listing. At the end of the period, the listing can have a number of bids. Based on the bids of a listing, sale transactions may happen between the sellers and buyers.
2. The used phones are only for rent. A buyer is to submit an application for renting a phone. As a result, rent transactions may happen between sellers and buyers.
3. As described above the customers are either sellers (selling or leasing phones) or buyers (buying new phones or renting the used phones). A seller must have a registered payment method (e.g. PayPal) for the income from selling and a registered payment method (e.g. PayPal) for paying management fees to the Best Deal. A buyer could have a registered payment method (e.g. PayPal) for paying any purchased items or just paying by credit card directly when buying. However either a seller or a buyer must have at least a phone or a mobile or an email contact.

this is what i have done so far..

Photo of ER Diagram[^]
AnswerRe: ER Diagram Pin
Jörgen Andersson23-Aug-15 23:21
professionalJörgen Andersson23-Aug-15 23:21 
QuestionJoining 4 Tables in SQL Server Pin
Member 1154678320-Aug-15 11:35
Member 1154678320-Aug-15 11:35 
AnswerRe: Joining 4 Tables in SQL Server Pin
Mycroft Holmes20-Aug-15 14:02
professionalMycroft Holmes20-Aug-15 14:02 
GeneralRe: Joining 4 Tables in SQL Server Pin
Member 1154678321-Aug-15 4:50
Member 1154678321-Aug-15 4:50 
GeneralRe: Joining 4 Tables in SQL Server Pin
Eddy Vluggen21-Aug-15 5:20
professionalEddy Vluggen21-Aug-15 5:20 
GeneralRe: Joining 4 Tables in SQL Server Pin
Mycroft Holmes21-Aug-15 15:16
professionalMycroft Holmes21-Aug-15 15:16 
GeneralRe: Joining 4 Tables in SQL Server Pin
Member 1154678322-Aug-15 0:14
Member 1154678322-Aug-15 0:14 
GeneralRe: Joining 4 Tables in SQL Server Pin
Mycroft Holmes22-Aug-15 2:09
professionalMycroft Holmes22-Aug-15 2:09 
GeneralRe: Joining 4 Tables in SQL Server Pin
Member 1154678323-Aug-15 5:25
Member 1154678323-Aug-15 5:25 
QuestionSSIS Error handling : Events vs control flow? Pin
Paddington Bear19-Aug-15 3:33
Paddington Bear19-Aug-15 3:33 
Questionsql linq, sum a column in a select new with Pin
jkirkerx16-Aug-15 13:39
professionaljkirkerx16-Aug-15 13:39 
AnswerRe: sql linq, sum a column in a select new with Pin
chairborne8217-Aug-15 2:46
chairborne8217-Aug-15 2:46 
GeneralRe: sql linq, sum a column in a select new with Pin
Mycroft Holmes17-Aug-15 3:42
professionalMycroft Holmes17-Aug-15 3:42 
AnswerRe: sql linq, sum a column in a select new with Pin
Jörgen Andersson17-Aug-15 4:01
professionalJörgen Andersson17-Aug-15 4:01 
GeneralRe: sql linq, sum a column in a select new with - Got the Sum part to work, need the Joins Pin
jkirkerx17-Aug-15 6:19
professionaljkirkerx17-Aug-15 6:19 
QuestionWPF/Entity Framework Design Time Exception Pin
Kevin Marois14-Aug-15 6:49
professionalKevin Marois14-Aug-15 6:49 
AnswerRe: WPF/Entity Framework Design Time Exception Pin
Jörgen Andersson15-Aug-15 7:51
professionalJörgen Andersson15-Aug-15 7:51 

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.