Geek Answers Handbook

Creating a simple database schema

I am new to SQL and can use some help in creating a database schema for my program that manages and installs programs for my home network. Are there any guides / guides on creating database schemas?

+4
source share
2 answers

Probably the most important concept that you need to understand before you plan your scheme (you will thank for it later, trust me! :-) - this is normalization. The tutorial at db.grussell.org does not look too shabby and will give you good grounding. In fact, if you click on the “Up One Level” link and look around, some other data can be very useful.

My "top tip": write it down on paper or in notepad or anything other than a database before you start writing code. Get a good idea of ​​what you need for your circuit to be able to do before you install it in stone (And “set it in stone,” I mean, understand that you wrote a load of code on the circuit, which would have to correspond if you change it to do what you just understood what you need now).

+4
source

Database development is a separate area of ​​study and expertise. It cannot be compressed into one answer. Since you are interested in tutorials, check out the Database Design section of any tutorial on database management systems. I would recommend Database System Concepts, 5th, Abraham Silbershatz, Henry F. Cort, Sudarshan

In database design, remember the following

1) You identify important objects of interest to your home network. Try to avoid over-indulgence in the processes themselves, although they are important for identifying important data blocks to capture

2) Use ER / UML modeling techniques to develop chart / data model design. There are many tools to help you with this.

3) Use the principles of database normalization to fine-tune your schema to avoid data redundancy. Redundant data leads to the following side effects: Inability to maintain redundant data consistency, Inability to store some data in an elegant manner

3) Set up your design for DDL commands for the database of your choice. Most support tools support this.

Business Tools:

  • Microsoft visio
  • ER Studio (very expensive)
  • TOAD Data Model

There are many open source tools. You can try Dia. This does not support forward engineering.

+4
source

More articles:


All Articles