Welcome Guest ( Log In | Register)



 
Reply to this topicStart new topic
> Making A Data Base, i need info
khalilo
post Jun 23 2007, 12:20 PM
Post #1


Newbie [Level 3]
***

Group: Members
Posts: 48
Joined: 21-June 07
From: lebanon
Member No.: 45,185



Ok i made a new database called khalilo_units
There are no tables but i see create a table and number of fields
Whats a table and whats the number of fields
again make this as detailed and long as possible
Go to the top of the page
 
+Quote Post
jlhaslip
post Jun 23 2007, 01:31 PM
Post #2


A computer once beat me at chess, but it was no match for me at kick boxing.
Group Icon

Group: [MODERATOR]
Posts: 3,866
Joined: 24-July 05
From: In Trouble Again... still?
Member No.: 9,787
Spam Patrol



A Database is a collection of related information.
Tables are a collection of 'similar' information within the Database.
The Tables are structured into 'rows', or 'records'.
Each Rows includes 'fields'.

Example: a Database named "school" contains Tables named "students", "teachers" and "courses". The information about students is in the 'students' table, etc.

The Table for 'students' might contain name, address, phone number, student id_number. These are fields.

The table for 'courses' would contain information about the different courses, such as the Teacher responsible and the Students registered in that course.

This is a simplified version. Most applications use a "normalized" Database which is another Lesson, so once you understand the structure of simple Databases, it is important to grasp the concept of Database Normalization, where you reduce the amount of redundant data in the database and create connections between the various Tables. For example, you would likely create a 'student course' Table to connect students and classes instead of storing the information in the student record.

Hope this assist you with the concepts. There is much more that you will need to understand about Databases, this posting is intended to be simply a Primer.

Google will provide a fuller response. search: Database Tables
Or here: http://builder.com.com/5100-6388-5034633.html
Go to the top of the page
 
+Quote Post
reconraiders
post Jun 23 2007, 04:56 PM
Post #3


Super Member
*********

Group: Members
Posts: 221
Joined: 6-June 07
Member No.: 44,288



You should probably read some tutorials and other literature on databases, what they are, and what they do. I assume you're probably using a MySQL database. There are tons of places around the internet that you can find out whatever you need to know about MySQL databases. Everything I know, I have learned from the internet smile.gif
Go to the top of the page
 
+Quote Post
AnkitGoswami
post Jun 23 2007, 06:46 PM
Post #4


Advanced Member
*******

Group: Members
Posts: 107
Joined: 7-April 07
From: India
Member No.: 41,207



Example of a table: (lets call it student)

                 Roll               Name               Branch
                  1                   A                Computers
                  2                   B                    Civil
                  3                   C                Electronics

Now in this table called student the fields are : Roll, Name, Branch
to create a table in phpmyadmin just fill in the table name and no of fields on the initial form a
nd then click go.
In the next form enter the respected names of the fields (eg Roll, Name, Branch ), type (integer, char etc ), length (max size of the variable in most cases varchar with length 255 does the trick unless you are going to be comparing some numbers) don't worry about collation, you can set attributes to unsigned etc if you need , can decide if you want null values, set default values, auto increment etc. Now one more thing you can do in this page is set the primary key. The primary key of a table uniquely identifies each record in the table. Now press go and you will have created your table.
Go to the top of the page
 
+Quote Post
rize619
post Jun 23 2007, 07:21 PM
Post #5


Member [Level 1]
****

Group: Members
Posts: 66
Joined: 23-June 07
Member No.: 45,329



see some database tutorial here
pixel2life.com or take any book of atabase or relational system
these are the very basic of database u are askking..
hope u get answer from the above mentioned replies..
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. Im Making A Mmorpg >>(11)
  2. The Sims 2 Bodyshop(35)
  3. My Ipod Is Randomly Skipping Songs, Losing Data,(21)
  4. Making Winrar Archives(12)
  5. New Tech: Data Transmiting At 2.56 Terabites Per Second!(11)
  6. Make 100% Free Money Online $4000+(18)
  7. Get 30 Gb Email For Free(30)
  8. Data Can Be Stored On Paper(31)
  9. Making Mods(4)
  10. What Are The Steps To Making A Website?(15)
  11. Runescape 2 Private Server Guide: Part 1(16)
  12. Call Of Duty 4(8)
  13. Making Money From Home(13)
  14. What Is The Best Software(5)
  15. Where Am I Making Mistake(9)
  1. Reverse Funnel System Making Money On Auto Pilot.(2)
  2. Eraser - Erase Your Data Permanently! For Free(7)
  3. 1 Terabyte Of Data On A Thumb Drive(8)
  4. I Think That They Should Start Making Boxers For Girls.(4)
  5. Very Disappointed With Data Center Migration(9)
  6. Google Base Api For Beginners?!(2)
  7. Enzymes And Health(0)
  8. Making Calculators with PHP(4)
  9. Please Can You Review My Blog(3)
  10. Plants And Water Loss(0)
  11. Recommended List Of Money Making Sites(0)
  12. Agent-principal Relationships(0)
  13. Making My Own Browser(6)


 



- Lo-Fi Version Time is now: 20th July 2008 - 07:34 AM