Task: Design This Database

Blog Task 1

Answer the following questions:

1. What does a column in a table represent? Field
2. What does a row in a table represent? Record - A group of records about a certain object or person that has been applied to the selected fields
3. What does DBMS stand for?
A Database Management System (DBMS)

4. What is a primary key in a table used for? The Primary Key is used for the ID itself and is able to identify it in the database.

5. Why is the ID column such a useful field? The ID column is useful because it gives a indication what was inputted into the system first

6. What Access data type would you use to store the string “18 Segway Drive, Moonville” ? To store the string “18 Segway Drive, Moonville” a text data type of would be used.

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

8. What Access data type would you use to store a number? The number data type would be used since this can be inputted for further calculations such as a pricing of an item.

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

10. A database is a collection of what? A database is a collection of data that is stored in a structured format of columns and rows.

11. A table is made up of what?
A Table is a group of releated records that contain the same fields

12. What is a record? A record is a group of related field that contain all valuable information about an object or person.

13. Are spaces allowed in field names? You're welcome to put spaces in your field names but its not necessary

Activity 1: Create a database

Object ToString method

Blogpost: Object ToString method

• What did the ToString method display?
• Include a screenshot.
• Was the information useful?

The Object class

What is the purpose of the Object class?
It's purpose is to support all other classes in the hierarchy and also service lower leveled classes

How many constructors does it contain?
It contains only 1 constructor

How many methods does it contain?
the object class contains 8 methods

What is the purpose of the ToString method?
the purpose of the ToString method is to return a string that represents the object eg. a number as an integer.

String Manipulation

3. Write about 6 of the functions listed

• Purpose of function
• Number of overloads (if any)
• Parameters and their data types
• Return type
• Exceptions thrown by the function

Join function
Purpose -  The join function joins a number of substrings that are positioned in an array
Overloads - Join has 2 overloads
Parameters/Data Types - SourceArray (Object) & Delimiter (String)
Returns - Join returns a String
Exceptions - ArguementException

StrDup function
Purpose - is to return a specified character from a specified number of times
Overloads - StrDup has 3 overloads
Parameters/Data Types - Number (Int32) Character (Char)
Returns - StrDup returns a Strng

Exceptions - ArguementException & ArguementNullException

StrConv function

Purpose - Covert to a specified string
Overloads - 0 overloads
Parameters/Data Types - Str(String) & Conversion(StrConv) & LocaleID(Int32)
Returns - StrConv returns a string

Exceptions - ArguementException


LTrim function
Purpose - a copy of a specified string that contains no leading spaces
Overloads - 0 overloads
Parameters/Data Types - str(String)
Returns - this returns a String

Exceptions - 0 exceptions

Filter function

Purpose - to return an array that contained
Overloads - 2 overloads
Parameters/Data Types - Source(Object) & Match(String) & Include(Boolean) & Compare(CompareMethod)
Returns - Filter returns a zero based array

Exceptions - ArguementException

LCase function
Purpose - to covert a string or character to lowercase
Overloads - 2 overloads
Parameters/Data Types - Value(Char)
Returns - this returns both a string or character

Exceptions - 0 exceptions

3. Exception Hierarchy

3. Exception Hierarchy

What are the names of the 2 exception type categories?
The 2 exception type categories are  ApplicationException and SystemException. 

When is a IndexOutOfRangeException thrown?
The exception that is thrown when an attempt is made to access an element of an array with an index that is outside the bounds of the array.