PROBLEM1: Databases, Networks, Internet, the Web (Chapters 8 and 9)
Consider a small training center (3 rooms, 10 staff members) that offers basic educational
services to small & medium organizations. Your task is to do the following:
• Develop a conceptual model of databases that will be used in this center. You should list 3
major database tables to be used by the company, their contents (e.g., list of fields) and
interrelationships (ER diagram).
• List 3 database queries (in English) that the company will use most commonly with these
databases. Then translate the queries into SQL.
• Draw a sketch of the Network of the Center with wireless and wired capabilities
• Show a simple technology architecture diagram of the Center that displays all the computers,
databases, applications and the network for this Center
• How would you extend this database into a Knowledgebase?