Im going to create database.there are few table in that db.
I need to know what is the best ;
add more column to table or use separate table rather than add more column
Sadun89
-16
Junior Poster
Recommended Answers
Jump to PostHi Sadun89,
This all depends on what you're trying to do with your database. Depending on the information provided in the tables, you can choose whether or not to add a table or a column. If you provide more info, we should be able to help you better.
Jump to PostHey Sadun89,
you're welcome. Let me use this example. I want to create a student result management system. I have a student table, which contains columns like;
Student_Id(PK), Registration_No, First Name, Last Name and Age.I have another table called student_subjects, where i have ;
Subject_Id(PK), Name, TeacherI have …
All 5 Replies
seslie
56
Light Poster
Sadun89
-16
Junior Poster
seslie
56
Light Poster
Sadun89
-16
Junior Poster
JorgeM
958
Problem Solver
Team Colleague
Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.