0
1

[–] bisteot 0 points 1 points (+1|-0) ago 

  1. Dont focus in the tool. Contradictory, dismiss access, aint a proper manager.

  2. Create a visual model of entities with attr and relationships.

  3. Identify primary keys on yor model.

  4. Translate model to tables.

  5. Normalize.

  6. Implement on software

0
0

[–] Zerowolf [S] 0 points 0 points (+0|-0) ago  (edited ago)

Thank you! i'm trying my best. I guess it comes with experience. Could you elaborate why access isn't so great. A lot of people say it's not good and i'm too afraid to ask why

0
1

[–] bisteot 0 points 1 points (+1|-0) ago 

[–] [deleted] 0 points 1 points (+1|-0) ago 

[Deleted]

0
0

[–] Zerowolf [S] 0 points 0 points (+0|-0) ago 

it Isn't too tough but for now it's time consuming. I think after a while everyone gets faster at it but right now stupid test constraints put a lot of pressure on me. I just want to work on something at home to aid in studying and getting better

0
1

[–] 10705241 0 points 1 points (+1|-0) ago  (edited ago)

I'm not aware of a good resource, but I haven't done much from scratch and I've been out of school for too long. Usually everything I've worked on has already had most of the database in place already, but that's corporate work for you.

Are you primarily concerned with coming up with table schemas that meet the requirements and just have the basics, like primary and foreign keys with reasonable data types? Or more complicated than that?

Personally, my method has been fixing things that aren't so good. Usually on the DB side it's queries that are too slow and need indexes set up. But more often it's sloppy code hitting the DB too much or doing inefficient queries A lot of learning was just from trial and error and seeing how other people wrote queries. But that's more DB usage than design.

0
0

[–] Zerowolf [S] 0 points 0 points (+0|-0) ago 

I'm too much of a beginner to know about Queries , though, we are going to be working on them soon enough. I see the importance of databases and it makes me want to learn them inside and out be it with SQL or something else.

So far i'm concerned with the basic requirements such as normalization and reasonable data types. I'm looking into data validation as well on both databases and Java. I just wish to deepens my knowledge in a more hands on approach as i find doing readings and going through books a little tedious though i'm open to a good book suggestion if that is what it takes.

A few people have pointed out that their databases were okay enough to get a job and when they finally got a job with databases their knowledge grew exponentially do to the complete access to data. So i guess i'd be looking for ways to get Data to make a database even if it's fake

0
0

[–] 10705848 0 points 0 points (+0|-0) ago  (edited ago)

There's a standard testing database from Microsoft called Northwind I think that might be a good example in terms of schema and data. Not sure if there's an Access version.

edit: this maybe? https://blogs.office.com/en-us/2010/07/19/northwind-2010-web-database-is-now-available/