In: Computer Science
Choose one (1) and only one of the following three 3
assignment options. Investigate and document your response. Provide
your response back in this document, and SUBMIT it back using
Google Classroom once completed.
Alternative Options list:
1. Information Systems roles and jobs
2. Personal Use of Technology
3. Database creation
Details are provided below:
1. Information Systems roles and jobs:
Prepare a report on purchasing a computer for yourself.
Identify your requirements (what you will need to use it for, how much you would spend, etc.).
Identify at least 3 viable options (actual computers), 2 of them of the same type (e.g. PC) and 1 of them different type (e.g. Apple).
List the specifications for each in a side-by-side table, including:
Hardware specifications (processor, memory, storage,
etc.), 1 row for each category item
Software specifications (OS, application software,
etc.) 1 row for each category item
Networking specifications
Total cost
Identify which would be the most powerful, which would be the
fastest.
Select your best alternative.
Confirm that it will meet all your requirements, and
indicate why you would choose it.
Provide response on table format. Provide final selection and explanation in paragraph format.
1-3 pages max.
2. Personal Use of Technology:
Create a list of at least 4 examples of technologies used by you within the last 2 months.
For each:
Classify them by IT Component types
Research and identify approximately what year each
technology was introduced, and when your specific version was
introduced.
Indicate how you have used the
technology.
Indicate what your next-best alternate would have been
if you did not have the technology. Estimate the associated impact
to you if you did not have the technology (additional time, cost to
you per day/week etc.)
Indicate 1 example of something you currently do
manually (and that there currently is not a technology solution
available yet). Investigate if anyone in the world is already
innovating and working on it, and if so, provide a reference (name
and link) and some details.
Response should be in table form, 1-3 pages
max.
3. Database Creation:
Create a database project with the following requirements, use any professional principles and standards.
Use any relational database software application of your choice to develop database implementing the logical design into a physical design.
create the normalized physical database with tables, columns with data types, primary keys, constraints, etc.
Create a minimum of ten rows of test data in each table.
Submit a Zip .sql file with the scripts needed to create your tables with keys and the insert test rows, etc., into the tables and submit the Assignment Files tab as Zip.
Information Systems roles and jobs
Requirements:
According to my usage and budget, I would like to have a system with latest units installed in it. I would prefer Windows Operating System (the latest version), with a fine desktop, would prefer a curve display for an attractive look.
I would get a system with a Solid State Drive (SSD) for the operating system, and a standard platter-based mechanical hard drive for data and for storing Virtual Hard Drives (VHDs), and would prefer to have virtual machine software applications in order to try out different OS environments( such as Linux, Kali Linux etc).
I would prefer to have a large capacity external hard drive with as fast a USB connection for data backup.
I would consider having NVIDIA GEOFORCE graphic card for better gaming and video experience as an entertainment purpose.
Hardware specifications:
· LED Monitor
· Lighting Keyboard
· Wireless Mouse
· Speaker
· RAM
· External Storage
· Printer
· CPU
Software Specifications:
· Processor: AMD Ryzen 9 3950X
· RAM : 16GB
· Harddrive space: 1 TB
· Graphics card: GeoForce 256
Networking specifications:
|
|
Access points are transmitters/receivers (transceivers) that connect to a network through an interface, such as a bus or connector. They receive, store, and transmit data between the wireless local-area network (WLAN) and the wired structure. End-users access the network through WLAN adapters, which are also equipped with transceiver capabilities. |
|
|
Analog-to-Wireless Converter |
|
Analog-to-wireless converters allow legacy equipment with built-in analog modems to connect to the cellular data networks by emulating the traditional dial-up PSTN network. |
|
Bridge |
|
Network bridges interconnect local or remote networks. They centralize network administration by forming a single logical network. Bridges operate at the physical and link layers of the open systems interconnection (OSI) reference model. |
|
Extender / Repeater |
|
Network repeaters are 802.3 network cable segments. Regeneration and retiming ensure that the signal is transmitted clearly through all segments. |
|
Firewall |
|
Network firewalls are a system or group of systems that, for purposes of security, enforce an access control policy between an organization's network and the Internet. |
|
Hub |
|
Network hubs provide a central location for attaching wires to workstations. They can be passive or active. Passive hubs do not amplify signals. Active hubs are used like repeaters to extend the cable that connects to a workstation. |
|
IP Phone |
|
IP phones use telephony technology to transmit calls over an IP network. IP phones can transmit audio as well as video over the network, allowing organizations to communicate easily. |
|
Modem |
|
Network modems enable computers to transmit data over analog wires or digital lines. They are used to connect to the Internet and to local or wide area networks (LANs and WANs), where users can access and share computing resources. |
|
Router |
|
Network routers are protocol-dependent devices that connect sub-networks. Although they can separate a very large network into smaller sub-networks, routers introduce longer delays and typically have much lower throughput rates than network bridges. Routers operate at the Layer 3 network layer. |
|
Gateway |
|
Network gateways are devices that can interconnect networks with different, incompatible communications protocols. They perform a Layer-7 protocol-conversion to translate one set of protocols into another (for example, from TCP/IP to SNA or from TCP/IP to X.25). Gateways operate at OSI layers up through the session layer. |
|
Multiplexer |
|
Network multiplexers are telecommunications devices that funnel multiple signals onto a single channel. |
|
Power Line Network Adapter |
|
Power line network adapters use existing electrical power lines as carriers for data communications signals. They typically have lower bandwidths compared to networks that use dedicated fiber optic or twisted pair carriers. |
|
Switch |
|
Network switches connect network devices to host computers. They allow a large number of devices to share a limited number of ports. Network switches are used both in computer networks and in telecommunications networks. Ethernet LAN switches use variable-sized packets or frames. ATM switches use small, fixed-sized cells for telecom applications. |
|
Note: If you have any related doubts, queries, feel free to ask by commenting down below.
And if my answer suffice your requirements, then kindly upvote.
Happy Learning