Homework

1

BUS 300 - Mashaw, Homework # 12 Name: This is an extra credit HW. Furthermore, it helps you to review the material for Test 3. See the interesting Video about Internet again;

The Dawn of the Net - How the Net works See the 12-13 minutes version (not the short 6 minutes version)

Part I Define, or Explain briefly in your own words What is a Protocol? What is the protocol for a. Getting a webpage? b. Secure webpage? c. Downloading a file? d. Voice telephony? e. Getting the email f. Sending an email g. Who/What assigns an IP, when you turn on you laptop in a LAN?

A protocol is: a. b. c. d. e. f. g.

What do the Routers do? 1. 2. 3.

a. What is new in Internet Protocol, b. What are the trends in Internet

a. b.

Part II. Design a Network for 3 desktops, 3 Laptops, that can have connections to the internet, and a printer that can be shared. Show the design details The physical Topology:

? The physical Topology (Your schematic, the model)

Media used: Devices used (like NICs, Switch, Router, Modem, etc)

? 1. 2. 3. 4.

The Protocols used For your LAN For your Internet

2

Part III Application. 1. Use a few HTML Codes to create a webpage. Your web page should have colored background, title, a banner (a narrow picture), and some content with a couple of pictures, (The instructions and Sample of the HTML codes are posted in Blackboard under AHTMLWebPage.pdf ) Show a. your webpage (you can print it in PDF, or use the sniping tool) b. the Source code (again, print it in PDF, or use the sniping tool) 2. Database Design and Implementation. A member of an on-line discount club can order any product with a discounted prices. We would like to store members names, addresses, phones, their YTD purchases, and product name, code, description, as well as when the order was placed, with which sales person, and the quantity ordered by each Customer. 1. Identify the entities and attributes for each entity (Use a model) 2. Identify the Primary key for each entity 3. Write a dictionary for each entity 4. With your Model, show the Record Relationships (1:1, or 1:m, or m:n) 4. Implement the database use Access. In Access,

a. Show the dictionary and the key for each Table b. Create and Show the Links c. show at least one GUI Query with a condition d. Show at least one SQL Query with a condition e. Show at least one form that you created f. Show at least one Report that you created

Extra Credit (up to 2 points, 1 point if attached to this HW, 2 points if it is emailed to me so that I can show it to other students)

What did you learn in this semester in this course? Were they useful? Write a summary; but, it must contain some details (saying that you learned Access is not enough, say what you learned about Access. Use listing in your summary. (hint: remembering the learning objective for each week, and your notes will be very useful)