O-Tech Computer Shop TEAM 4 Jorge Ortiz, Karl King, and Dan Ehlers Friday, December 03, 2010
Foreign keys: None Primary key: PRODUCTTYPE Not null: PRODUCTTYPE The above diagram illustrates the schema of the Products table. This table holds
Order(CUSTOMERID, ORDERID, MOTHEROARD, OS, CPU, RAM, VIDEOCARD, HD1, HD2, HD3, HD4, USB3, SATA, FIREWIRE, BLUETOOTH, KEYBOARDTYPE, ODD1, ODD2, OPERAT
The last of the three tables is the Members table. This table holds all of the information needed about a user of the system. In order for a user
ID FIRSTNAME LASTNAME ADDRESS CITY STATE ZIPCODE [email protected]. Box 808, 3895 Phasellus AvenueHuntington ParkKS94255sit
Figure 4: The diagram above depicts the relationship between the three tables. Database Queries 1) From customers.cs file, the following SQL inser
"INSERT INTO Orders" + " (CUSTOMERID, ORDERID, MOTHERBOARD, OS, CPU, RAM, VIDEOCARD, HD1, HD2, HD3, HD4, USB3, SATA,
6) From editOrder.aspx.cs file, the following SQL statement is used to get all the orders by customer ID: "SELECT * " + "FROM Orders
b) rand.c This program generates random orders number for the ORDER table. It can generate a specific number of orders numbers and the amo
In this screenshot show how the program is compiled using the gcc compiler. This screenshot shows how to run the program after it is compil
After entering the number of digits for the order id the program will ask to the user the amount of order of ids to generate. This screenshot s
Overview As Group 4, we felt responsible to do our absolute best to uphold the reputation of the prestigious group number that previous semester’s
Other Issues: Since this program currently runs on a local machine, it must be loaded and run in Microsoft Visual Studio (minimum version of 2008).
Client Functionality As previously stated, this website was designed to be an all-purpose custom computer website for which all aspects of the busi
Products table. Once the user selects a specific item from a dropdown menu, the item’s price is displayed in a box to the left. This is shown in the
Once the user is satisfied with their order, they can submit the order by clicking the “Submit Order” button (shown above). Once clicked, the order i
Operator Control Center page (pictured below) which shows the different options for which they have access to. Therefore, the privileges of the
Since managers need to do various tasks throughout the day such as add new employees, update user information, or edit an existing order, they ha
After the manager select one of the user ids for the drop list the program will populate each text box with the information related with that user.
Database Design and Tables: a) Products: Figure 1: Products Schema Products(PRODUCTTYPE, MODEL, PRICE, IMAGE);
Commentaires sur ces manuels