PROBLEM$1$: 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?

PROBLEM $2$: AI and Computer Aided Planning $($Ch$.10$ and $11)$

What is AI and how does it differ from human intelligence

What are the $4$ key elements of a Practioners View of AI presented in this chapter

Show a simple table that displays the Smart techniques used to support the KDAL $($knowledge$,$ detection, adjustment and learning$)$ capabilities of Microsoft Word and Powerpoint. Indicate if they are Low, Medium, or High at Present.

What exactly is an Expert System. Surf the Net and find $5$ examples of Expert Systems that you like $(2-3$ lines per expert system$)$

Suppose you want to convert the clerical Center descried in Problem $1$ to a Smart Center. List the $4$ steps you will use for this conversion.

What are the main differences between Apple Siri and IBM Watson

Based on what you have learned from the text and hands$-$on experiments, list about $10$ main features a really smart planner will have and what type of AI techniques, discussed in classroom$/$chapter $10,$ will be used by the smart planner.

Please try to represent the KDAL features of an autonomous vehicle in terms of the $8$ dimensional technology model.

PROBLEM$3$: Security $($Chapter $12)$

What type of requirements drive a security solution?

What are the main management issues in developing a sound security system?

What is cryptography and what are the key differences between the symmetric and asymmetric key cryptography?

What will be the security technologies used in the Center introduced in Problem $1($list about $5)$

PROBLEM $4$: Hands$-$On Experiments and a Final Strategic Plan

Please visit the SPACE eFactory $($www$.$space$4$ict.com$)$ and Click on eFactory $($Red Button on Home Page$).$ Then conduct the following experiments:

Please take a tour of Scenario $0,1$ and $2$ and just note what value each scenario provides in formation of a center similar to the one described in Problem$1($One Page$).$ Does the Smart Editor provide any added value?

Please goto Scenario$3$ and invoke the ePlanner. Go to ePlanner Learning Corner and review the video clips and documents in Stage$1$ to develop a good understanding of the ePlanner

Use the ePlanner to develop a simple plan for a service that is of interest to the Problem$1$ center $($or to you$).$ IMPORTANT: Note your login id and the scenario$-$name that you generated so that we can review it$.$ You will lose $15$ points if we do not find this information.

Do you think that ePlanner is smart. Please suggest how you can make it Smarter by using ChatGPT.