c#,SQL Server Question

Question

1.00/5 (1 vote)

See more:

SQL-Server-2005

Hey Guys,

I have a parent class Fruits and two nested classes like Apple and Orange.This relationship is called inheritance.but can anyone plz tell me if i want to design table structure in the database.what would be that relationship called and how can i design/relate tables from that schema ?

Thanks in Advance.

Posted 1-Mar-14 18:00pm

anik butt

Add a Solution

Comments

PIEBALDconsult 2-Mar-14 1:22am

I doubt your example is very good. It is quite likely that you only need one table -- Fruit -- and something to indicate Type -- Apple, Orange, etc.
Or, if Apple and Orange are too dissimilar, then you might have an Apple table and an Orange table.

3 solutions

Solution 1

Nested is totally irrelevant to inheritance. To use inheritance, you should derive Apple an Orange from Fruit. (I changed base class name to singular; your use of plural is based on you deep confusion about inheritance and the very role of classes and instances.)

And of course, it's way to early to discuss databases with you. You are just not ready. So far, you have no clue on how OOP works and need to learn it (and, I'm sure, very many basics things) before you get to anything advanced.

—SA

Posted 1-Mar-14 18:10pm

Sergey Alexandrovich Kryukov

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Peter Leow · Accepted Answer · 2014-03-01T19:55:00

Solution 3

Read these, hopefully they can give your some ideas:
1. c-oop-abstract-classes-fruit[^]
2. how-do-you-effectively-model-inheritance-in-a-database[^]

Posted 1-Mar-14 19:55pm

Peter Leow

Member 10510822 · Accepted Answer · 2014-03-01T18:13:00

Solution 2

YOu could give more details for your problem. You can take a table T_FRUIT with a primary key and give the primary key to T_APPLE and T_ORANGE as foreign key.

T_FRUIT
FruitsId
FruitsName
FruitsSize

T_APPLE
AppleId
FruitsId
AppleColor

T_ORANGE
OrangeId
FruitsId
OrangeColor

Posted 1-Mar-14 18:13pm

Member 10510822