The server can then attach the session_ID to each form exchanged with the client.
Some application ???frameworks??? provide additional tools. For instance, Microsoft??™s .Net framework
provides a ViewState property for each ???control??? (button, table, etc.) on a web page. The state of
the control (whether the button was pushed, whatever data are shown in the table, etc.) is saved
invisibly in the ViewState property of the control as the web page is passed back and forth
between server and client.
DATABASE
8.1 Consider designing a database for an antique store. What entities would you include? What would their
attributes be?
Entities and attributes:
Item: ID, type, description, cost, sales price, consignment seller
Customer: ID, Name, Phone, Address
ConsignmentSeller: SellerID, Name, Address, Phone, Commission%
Sale: InvoiceNo, Customer, Date
Sale Item: InvoiceNo, ItemID, ItemPrice, Quantity
Etc.
8.2 Create a full E-R diagram for the antique store mentioned in question 1. The store handles household
furnishings, jewelry, toys, and tools. The owner of the store owns most of what he has for sale, but he
handles some items on consignment (i.e., he sells the item for the owner, thus earning a commission on the
sale).
Pages:
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535