home *** CD-ROM | disk | FTP | other *** search
- {
- CreditCard = {
- attributeNames = (
- authorizationDate,
- authorizationNum,
- cardNumber,
- cardType,
- customerID,
- expirationDate,
- limit
- );
- rows = (
- (
- "Jan 24 1996 21:57",
- 1111,
- 1111000011110000,
- Visa,
- 1,
- "Jan 24 1997 00:00",
- 150
- ),
- (
- "Jan 24 1996 22:01",
- 2222,
- 2222000022220000,
- Visa,
- 2,
- "Oct 24 1996 00:00",
- 150
- ),
- (
- "Jan 24 1996 22:05",
- 4444,
- 4444000044440000,
- "Master Card",
- 4,
- "Feb 16 1998 00:00",
- 150
- ),
- (
- "Jan 24 1996 22:03",
- 3333,
- 3333000033330000,
- Visa,
- 5,
- "Jan 01 1998 00:00",
- 150
- ),
- (
- "Jan 24 1996 22:07",
- 5555,
- 5555000055550000,
- "American Express",
- 6,
- "Aug 12 1996 00:00",
- 150
- ),
- (
- "Jan 24 1996 22:08",
- 6666,
- 6666000066660000,
- Visa,
- 7,
- "Jul 11 1996 00:00",
- 150
- ),
- (
- "Jan 24 1996 22:10",
- 7777,
- 7777000077770000,
- "Master Card",
- 8,
- "Mar 04 1998 00:00",
- 150
- ),
- (
- "Jan 24 1996 22:12",
- 8888,
- 8888000088880000,
- Visa,
- 9,
- "Jun 03 1997 00:00",
- 150
- ),
- (
- "Jan 24 1996 22:13",
- 9999,
- 9999000099990000,
- "American Express",
- 10,
- "Jan 24 1999 00:00",
- 150
- ),
- (
- "Jan 24 1996 22:15",
- 0011,
- 0000111100001111,
- Visa,
- 11,
- "Jan 03 1997 00:00",
- 150
- ),
- (
- "Jan 24 1996 22:18",
- 0033,
- 0000333300003333,
- Visa,
- 13,
- "Jan 12 2597 12:00",
- 150
- ),
- (
- "Jan 24 1996 22:19",
- 0044,
- 4444000044440000,
- Visa,
- 14,
- "Nov 05 1999 00:00",
- 150
- ),
- (
- "Jan 24 1996 22:24",
- 0077,
- 7777000077770000,
- Visa,
- 17,
- "May 20 1999 00:00",
- 150
- ),
- (
- "Jan 24 1996 22:08",
- 6666,
- 6666000066660000,
- Visa,
- 16,
- "Jul 11 1996 00:00",
- 150
- ),
- (
- "Jan 24 1996 22:07",
- 5555,
- 5555000055550000,
- "American Express",
- 15,
- "Aug 12 1996 00:00",
- 150
- )
- );
- };
- Customer = {
- attributeNames = (customerID, firstName, lastName);
- rows = (
- (1, William, Anthony),
- (3, Johnny, Boyles),
- (2, Joanne, Boyles),
- (4, Jerry, Drummber),
- (5, Mark, Capra),
- (7, Freddy, Filmore),
- (6, Maria, Eyler),
- (8, Jamie, Grace),
- (9, Craig, Hartnell),
- (10, Richard, Ingle),
- (11, Julia, Jeffers),
- (13, Franklin, Lewis),
- (12, Joe, Kawamoto),
- (14, Lisa, Mathews),
- (15, Elliot, Nunez),
- (16, Paul, Peters),
- (17, Linda, Stark),
- (19, Ralph, Nunez),
- (20, Jane, Nunez),
- (18, Susan, Nunez),
- (21, Sarah, Lewis),
- (23, Bob, Jeffers),
- (22, John, Jeffers),
- (24, Frieda, Stephano),
- (25, Susan, Myers),
- (27, Eric, Grace),
- (26, Dan, Grace),
- (28, Bruce, Grace),
- );
- };
- Fee = {
- attributeNames = (amount, datePaid, feeID, feeTypeID, rentalID);
- rows = (
- (14.99, "Jan 22 1996 18:28", 4, 1, 4),
- (2.99, "Jan 24 1996 19:08", 5, 1, 5),
- (4.99, "Jan 24 1996 19:08", 6, 1, 6),
- (2.99, "Jan 24 1996 19:08", 7, 1, 7),
- (4.99, "Jan 24 1996 23:39", 8, 1, 8)
- );
- };
- FeeType = {
- attributeNames = (feeType, feeTypeID);
- rows = ((Rent, 1), (Late, 2));
- };
- GameMedia = {
- attributeNames = (name, platform, productID, rentalTermsID);
- rows = (
- ("Donkey Kong County", SNES, 3, 11),
- (WipeOut, PlayStation, 11, 11),
- ("Road Rash II", "Sega Genesis", 13, 11),
- ("Super Mario Kart", SNES, 29, 11)
- );
- };
- GamePlayer = {
- attributeNames = (name, productID, rentalTermsID);
- rows = ((SNES, 4, 10), ("Sony PlayStation", 6, 14), ("Sega Genesis", 25, 10));
- };
- Guest = {
- attributeNames = (costRestriction, customerID, memberID);
- rows = (
- (30, 3, 2),
- (30, 20, 15),
- (30, 19, 15),
- (50, 18, 15),
- (150, 21, 13),
- (150, 23, 11),
- (50, 22, 11),
- (75, 24, 10),
- (25, 25, 2),
- (150, 27, 8),
- (150, 28, 8),
- (150, 26, 8)
- );
- };
- LaserDisc = {
- attributeNames = (media, movieID, productID, rentalTermsID);
- rows = (
- (D, 126, 9, 13),
- (D, 171, 42, 13),
- (D, 166, 33, 1),
- (D, 192, 46, 13),
- (D, 200, 52, 13)
- );
- };
- Member = {
- attributeNames = (
- cardNumber,
- cardType,
- city,
- customerID,
- memberSince,
- phone,
- state,
- streetAddress,
- zip
- );
- rows = (
- (
- 1111000011110000,
- Visa,
- "San Francisco",
- 1,
- "Jan 24 1996 21:55",
- 4155552525,
- CA,
- "200 Arroyo Drive",
- 94567
- ),
- (
- 2222000022220000,
- Visa,
- "Menlo Park",
- 2,
- "Jan 24 1996 22:00",
- 4155553636,
- CA,
- "29 Timber Creek Drive",
- 93211
- ),
- (
- 3333000033330000,
- Visa,
- "San Bruno",
- 5,
- "Jan 24 1996 22:02",
- 4155558787,
- CA,
- "2777 North Capitol #26",
- 98564
- ),
- (
- 4444000044440000,
- "Master Card",
- "San Francisco",
- 4,
- "Jan 24 1996 22:04",
- 4155558989,
- CA,
- "59 Fowler St.",
- 96857
- ),
- (
- 6666000066660000,
- Visa,
- "San Francisco",
- 7,
- "Jan 24 1996 22:07",
- 4155552426,
- CA,
- "39 Geary St.",
- 96321
- ),
- (
- 5555000055550000,
- "American Express",
- "San Bruno",
- 6,
- "Jan 24 1996 22:06",
- 4155557171,
- CA,
- "150 Saratoga St.",
- 99874
- ),
- (
- 7777000077770000,
- "Master Card",
- Woodside,
- 8,
- "Jan 24 1996 22:09",
- 4155556687,
- CA,
- "555 Custer Ave.",
- 97485
- ),
- (
- 8888000088880000,
- Visa,
- "San Mateo",
- 9,
- "Jan 24 1996 22:11",
- 4155559817,
- CA,
- "67 Lazy River Way",
- 91586
- ),
- (
- 9999000099990000,
- "American Express",
- Hillsborough,
- 10,
- "Jan 24 1996 22:12",
- 4155557428,
- CA,
- "356 Sedgewood",
- 96487
- ),
- (
- 0000111100001111,
- Visa,
- "San Francisco",
- 11,
- "Jan 24 1996 22:14",
- 4155558875,
- CA,
- "260 Forbes Lane",
- 98612
- ),
- (
- 0000333300003333,
- Visa,
- "San Mateo",
- 13,
- "Jan 24 1996 22:17",
- 4155556644,
- CA,
- "44 Desertwood Circle",
- 97578
- ),
- (
- __NULL__,
- __NULL__,
- "San Mateo",
- 12,
- "Jan 24 1996 22:15",
- 4155552124,
- CA,
- "3939 Alice Drive",
- 93597
- ),
- (
- 4444000044440000,
- Visa,
- "Palo Alto",
- 14,
- "Jan 24 1996 22:18",
- 4155554849,
- CA,
- "1 Main Street",
- 94848
- ),
- (
- 5555000055550000,
- "American Express",
- "San Francisco",
- 15,
- "Jan 24 1996 22:20",
- 4155552581,
- CA,
- "100 Union St.",
- 98787
- ),
- (
- 6666000066660000,
- Visa,
- Woodside,
- 16,
- "Jan 24 1996 22:22",
- 4155554789,
- CA,
- "685 Almaden Road",
- 98758
- ),
- (
- 7777000077770000,
- Visa,
- "Menlo Park",
- 17,
- "Jan 24 1996 22:23",
- 4155553374,
- CA,
- "108 Melrose Ave",
- 93588
- )
- );
- };
- Rental = {
- attributeNames = (customerID, dateOut, dateReturned, rentalID, unitID);
- rows = (
- (16, "Jan 22 1996 18:26", __NULL__, 4, 3),
- (23, "Jan 24 1996 19:08", __NULL__, 7, 110),
- (23, "Jan 24 1996 19:07", __NULL__, 5, 115),
- (23, "Jan 24 1996 19:07", __NULL__, 6, 43),
- (22, "Jan 24 1996 23:39", __NULL__, 8, 46)
- );
- };
- RentalTerms = {
- attributeNames = (checkOutLength, cost, depositAmount, name, rentalTermID);
- rows = (
- (2, 3.99, 20, "New release", 1),
- (2, 14.99, 200, "16 Bits game console", 10),
- (3, 4.99, 50, "Video games", 11),
- (5, 2.99, 20, Economy, 13),
- (3, 19.99, 300, "32 Bits game console", 14)
- );
- };
- Unit = {
- attributeNames = (dateAcquired, notes, productID, unitID);
- rows = (
- ("Jan 04 1996 12:00", "Only one pad", 4, 3),
- ("Jan 08 1996 18:10", __NULL__, 29, 75),
- ("Jan 08 1996 18:10", __NULL__, 29, 76),
- ("Jan 04 1996 12:00", "", 3, 22),
- ("Jan 04 1996 12:00", "Two pads", 4, 23),
- ("Jan 04 1996 12:00", "The documentation is missing", 3, 25),
- ("Jan 04 1996 12:00", "", 3, 24),
- ("Jan 08 1996 18:10", __NULL__, 29, 74),
- ("Jan 11 1996 01:25", __NULL__, 38, 93),
- ("Jan 11 1996 01:29", "slightly warped", 43, 94),
- ("Jan 08 1996 18:47", __NULL__, 32, 82),
- ("Jan 08 1996 18:47", __NULL__, 32, 83),
- ("Jan 05 1996 12:00", __NULL__, 1, 27),
- ("Jan 05 1996 12:00", __NULL__, 1, 28),
- ("Jan 05 1996 12:00", __NULL__, 1, 29),
- ("Jan 05 1996 12:00", __NULL__, 1, 26),
- ("Jan 05 1996 12:00", __NULL__, 6, 33),
- ("Jan 05 1996 12:00", __NULL__, 6, 34),
- ("Jan 05 1996 12:00", __NULL__, 6, 32),
- ("Jan 05 1996 12:00", __NULL__, 7, 35),
- ("Jan 05 1996 12:00", __NULL__, 7, 36),
- ("Jan 05 1996 12:00", __NULL__, 8, 37),
- ("Jan 05 1996 12:00", "Case cracked", 9, 38),
- ("Jan 06 1996 12:00", __NULL__, 11, 43),
- ("Jan 06 1996 12:00", __NULL__, 11, 44),
- ("Jan 06 1996 12:00", __NULL__, 11, 42),
- ("Jan 06 1996 12:00", __NULL__, 13, 46),
- ("Jan 06 1995 12:00", __NULL__, 14, 47),
- ("Jan 06 1990 12:00", __NULL__, 15, 48),
- ("Jan 06 1991 12:00", __NULL__, 16, 50),
- ("Jan 06 1992 12:00", __NULL__, 16, 49),
- ("Jan 06 1982 12:00", __NULL__, 17, 54),
- ("Jan 06 1995 12:00", __NULL__, 18, 53),
- ("Jan 06 1982 12:00", __NULL__, 17, 52),
- ("Jan 06 1994 12:00", __NULL__, 18, 51),
- ("Jan 06 1991 12:00", __NULL__, 19, 57),
- ("Jan 06 1991 12:00", __NULL__, 19, 56),
- ("Jan 06 1991 12:00", __NULL__, 19, 55),
- ("Jan 06 1981 12:00", __NULL__, 20, 61),
- ("Jan 06 1981 12:00", __NULL__, 20, 60),
- ("Jan 06 1981 12:00", __NULL__, 20, 58),
- ("Jan 06 1981 12:00", __NULL__, 20, 59),
- ("Jan 06 1989 12:00", __NULL__, 21, 62),
- ("Jan 06 1979 12:00", __NULL__, 24, 63),
- ("Jan 06 1995 12:00", __NULL__, 25, 64),
- ("Jan 08 1996 18:47", __NULL__, 32, 81),
- ("Jan 08 1996 18:51", __NULL__, 25, 84),
- ("Jan 08 1996 19:40", "slightly warped", 33, 85),
- ("Jan 08 1996 19:40", __NULL__, 33, 86),
- ("Jan 08 1996 19:40", "customer complaint of \"snow\" on tape", 33, 87),
- ("Jan 10 1996 22:53", __NULL__, 35, 91),
- ("Jan 10 1996 22:48", __NULL__, 14, 88),
- ("Jan 10 1996 22:53", __NULL__, 35, 90),
- ("Jan 11 1996 01:29", __NULL__, 43, 97),
- ("Jan 11 1996 01:30", __NULL__, 40, 99),
- ("Jan 11 1996 01:32", __NULL__, 42, 98),
- ("Jan 11 1996 01:33", __NULL__, 41, 96),
- ("Jan 11 1996 01:31", __NULL__, 39, 95),
- ("Jan 11 1996 01:32", "needs to be replaced", 44, 92),
- ("Jan 11 1996 01:37", "needs to be cleaned", 45, 117),
- ("Jan 11 1996 01:38", __NULL__, 49, 118),
- ("Jan 11 1996 01:38", __NULL__, 46, 116),
- ("Jan 11 1996 01:38", __NULL__, 49, 114),
- ("Jan 11 1996 01:43", __NULL__, 51, 115),
- ("Jan 11 1996 01:40", "slightly damaged", 47, 113),
- ("Jan 11 1996 01:39", __NULL__, 54, 109),
- ("Jan 11 1996 01:43", __NULL__, 51, 112),
- ("Jan 11 1996 01:40", __NULL__, 47, 110),
- ("Jan 11 1996 01:34", __NULL__, 52, 111),
- ("Jan 11 1996 01:39", "needs to be cleaned", 54, 106),
- ("Jan 11 1996 01:35", __NULL__, 53, 108),
- ("Jan 11 1996 01:38", "cover is stained", 49, 105),
- ("Jan 11 1996 01:39", __NULL__, 54, 107),
- ("Jan 11 1996 01:38", __NULL__, 49, 103),
- ("Jan 11 1996 01:41", "needs to be replaced", 50, 104),
- ("Jan 11 1996 01:40", __NULL__, 48, 100),
- ("Jan 11 1996 01:39", __NULL__, 54, 101),
- ("Jan 11 1996 01:38", __NULL__, 49, 102),
- ("Jan 12 1996 23:04", "torn cover", 55, 119),
- ("Jan 12 1996 23:04", __NULL__, 55, 120),
- ("Jan 15 1996 13:22", __NULL__, 24, 121),
- ("Jan 15 1996 19:09", __NULL__, 64, 123),
- ("Jan 15 1996 19:09", __NULL__, 64, 122),
- ("Jan 17 1996 13:46", __NULL__, 24, 124),
- ("Jan 20 1996 16:35", __NULL__, 24, 125)
- );
- };
- VideoTape = {
- attributeNames = (media, movieID, productID, rentalTermsID);
- rows = (
- (T, 121, 1, 13),
- (T, 120, 7, 13),
- (T, 118, 8, 13),
- (T, 158, 14, 1),
- (T, 128, 15, 13),
- (T, 131, 16, 13),
- (T, 115, 17, 13),
- (T, 132, 18, 13),
- (T, 142, 19, 13),
- (T, 198, 20, 13),
- (T, 144, 21, 13),
- (T, 159, 24, 13),
- (T, 102, 32, 1),
- (T, 114, 35, 13),
- (T, 146, 43, 13),
- (T, 175, 44, 1),
- (T, 171, 41, 13),
- (T, 186, 39, 13),
- (T, 190, 40, 13),
- (T, 179, 38, 13),
- (T, 169, 54, 1),
- (T, 180, 51, 13),
- (T, 203, 53, 13),
- (T, 162, 50, 13),
- (T, 164, 49, 1),
- (T, 185, 48, 13),
- (T, 187, 47, 13),
- (T, 188, 45, 13),
- (T, 135, 55, 13),
- (T, 111, 64, 1)
- );
- };
- }
-