Assignment:
1. An animal clinic keeps the records on the pets information in the spread sheet with the column headings: PetName, PetType, PetDOB, OwnerLastName, OwnerFirstName, Phone, Address, ServiceDescription, ServiceDate, Charge.
a. The clinic can keep the records in this way on the spreadsheet, but they will soon find inconveniences in handling the pets information. What kind of problems or issues may occur if they keep recording in this way? Think in terms of data entry, updating data, or deleting data.
b. To avoid the above problems, the pets information may need to be kept in separate "tables" in the Microsoft Access terms. How the tables should be set up to keep the pets information? You can write the table name and its contents such as TableName(fieldname1, fieldname2, etc).
c. For the tables you set up in b, assign or add appropriate primary keys and foreign keys for each table. Some table wouldn't need a foreign key. The primary key should be underlined, and foreign key in italic such as TableName(primarykeyname, fieldname1, fieldname2, foreignkeyname, etc).
2. Answer the following questions regarding how an email message from a computer can reach to a remote computer over the Internet.
a. An email message can be very long if it contains picture images. To reach the destination computer, how this email message is converted into some other entities?
b. What are the benefits of converting the original message into the different format?
c. Describe the roles of Network Interface Card (NIC), switches, and the routers in telecommunications? What is the difference between a switch and a router?
d. What does the network server (NOS) do to help the source message in finding the pathway to reach the Internet.
3. What will be generally good technical and/or non-technical practices or arrangements to protect an organizarion's information system from security breaches?
4. How the Fuzzy Logic for Temparature Control would work better than the ON-OFF switching method in controlling the thermostat?
5. The US Army has planned to develop an intelligent warfighting capability by providing continuous wireless communication capability to update the current battle situtaion and to deliver directions to the warfighters in realtime. In the consideration of its importance, the Army started as a huge sized program that contains numerous projects from tank redesign, communication equipment development, logistics system, to training all at once. The necessary technologies of the combined wireless communications are yet to be developed. Software development was not easy to define.
a. In this case, what kind of problems or risks would arise as the program proceeds?
b. As the whole program is not progressing as expected, the Army determined to cancel the Program. If the program is stopped, all previous efforts might be lost. To salvage the previous works and continuously pursue the development goal, the Army plans to contnue in a much smaller scale project. If you are in the project management team, describe how the team would develop the project management strategies.
Attachment:- Databases and Information Management.rar