No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
I have a database table like the one mentioned below. id | lecture | subject_id | date | is_deleted ------|--------------------|------------|------------|----------- 1 | Introduction | 1 | 2012-08-10 | 0 2 | Structure | 2 | 2012-08-15 | 1 3 | Introduction | 2 | 2012-08-12 | 0 4 | Functions …
|
|
|
I have a person table which specifies common attributes of sub tables teacher, student and staff. A person can be either teacher, student or both. I use the same primary key in sub tables which access the person table as foreign key (teacher_id, student_id is the same as of person_id). …
|
|
|
I have a monthly fee collecting table. I need to store year and month only for that purpose. For example just like to store, John has done the payment for 2010 July. I thought of using a DATE field for this. I can store the year and month with valid …
|
|
|
I need to know whether there is a performance issue when dealing with the database(database operations)depending on the datatype size of a particular field of a table. I have a table with a SMALLINT size primary key. But there is a chance of having a big data range than this …
|
|
|
I design an academic information registration system. I have 3 types of users namely teachers, students and operators. As all these have some properties in common I thought of designing it in the following manner. teacher([U]id[/U], profile_id) student([U]id[/U], profile_id) operator([U]id[/U], profile_id) profile([U]id[/U], first_name, last_name, tel) teacher_specific([U]teacher_id[/U], academic_qual) - teacher_specific has …
|