Assignment
1. An organization ABC has a computer lab of 40 computers. You must be able to add more computers without any disruptions to the network. The network administrator has to troubleshoot the network frequently. In the given conditions which topology do you think is most suitable among Star, Bus, Ring and Mesh topologies? Give reasons for your answer (10 marks)
2. Create small data base using MS Access. It must have the following tables and fields. Create the relationships between the tables but no need to make forms
(20 marks)
Employee table
- employeeID (primary key)
- employeeName
- Address
- Phone
- Designation
- Homepage (URL)
Order table
- OrderID (primary key)
- employeeID
- CustomerID
- OrderDate
- RequiredDate
- Description
Order Detail
- OrderID
- ProductID
- UnitPrice
- Quantity
Product table
- ProductID (primary key)
- SupplierID
- ProductName
- Quantity
- Unit Price
Customer table
- CustomerID(primary key)
- CustomerName
- Address
- City
- Fax
- Phone
Supplier Table
- SupplierID(primary key)
- SupplierName
- Address
- Fax
- Phone
- Homepage (URL)
The relationship between these tables is shown below.
Hint: Use the relationship tag in the menu bar to link these tables. For Order Detail Table you have to create a third (junction) table because the relationship between product and Order is Many to Many
