PROBLEM1: Databases, Networks, Internet, the Web (Chapters 8 and 9) 15 Points

Consider a medium adult education center with 5 departments, 25 staff members(instructors and support staff), and offers 15 courses in 4 categories (i.e., business, technology, arts/crafts, & Wellness). Based on your study of the (Umar chapters 7 and 8), answer the following simple questions:

Design and provide a conceptual model of a relational database (ER Diagram) that will be used in this center. Provide an overview of the logical and conceptual design of the database. You should outline 5 major database tables to be used by the company, their contents (e.g., table names, list of fields, designate primary and foreign key fields), cardinalities, and interrelationships (ER diagram).

List 10 database queries that the company will use most commonly with these databases. Describe intent of SQL statement in English and then provide a corresponding SQL statement that aligns with your database architecture (ERD).

Draw a sketch of the Network the Education Center with wireless and wired network

Will you consider HTML5 and why

Show a simple technology architecture diagram of the Education Center that displays; provide a detailed narrative for all the computers, infrastructure, firewall, databases, applications and the network for this Center