473,473 Members | 2,253 Online

Sign in
Join

Home Posts Topics Members FAQ

Relazione in base a caratteristiche comuni

Buongiorno a tutti, ho un piccolo problema ma grande per me poco
esperto. Forse è un mio errore di impostazione del DB, o non vedo la
relazione nell'ottica giusta o magari semplicemente mi sono perso in un
bicchier d'acqua ma....

ho un file fornitori, con una tabella "fornitori" che contiene i campi
anagrafici del fornitore come:
-ID fornitore (Chiave primaria)
-Nome
-pIva
-Indirizzo

Ogni fornitore ha una tipologia diversa: uno è albergo, l'altro
ristorante, ecc.
quindi ho creato delle tabelle "albergo", "ristorante", Ecc. che
contengono nei campi, oltre a una chiave primaria, le info essenziali e
specifiche per ciascuna tipologia. (tipo nella tabella albergo "N°
stanze" e "distanza dall'arepoprto")

Come le metto in relazione? le relaziono direttamente? Creo una tabella
di collegamento "tipologie" ?

Grazie davvero per qualsiesi aiuto!!! e a buon rendere...

Nov 21 '06 #1

Subscribe Reply

1

1539

Filippo:

Ho trasmesso una copia di una base di dati di esempio al vostro email.

Buona fortuna!

Alexandre Bejerman
Montreal, Canada

Plume wrote:

Buongiorno a tutti, ho un piccolo problema ma grande per me poco
esperto. Forse è un mio errore di impostazione del DB, o non vedo la
relazione nell'ottica giusta o magari semplicemente mi sono perso in un
bicchier d'acqua ma....

ho un file fornitori, con una tabella "fornitori" che contiene i campi
anagrafici del fornitore come:
-ID fornitore (Chiave primaria)
-Nome
-pIva
-Indirizzo

Ogni fornitore ha una tipologia diversa: uno è albergo, l'altro
ristorante, ecc.
quindi ho creato delle tabelle "albergo", "ristorante", Ecc. che
contengono nei campi, oltre a una chiave primaria, le info essenziali e
specifiche per ciascuna tipologia. (tipo nella tabella albergo "N°
stanze" e "distanza dall'arepoprto")

Come le metto in relazione? le relaziono direttamente? Creo una tabella
di collegamento "tipologie" ?

Grazie davvero per qualsiesi aiuto!!! e a buon rendere...

Nov 21 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

Compute pi to base 12 using Python?

by: Dick Moores | last post by:

I need to figure out how to compute pi to base 12, to as many digits as possible. I found this reference, <http://mathworld.wolfram.com/Base.html>, but I really don't understand it well enough....

Tabella Elenco Comuni

by: Berserk | last post by:

Sapeto dove posso trovare una tabella sql con l'elenco di tutti i comuni magari aggiornata al 2003? Cerco una versione che contegna questi campi: Codice, Denominazione, esistenza, targa_provincia,...

"Assignment" through base class

by: Stephan Br?nnimann | last post by:

Dear all thanks to Scott Meyers (ME C++, item 33) we know assignment operators should be protected in the base class. Is there a common pattern (similar to virtual construction via `clone()')...

multiple base objects, real-life scenario.

by: Paul | last post by:

In real life situation, do we ever come across a situation where we would need two base objects in an object. A snippet is worth 1000 words (: so... class Base { }; class Derived1:public Base...

Problem with abstract base class

by: Jef Driesen | last post by:

Suppose I have an abstract base class that looks like this: template <typename T> class base { public: // Typedefs typedef double value_type; typedef std::size_t size_type; public: //...

REPOST:Hiding base class property from derived class instance

by: Baski | last post by:

Base class: class AssetBase { string _clli; public string CLLI { get

Page_load not called in base class

by: Andy | last post by:

Hi all, I have a site with the following architecture: Common.Web.dll - Contains a CommonPageBase class which inherits System.Web.UI.Page myadd.dll - Contains PageBase which inherits...

Copy Class from Base

by: miben | last post by:

I want to create a new inherited class givin its base. For example: class Base { public: void operator =(const Base &base) { // copy base items } }; class Inherits: public Base {

Database comuni italiani

by: After | last post by:

è possibile reperire da qualche parte un database con la lista completa dei comuni italiani con il relativo cap?? ( e se possibile col codice catastale) grazie!

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

php

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap

Advertise on Bytes
How to Post and Respond on Bytes
How to Promote and Link on Bytes
How to increase your Ranking on Bytes
Become a Recognized Expert on Bytes
Feedback Welcomed! Contact Us