Term
|
Definition
|
|
Term
|
Definition
| referes to a true/false variable or value |
|
|
Term
|
Definition
| : Variables/values passed to functions and subroutines. Also called parameters. |
|
|
Term
|
Definition
| values passed to functions and subroutines. Also called arguments. |
|
|
Term
|
Definition
| A procedure which returns a value. Functions should not produce side effects aside from returning a value. |
|
|
Term
|
Definition
| procedure which does not return a value. |
|
|
Term
|
Definition
| General term for some code lumped together and given a name, generally intended to perform a defined task. Includes subroutines and functions. |
|
|
Term
|
Definition
| Procedures with the same name but different parameter lists, generally doing the same thing with different types of data. |
|
|
Term
|
Definition
| A form, such as a dialog box, that takes control of your program, not allowing interaction with other forms while it's open. |
|
|
Term
|
Definition
| A form which doesn't take control of your program, allowing jumping back and forth between forms |
|
|
Term
|
Definition
| Database Management System. The software that organizes and retrieves data. Common DBMS’s are Oracle, Microsoft SQL Server, DB2, MySQL, and Access. |
|
|
Term
|
Definition
| Person, place, thing, event, or concept about which data is collected. |
|
|
Term
|
Definition
| A unit fact that characterizes or describes an entity. |
|
|
Term
|
Definition
| A column or set of columns that uniquely identifies each row in a table. |
|
|
Term
|
Definition
| Within a given table, a column or set of columns that uniquely identifies each row, and therefore could serve as the primary key. Some tables may have several candidate keys. Uniqname is an example of a candidate key in tables of student records that use StudentID as the primary key. |
|
|
Term
|
Definition
| A column or set of columns in a child table that is the primary key of another table (the parent table). The foreign key is used to associate records in the child table with records in the parent table. |
|
|
Term
|
Definition
| Structured Query Language; the language used in relational databases to communicate with the database. |
|
|
Term
|
Definition
| A column in a database table. |
|
|
Term
|
Definition
| A row in a database table. |
|
|
Term
|
Definition
| A question or request to a database. |
|
|
Term
|
Definition
| A stored query (actually called a query in Access). |
|
|
Term
|
Definition
| Creating or modifying a database so that it stores data efficiently and accurately, and avoids the three anomalies (insert, update, and delete). |
|
|
Term
|
Definition
| A situation wherein one cannot insert a new row into a table because of an artificial dependency. |
|
|
Term
|
Definition
| A situation wherein a deletion of data about one particular entity causes unintended loss of data that characterizes another entity. |
|
|
Term
|
Definition
| A situation where an update of a single data value requires multiple rows of data to be updated. |
|
|
Term
|
Definition
| The property of a table which has a proper primary key, no multivalued attributes, all non-key attributes functionally dependent on the entire primary key, and no transitive dependencies. The generally-accepted standard for normalization in OLTP databases. |
|
|
Term
|
Definition
| Online Transaction Processing. The term for databases which experience frequent INSERT, UPDATE, and DELETE commands, for example, a bank or a retail store. OLTP databases should generally be normalized to 3NF. |
|
|
Term
|
Definition
| Online Analytical Processing. The term for databases which are used for analyzing patterns and trends, and which do not experience frequent INSERT, UPDATE, and DELETE commands. To speed up analysis, these databases are frequently not normalized. |
|
|
Term
|
Definition
| The object through which a VB program can interact with a database. |
|
|
Term
|
Definition
| An in-memory representation of the results of a SELECT query. |
|
|
Term
|
Definition
| Object-oriented programming. A programming approach which incorporates encapsulation, modularity, polymorphism, and inheritance. |
|
|
Term
|
Definition
| Code used to create and store objects, and the procedures and properties that those objects will possess. |
|
|
Term
|
Definition
|
|
Term
|
Definition
| A combination of a subroutine and a function using the same name which appears to the rest of the program as a variable, but allows for data validation or other code to run whenever the property is accessed. |
|
|
Term
|
Definition
| A method for creating a data type which represents a simple list of choices. |
|
|
Term
|
Definition
| A subroutine which runs whenever a new object is created. In VB, a constructor is always called “New”. |
|
|
Term
|
Definition
| Procedures in a class having the same name but parameter lists which differ in type and/or number. |
|
|
Term
|
Definition
| Creating new classes from an existing class using the keyword “Inherits”. |
|
|
Term
|
Definition
| A specialized VB collection type which incorporates last in, first out (LIFO) behavior |
|
|
Term
|
Definition
| A specialized VB collection type which incorporates first in, first out (FIFO) behavior |
|
|
Term
|
Definition
| A specialized VB collection type which pairs a key of one data type with data of another. |
|
|
Term
|
Definition
| First in, first out; describes the behavior of a queue. |
|
|
Term
|
Definition
| Last in, first out; describes the behavior of a stack |
|
|
Term
|
Definition
| The general observation that computing capacity doubles every 18 months |
|
|
Term
|
Definition
| Linux, Apache, MySQL, PHP/Perl/Python—the most commonly used software suite for web servers. |
|
|
Term
|
Definition
| In Excel or other applications which use VBA, a subroutine with no parameters which can be called from the macro window, or (when set up properly) run by clicking a toolbar button or typing a special key combination. |
|
|
Term
|
Definition
| In Excel, a function created in a module which can then be used in formulas just like Excel’s built-in functions. |
|
|
Term
|
Definition
| Visual Basic for Applications. A powerful programming tool included with Microsoft Office applications and others. Enables users to automate many tasks in these programs, and to come up with solutions using techniques not built in to the applications. |
|
|
Term
|
Definition
|
|
Term
|
Definition
| A global system of interconnected computer networks that interchange data by packet switching using the standardized protocol suite TCP/IP. |
|
|
Term
|
Definition
| A system of interlinked hypertext documents accessed via the Internet using a web browser |
|
|
Term
|
Definition
| The first high-level programming language, developed between 1954 and 1957 by IBM. Used mainly for scientific and engineering computing. (FORTRAN was short for “formula translator”.) |
|
|
Term
|
Definition
| Palo Alto Research Center of Xerox Corporation, where much of the research that led to personal computers took place. |
|
|
Term
|
Definition
| Microsoft Disk Operating System. The operating system used on the original IBM PC in 1981 and used in later IBM and clone PC’s |
|
|
Term
|
Definition
| The open-source Unix-like operating system created by Linus Torvalds in 1991 |
|
|
Term
|
Definition
| The inventor of the relational database model was |
|
|
Term
| many-to-many relationships |
|
Definition
| The relational model does not directly support |
|
|
Term
| Oracle, MySQL, Microsoft SQL Server, Microsoft Access |
|
Definition
| According to the book, these are DBMS's |
|
|
Term
|
Definition
| Is the smallest named unit of data that can referenced in a relational database |
|
|
Term
|
Definition
| T/F: Microsoft Access does not allow spaces in table or column names. |
|
|
Term
|
Definition
| is a category for the format of a particular column. |
|
|
Term
|
Definition
| A many-to-many relationship in the conceptual design becomes an _____ in the logical design. |
|
|
Term
| physical layer, logical layer, external layer |
|
Definition
| Most modern DBMS's follow the ANSI/SPARC architecture, which is composed of three primary layers: |
|
|
Term
|
Definition
| Most commonly used database model today |
|
|
Term
|
Definition
| is a collection of interrelated data items that are managed as a single unit. |
|
|
Term
|
Definition
| When one-to-many relationships are implemented in tables, the column or set of columns that is stored in the child table to associate it with the parent table is called |
|
|
Term
|
Definition
| T/F: Properties have data types |
|
|
Term
|
Definition
| Double-clicking on a control at design time will cause the code window to open and display the control's _____ event handler. However, every control has many events besides that one. |
|
|
Term
|
Definition
| Many properties have ____ values. For example, the Button control's FlatStyle property allows the values Flat, Popup, Standard, and System. |
|
|
Term
|
Definition
| To assign an event handler to a control's event at runtime, use the _____ statement |
|
|
Term
|
Definition
| The ____ property determines whether a control attaches itself to one or more of its container's sides. |
|
|
Term
|
Definition
| Components appear in the _____ below the bottom of the form. |
|
|
Term
|
Definition
| Controls can be added to a form either at _____ time or ______ time |
|
|
Term
|
Definition
| The Left, Top, Width, and Height of a control have the data type ____ |
|
|
Term
|
Definition
| In practice, _____ properties are uncommon and _____ properties are extremely rare. This is because the first is basically the same as a function, while the second is the same as a subroutine. |
|
|
Term
|
Definition
| A _____ is a programming object that has a graphical component. A _____ is similar to a control, except it is not visible at runtime. |
|
|
Term
|
Definition
| At runtime, you get or set a property by using the _____ of the control, followed by a _____ , followed by the ______ of the property. |
|
|
Term
|
Definition
| The _____ and _____ properties allow a control to automatically resize itself when its container is resized. |
|
|
Term
|
Definition
| Some properties represent ____ of objects. For example, the ListBox control displays a list of items. |
|
|
Term
|
Definition
| A Font object's properties are ______ . To change the properties of a Font object, you actually need to create a new Font object using its ______ . |
|
|
Term
|
Definition
| To create an event handler for a control in the Properties window, click the Events button (which looks like a ______ ), and select the event you want to handle. |
|
|
Term
|
Definition
| A control or other object raises an ______ to let the program know about some change in circumstances. |
|
|
Term
| move the control slightly |
|
Definition
| To tell if a control is inside a container, _______ |
|
|
Term
|
Definition
| is some value associated with a control. |
|
|
Term
|
Definition
| The properties window displays compound properties with a ______ on the left. |
|
|
Term
|
Definition
| To place a control inside a container other than the form, add the control to the container's ______ collection. |
|
|
Term
|
Definition
| The names of the two procedures that make up a property definition |
|
|
Term
|
Definition
| VB's two controls that can be used to retrieve data from the Internet |
|
|
Term
| the key, the whole key, and nothing but the key |
|
Definition
| The Golden Rule for third normal form states that every non-key field must depend on _______________________ |
|
|
Term
| hierarchic, hierarchy, abstraction |
|
Definition
| Not only are complex systems ______, but the levels of this ______ represent different levels of ______ , each built upon the other, and each understandable by itself. |
|
|
Term
|
Definition
| For a Car class, would Start be considered a property, method, or event? |
|
|
Term
|
Definition
| is also sometimes called information hiding. |
|
|
Term
|
Definition
| To test to see if an object is of a specific type, you use the ______ statement. |
|
|
Term
|
Definition
| ______ give us the opportunity to fail under controlled conditions. |
|
|
Term
|
Definition
| _______ is the process of deriving a child class from a parent class. |
|
|
Term
| encapsulation, inheritance, polymorphism |
|
Definition
| The three main features of OOP languages are |
|
|
Term
|
Definition
| The task of the software development team is to engineer the __________ |
|
|
Term
|
Definition
| The "has-a" relation maps most naturally to ______ |
|
|
Term
|
Definition
| An _______ defines a class's behaviors, but does not provide an implementation. |
|
|
Term
|
Definition
| Visual Basic does not allow ______ , so a class can have at most one parent class. |
|
|
Term
| is a, part of, class structure, object structure |
|
Definition
| According to the authors, it is essential to view a system from both perspectives, studying its "____" hierarchy as well as its "______" hierarchy. The authors call these hierarchies the _____ and the ______ of the system, respectively. |
|
|
Term
| hierarchic structure, relative primitives, separation of concerns, common patterns, stable intermediate forms |
|
Definition
| The five attributes of a complex system are |
|
|
Term
|
Definition
| Collectively, the class and object structures of a system are referred to as its __________________ |
|
|
Term
|
Definition
| Because we execute our software on digital computers, we have a system with ________ |
|
|
Term
| stable intermediate forms |
|
Definition
| Object-oriented systems are more resilient to change and thus better able to evolve over time because their design is based on ______ ________ ______ |
|
|
Term
|
Definition
| The "is-a" relation maps naturally into ____ |
|
|
Term
|
Definition
| A class's ______ is the set of properties, methods, and events that are visible to code outside of the class. |
|
|
Term
|
Definition
| The more complex the system, the more open it is to _____ |
|
|
Term
|
Definition
| Roughly speaking, _____ means treating one object as another. |
|
|
Term
|
Definition
| This class fills areas with a linear gradient of two or more colors. |
|
|
Term
|
Definition
| The Pen class provides several overloaded _____ |
|
|
Term
|
Definition
| When part of a control must be redrawn, it generates a _____ event. |
|
|
Term
| color, thickness, dash style, join style, end cap style |
|
Definition
| The Pen object determines the lines' _____ _______ _______ ________ ________ |
|
|
Term
|
Definition
| A _____ class fills areas with an image, usually a Bitmap. |
|
|
Term
|
Definition
| A smooth curve guided by a set of four control points is called _______ |
|
|
Term
|
Definition
| ______ makes characters appear smoother. |
|
|
Term
|
Definition
| ____ can produce text rotated at any angle. |
|
|
Term
|
Definition
| A _______ object determines how lines are drawn. |
|
|
Term
|
Definition
| The Graphics object's ________ method returns a SizeF structure holding the string's width and height drawn in a particular font. |
|
|
Term
|
Definition
| This class provides many methods for drawing shapes and filling areas. |
|
|
Term
|
Definition
| The Graphics object's _____ method draws text. |
|
|
Term
|
Definition
| This object determines how areas are filled. |
|
|
Term
|
Definition
| Whenever you draw something in Visual Basic, you must use a _______ object. |
|
|
Term
| solid colors, hatch patterns, color gradients |
|
Definition
| Different types of Brushes fill areas with : |
|
|
Term
|
Definition
| This object fills areas with a color gradient that blends colors from a center point to the points along a path. |
|
|
Term
|
Definition
| In two dimensions, you can represent scaling, translation, and rotation with _______ |
|
|
Term
|
Definition
| The Brush class itself is an ______ or _______ class, so you cannot make instances of the Brush class itself. |
|
|
