quick quesions

Hi all,
 I have some quick questions about database knowledge:
       1. main data object of relational database, which one: column, row, table, field?
       2 . table field may or may not have a value: true or false?
       3. all rows of table has same structure: true or false?
       4. all column of a table must have a name: true or false?
       5. name of column of table must be unique :true or false
        6. row of table must be unique: true or false
        7 row of table should be unique : true or false

thanks a lot.
BeginToLearnAsked:
Who is Participating?
 
Dave BaldwinFixer of ProblemsCommented:
1. table
2. it depends, a field can be defined as 'not null' and require a value
3. true
4. true - part of the definition of the column
5. true within that table
6. false
7. true
0
 
BeginToLearnAuthor Commented:
please verify those:

A table is horizontally structured into column and vertically into row --> False??

Information should have one standard definition and presentaion , unless compelling business differences dictate otherwise---> True??

tks.
0
 
sihar86Commented:
1. main data object of relational database, which one: column, row, table, field?
column, ex: bookid column in borrowing table reference to bookid column in book table
       
2 . table field may or may not have a value: true or false?
true: we usually call it null, right?

3. all rows of table has same structure: true or false?
true (since table consists of many rows that have same column pattern)

4. all column of a table must have a name: true or false?
true

5. name of column of table must be unique :true or false
true

6. row of table must be unique: true or false
false

7 row of table should be unique : true or false
true
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Dave BaldwinFixer of ProblemsCommented:
A table is normally represented like a spreadsheet.  Rows are horizontal and columns are vertical.

"Information should have one standard definition and presentation" is basically true.  It would be confusing otherwise.
0
 
BeginToLearnAuthor Commented:
main data object of relational database, which one: column, row, table, field?
table vs column?
 I think it should be table right? because table is the key to make database difference in compared with datastructure??
0
 
BeginToLearnAuthor Commented:
hi angel,
 I just wonder whether i can ask those question in summary after reading each chapter to verify my understanding?  
0
 
BeginToLearnAuthor Commented:
Tks.i get it clear now :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.