Recent content by sim18
-
S
Help with tables for a car database
Hi all, thanks so much for the replies. I have had a look at the example data models they were a huge help! I think I may have done the 'car' side of the database but may need some more help attaching the customers to it. I have attached my database with the relationships as a JPG. What I am... -
S
Help with tables for a car database
Hi all, thanks in advance. I am creating a car and customer database. I will have a database full of different types of cars. I will also have customers, these can be linked to a certain car for example a customer is selling a car, or a customer has just bought a car. I am wanting to be able... -
S
Could somebody check my ER Diagram and how I transformed them into relations?
I have attached my ER-Diagram, and from that I have transformed them into relations. Can somebody check them before I move on to normalize the relations? Entity-Sets. Medium(mediaType_id, description) Paintings(paintings_id, title, height, width) Artist(artist_id, artistName, birth, death...- sim18
- Thread
- Replies: 1
- Forum: Theory and practice of database design
-
S
Help with SELECT query
Not all fields have been filled in but the important ones are. Thanks very much -
S
Help with SELECT query
Does that mean they would be joined in the FROM part for example : SELECT artistName FROM Artist, gallery, exhibition, trophies WHERE gallery.city="London" So that it includes all the tables? Sorry iv'e got myself really confused with this now thanks -
S
Help with SELECT query
They are connected via Foreign Keys from other tables for example: FootballTable----TrophiesTable----ExhibitionTable----GalleryTable The GalleryTable shows that the city is in "London" They are connected and from the GalleryTable you can see which trophies are in the exhibition via the... -
S
Help with SELECT query
Sorry for the late reply, these tables are not related. I tried what you suggested : SELECT artistName FROM Artist, gallery WHERE gallery.city="London" That just comes up with all of the footballers names, instead of just the ones from london. Thanks for your reply -
S
Help with SELECT query
I have to list all the names of footballers who have a trophy in London. The trophies are in the GalleryTable: galleryId City G01 London G02 London G03 Liverpool And the footballers in the footballTable: FootballID FootballerName...