All of the work in this project is my own!  I have not left copies of my code in public folders on university computers. I have not given any of this project to others. I will not give any portion of this project to others taking this class. I realize that the penalty for turning in work that is not my own can range from an "F" in the class to dismissal from Trinity University. 

                                                                                             Print Name  __________________________

                                                                                              Signature   __________________________

Structure for table: C:\Video\VIDEO.DBF
Number of data records: 0
Date of last update: 01/1/98
Memo file block size: 64
Code Page: 1252
Field Field Name   Type       Width Dec Index Collate Nulls

 1    NAME         Character     26                   No
 2    NO           Numeric        4                   No
 3    NOMIN        Numeric        3                   No
 4    VENDOR       Character     16                   No
 5    DRAMMA       Logical        1                   No
 6    MYSTERY      Logical        1                   No
 7    COMEDY       Logical        1                   No
 8    HORROR       Logical        1                   No
 9    RATING       Numeric        2                   No
10    NOTES        Memo           4                   No
** Total **                      60

-------------------------------------- Use the Video.DBF structure above for all questions! --------------------------------------

1] ____________ (T/F) Layout and structure are synonymous.

2] What is the read/write pointer? ___________________________________________________________

3] What record is the current record? ________________________________________________________

4] _________ (T/F) Database applications should always be created inside a directory/folder.

5] FoxPro database tables have _____________ as an extension.

6] Let us suppose that a database application has been developed in a directory called Video1 on the disk in the right drive. How can one make this folder the default directory?

_______________________________________________________________________________________

7] The default directory has been set to Video1 (right drive). Inside is a database file, called Video.DBF. How can one open this database?

_______________________________________________________________________________________

8] ______ (T/F) The command Use automatically closes any databases open in the current work area.

11] How does one display the output from the calculation 2 * 3 - 4 * 6 / 3 on the current window? What would be displayed?

_______________________________________________________________________________________

12] How does one display the output from the calculation 2 ^ 3 + 2 - 4 on the current window? What would be displayed?

_______________________________________________________________________________________

13] How does one display the output from the calculation 2 ^ 3 ^ 2 on the current window? What would be displayed? What do you think about this?

_______________________________________________________________________________________

14] How does one display the number of the current record pointer on the current window? ____________

15] How does one display the number of the records in the file on the current window? ________________

16] How does one display the number of the size of one record on the current window? _______________

17] How does one move the read/write pointer to first record? ____________________________________

18] How does one move the read/write pointer to last record? ____________________________________

19] How does one move the read/write pointer to record 123? ____________________________________

20] How does one move the read/write pointer to the next record? ________________________________

21] How does one move the read/write pointer to the previous record? _____________________________

22] How does one move the read/write pointer forward 3 records? _________________________________

23] How does one move the read/write pointer backward 3 records? _______________________________

24] How can you get all of the records in the database to appear on the screen. (no pause)

_______________________________________________________________________________________

25] ____________ (T/F) The list command displays all of the information from the current record to the end of the file. The read/write pointer is repositioned back to the current record. There is no pause in output.

26] ____________ (T/F) The list command displays all of the information from the current record to the end of the file. The read/write pointer remains at the end of the file. There is no pause in output.

27] ____________ (T/F) The list command displays all of the information from the current record to the end of the file. The read/write pointer is repositioned at the first record. There is no pause in output.

28] ____________ (T/F) The list command displays all of the information from the first record to the last record the file. The read/write pointer is repositioned back to the current record. There is no pause in output.

29] ____________ (T/F) The list command displays all of the information from the first record to the last record the file. The read/write pointer remains at the end of the file. There is no pause in output.

30] ____________ (T/F) The list command displays all of the information from the first record to the last record the file. The read/write pointer is repositioned at the first record. There is no pause in output.

31] ____________ (T/F) The list command displays all of the information from the current record. The read/write pointer is unchanged. There is no pause in output.

32] How can you display all of the information in all of the video records that are rated 10 on the screen. (no pause)

_______________________________________________________________________________________

33] How can you display the name, minutes in length, and number of all videos that are rated 10 on the screen. (no pause)

_______________________________________________________________________________________

34] How can you display all of the information in all of the video records that are rated 7 or more on the screen. (no pause)

_______________________________________________________________________________________

35] How can you display the name, minutes in length, and number of all videos that are rated 7 or more on the screen. (no pause)

_______________________________________________________________________________________

36] How can you display all of the information in all of the video records that are Mysteries on the screen. (no pause)

_______________________________________________________________________________________

37] How can you display the name, minutes in length, and number of all videos that are Mysteries on the screen. (no pause)

______________________________________________________________________________________

38] How can you print all of the information in all of the video records. (no pause)

_______________________________________________________________________________________

39] How can you print the name, minutes in length, and number of all videos. (no pause)

_______________________________________________________________________________________

40] How can you print all of the information in all of the video records that are rated 10. (no pause)

_______________________________________________________________________________________

41] How can you print the name, minutes in length, and number of all videos that are rated 10. (no pause)

_______________________________________________________________________________________

42] How can you print all of the information in all of the video records that are rated 7 or more. (no pause)

_______________________________________________________________________________________

43] How can you print the name, minutes in length, and number of all videos that are rated 7 or more. (no pause)

_______________________________________________________________________________________

44] How can you print all of the information in all of the video records that are Mysteries. (no pause)

_______________________________________________________________________________________

