EGR 1400
EGR 1400 Final Exam 2026
Table
A rectangular array of data
Field
A column in a table
Record
A row in a table
DataSource
Importating the data source into Visual Studio
DataMember
Generates the data to be used in Visual Studio
Primary key
Used to uniquely identify each record
Rule of Entity Integrity
Every record musth ave an entry in the primary-key field
Two records cannot have the same entry
Rule of Referential Integrity
Every foreign key can be specified when a table is first created
Foreign key
When there is a correlation between two entries
Join
Allows Visual Studio to link two tables
LINQ
Language Integrated Query
EGR 1400
, EGR 1400
Load event procedure
Occurs at the form loads, a good place to assign values to an array
arrayName.Count()
Number of elements
arrayName.Max()
Highest value
arrayName.Min()
Lowest value
arrayName.First()
First element
arrayName.Last()
Last element
numArrayName.Average()
Average value of elements
numArrayName.Sum()
Sum of values of elements
Split
Converts a string containing a delimiter into a string array
Delimited
To establish the limits and boundaries
str.Split(null);
Space is the delimiter
Query
Request for information from a database
Query: from
EGR 1400
EGR 1400 Final Exam 2026
Table
A rectangular array of data
Field
A column in a table
Record
A row in a table
DataSource
Importating the data source into Visual Studio
DataMember
Generates the data to be used in Visual Studio
Primary key
Used to uniquely identify each record
Rule of Entity Integrity
Every record musth ave an entry in the primary-key field
Two records cannot have the same entry
Rule of Referential Integrity
Every foreign key can be specified when a table is first created
Foreign key
When there is a correlation between two entries
Join
Allows Visual Studio to link two tables
LINQ
Language Integrated Query
EGR 1400
, EGR 1400
Load event procedure
Occurs at the form loads, a good place to assign values to an array
arrayName.Count()
Number of elements
arrayName.Max()
Highest value
arrayName.Min()
Lowest value
arrayName.First()
First element
arrayName.Last()
Last element
numArrayName.Average()
Average value of elements
numArrayName.Sum()
Sum of values of elements
Split
Converts a string containing a delimiter into a string array
Delimited
To establish the limits and boundaries
str.Split(null);
Space is the delimiter
Query
Request for information from a database
Query: from
EGR 1400
