Stuck with Relational Database

[Welsh_John]

I wonder if someone can help please? I'm trying to create a Relational database to record sightings I have made of railway locomotives on different dates and at different places. I've worked my way thro' some Youtube videos and also looked into how some other relational databases are related but nothing works for me. However, there is one thing which may be the problem. On some relationships I have seen there is just a line between tables but others have what looks like an infinity character (number 8 rotated thro' 90 degrees). What does this mean and how do I get it? Alternatively does anyone know of anybody who creates reasonable priced databases? I have been quoted between £500 & £1000 which for a pensioner is too much for a hobby database.
Thanks
John

 

[ranman256]

1 to many (infinity) is the master table having many detail records.

1 car, can have many service repairs.
1 person can have many payments.

Depending on the complexity of the db, it could be 500.
but if its a simple tracking a train car and its service, then I may have a db for you, no cost.
Message me.

 

[Joe4]

On some relationships I have seen there is just a line between tables but others have what looks like an infinity character (number 8 rotated thro' 90 degrees). What does this mean and how do I get it?

That usually indicates the "many" side of a relationship (if you have a "one-to-many" or "many-to-many" relationship type).

When designing a good relational database, it is important to understand and implementation to first few rules of data normalization.
Here are some good articles towards that end:
http://www.informit.com/articles/article.aspx?p=27226
https://support.microsoft.com/en-us/help/283878/description-of-the-database-normalization-basics

 

[Welsh_John]

Thanks for replying. I'm afraid it is more complicated than that. I tried sending a screendump of a spreadsheet page showing what I need but it hasn't worked.

Thanks
John

 

[Welsh_John]

Thanks for this.
John

 

[welshgasman]

I have a database that I use for a website. It is for ships, dates, ranks and crew.
The structure is the key.
You are welcome to a shell of it and amend it from there.?

 

[Welsh_John]

I'd really appreciate that (especially as I am also trying to create a database for ship sightings). Thanks
John

 

[welshgasman]

PM me your email address please.

 

[Welsh_John]

PM me your email address please.

jdrichardsuk@yahoo.co.uk

I assume this will be a blank (no data) copy so could you please tell me how to create a blank from a working database please?
Thanks
John

 

[welshgasman]

Yes it will be blank. Whilst the data is on the website and so not confidential, I thought you would be better off with an empty one.
Take a look at it, especially the relationships, however if ranman256 has one for you, it will be miles better than mine, as this was pretty much my first database, and I have never needed to enhance it, as the data is static after being entered.

Database emailed.