45] ____________ (T/F) The list command displays all of the information from the current record. The read/write pointer is unchanged.

46] ____________ (T/F) The display command displays all of the information from the current record. The read/write pointer is unchanged. There is a pause in output.

47] ____________ (T/F) The display all command displays all of the information from the current record to the end of the file. The read/write pointer is repositioned back to the current record. There is a pause in output.

48] ____________ (T/F) The display all command displays all of the information from the current record to the end of the file. The read/write pointer remains at the end of the file. There is a pause in output.

49] ____________ (T/F) The display all command displays all of the information from the current record to the end of the file. The read/write pointer is repositioned at the first record. There is a pause in output.

50] ____________ (T/F) The display all command displays all of the information from the first record to the last record the file. The read/write pointer is repositioned back to the current record. There is a pause in output.

51] ____________ (T/F) The display all command displays all of the information from the first record to the last record the file. The read/write pointer remains at the end of the file. There is a pause in output.

52] ____________ (T/F) The display all command displays all of the information from the first record to the last record the file. The read/write pointer is repositioned at the first record. There is a pause in output.

53] How does one add a record to the current database? _______________________________________

54] _________ (T/F) The command, USE VIDEO, attempts to open a database file, called Video.DBF, in the default directory.

55] Where is the read write pointer when an existing database has been opened? __________________

56] _________ (T/F) Only one database file can be open in each work area.

57] ____________ (T/F) Once the database has been created, it is quite difficult to add a field.

58] ____________ (T/F) Once the database has been created, it is quite simple to change the field size.

59] ____________ (T/F) Once the database has been created, it is quite difficult to reorder the fields.

60] How does one add the date field, CHECKOUT, to the open database? ( step by step)

_______________________________________________________________________________________

_______________________________________________________________________________________

61] How does one add the Name field of the open database 30 characters wide? ( step by step)

_______________________________________________________________________________________

_______________________________________________________________________________________

62] How can you write to a file, called Data1, the name, minutes in length, and number of all videos. (no pause)

_______________________________________________________________________________________

63] How can you write to a file, called Data1, all of the information in all of the video records that are rated 10. (no pause)

_______________________________________________________________________________________

64] How can you write to a file, called Data1, the name, minutes in length, and number of all videos that are rated 10. (no pause) _______________________________________________________________________________________

65] How can you write to a file, called Data1, all of the information in all of the video records that are rated 7 or more. (no pause) _______________________________________________________________________________________

66] How can you print the name, minutes in length, and number of all videos that are rated 7 or more. (no pause)

_______________________________________________________________________________________

67] How can you write to a file, called Data1, all of the information in all of the video records that are Mysteries. (no pause)

_______________________________________________________________________________________

68] When display to file or list to file is executed, the default file extension is ______________________

69] How can you browse the name, minutes in length, and number of all videos. (no pause)

_______________________________________________________________________________________

70] How can you browse all of the information in all of the video records that are rated 10. (no pause)

_______________________________________________________________________________________

71] How can you browse the name, minutes in length, and number of all videos that are rated 10. (no pause)

_______________________________________________________________________________________

72] How can you browse all of the information in all of the video records that are rated 7 or more. (no pause)

_______________________________________________________________________________________

73] How can you browse the name, minutes in length, and number of all videos that are rated 7 or more. (no pause)

_______________________________________________________________________________________

74] How can you browse all of the information in all of the video records that are Mysteries. (no pause)

_______________________________________________________________________________________

75] How can you get a display of all of the database names (and number of records, last update, and size) in the default directory?

_______________________________________________________________________________________

76] How can you tag the current record for deletion? ___________________________________________

77] How can you tag record 8 for deletion? ___________________________________________________

78] How can you tag all of the Mysteries for deletion? __________________________________________

79] How can you tag all of the Mysteries and Horror films for deletion? ____________________________

80] How can you tag all of the records for deletion? ____________________________________________

81] How can you remove the deletion tag from the current record? ________________________________

82] How can you remove the deletion tag from record 8? ________________________________________

83] How can you remove the deletion tag from all of the Mysteries? _______________________________

84] How can you remove the deletion tag from all of the Mysteries and Horror films for deletion?

_______________________________________________________________________________________

85] How can you remove the deletion tag from all records? ______________________________________

86] How can you permanently remove all records tagged for deletion? _____________________________

87] How can you permanently remove all records? ____________________________________________

88] _________ (T/F) Records tagged for deletion never appear in listings.

89] _________ (T/F) Records tagged for deletion never appear in browser.

90] _________ (T/F) When a record is tagged for deletion, it may never be recovered.

91] In the FoxPro status bar above, the name of the database open in the active work area is 

_______________________________________________________________________________________

92] In the FoxPro status bar above, the path to the current directory is  ___________________________

93] In the FoxPro status bar above, this database has _______________ records.

94] In the FoxPro status bar above, the read/write pointer  is  pointing to record #  __________________

95] In the FoxPro status bar above, the database has been opened {shared/exclusive} ______________

96] Those Labs labeled "Individual Assignment" are to be done separately by each individual. Using a pen,  each individual is to print print his/her name at the top of this document in the space provided and sign it.  Those Labs labeled "Team Assignment" may be done as a team or individually. Using a pen,  each individual on the team is to print print his/her name at the top of this document in the space provided and sign it. Submit only one copy of team assignments!

1] This assignment sheet. Print name and sign with Ink! All problems solved in pencil or ink - not electronic!