Creating a database and Designing a database

Create a Database Activity:



Designing a Database Activity:

Database Blog Task

1. What does a column in a table represent?
Field

2. What does a row in a table represent?
Record

3. What does DBMS stand for?
Database Management System

4. What is a primary key in a table used for?
A unique field used to create relationships between different tables.

5. Why is the ID column such a useful field?
Its useful for uniquely identifying records, especially those that share similar details such as a first name and last name.

6. What Access data type would you use to store the string “18 Segway Drive, Moonville” ?
Text

7. What Access data type would you use to record True/False values?
Boolean

8. What Access data type would you use to store a number?
Number

9. What Access data type would you use to store a long string such as an essay or report?
Memo


10. A database is a collection of what?
Tables

11. A table is made up of what?
Records

12. What is a record?
A row of information in a table such as first name, last name and various other information such as telephone numbers, address etc.

13. Are spaces allowed in field names?
No.

File Handling in VB.NET

1. Which of the following methods can be used to open a sequential access file?
AppendText(), CreateText() and OpenText().

2. Which of the following writes the contents of the favouriteTuneTextBox’s Text property, followed by the newline character, to the sequential access file associated with the outFile variable?
outFile.WriteLine(favouriteTuneTextBox.Text)

3. What does IO in the syntax stand for?
Input/Output

4. Which of the following procedures can be used to read information from a sequential access file?
OpenText()

5. Which of the following reads a line of text from the file associated with the inFile variable and assigns the line of text (excluding the newline character) to the msg variable?
msg = inFile.ReadLine()

6. Write the statement required to close the file associated with the inFile variable.
inFile.Close()

7. If a sequential access file contains another character to read, what does the Peek method return?
The Peek method returns the next character if it exists otherwise it returns -1.

8. If a sequential access file does not contain another character to read, what does the Peek method return?
-1