Premium Essay

Network Administration

In: Computers and Technology

Submitted By SirLancelot
Words 356
Pages 2
1. What is an entity? Give some examples. An entity exists and that's all it needs to do to be an entity. The fact that something exists also seems to connote separateness from other existences or entities.
2. What is a relationship? Give some examples. A relation is defined as a set of tuples that have the same attributes. A tuple usually represents an object and information about that object. Objects are typically physical objects or concepts. A relation is usually described as a table, which is organized into rows and columns
3. What is an attribute? Give some examples. A single data item related to a database object. The database schema associates one or more attributes with each database entity.
4. What symbols are used in an ER diagram for entities, relationships, and attributes?
5. What is a primary key? The primary key of a relational table uniquely identifies each record in the table. It can either be a normal attribute that is guaranteed to be unique (such as Social Security Number in a table with no more than one record per person) or it can be generated by the DBMS (such as a globally unique identifier, or GUID, in Microsoft SQL Server). Primary keys may consist of a single attribute or multiple attributes in combination.
6. What is a foreign key? A foreign key is a field in a relational table that matches the primary key column of another table. The foreign key can be used to cross-reference tables.
7. What is entity integrity? is one of the three inherent integrity rules. Entity integrity is an integrity rule which states that every table must have a primary key and that the column or columns chosen to be the primary key should be unique and not null. A direct consequence of this integrity rule is that duplicate rows are forbidden in a table.
8. What is referential integrity? is a property of data which, when satisfied, requires every value of

Similar Documents

Premium Essay

Network Administration

...Advanced Network Technology June 1993 OTA-BP-TCT-101 NTIS order #PB93-203735 Recommended Citation: U.S. Congress, Office of Technology Assessment, Advanced Network Technology--Background Paper, OTA-BP-TCT-1O1 (Washington, DC: U.S. Government printing Office, June 1993). For sale by the U.S. Government Printing Office Supcl IIIILWIICIII (If [k)c ulllLlll\. \lAll stop $s01’, \$ Allllg((u. [)(’ 2(141? () ~?x ISBN 0-16 -041805-4 -— . . Foreword omputer networks are having dramatic impacts on our lives. What were once esoteric tools used only by scientists and engineers are becoming more widely used in schools, libraries, and businesses. At the same time, researchers are working to develop even more capable networks that promise to change fundamentally the way we communicate. This background paper analyzes technologies for tomorrow’s information superhighways. Advanced networks will first be used to support scientists in their work, linking researchers to supercomputers, databases, and scientific instruments. As the new networks are deployed more widely, they will be used by a broader range of users for business, entertainment, health care, and education applications. The background paper also describes six test networks that are being funded as part of the High Performance Computing and Communications Program. These test networks are a collaboration of government, industry, and academia, and allow researchers to try new approaches to network design and to attack a variety...

Words: 37290 - Pages: 150

Free Essay

Principles of Network and System Administration

...CST 2405 Subject: Home work #1. Chapter (Self-test Objective) Question # 1: What kinds of issues does system administration cover? Answer: As we discussed in class, a Network System Administrator has to be knowledgeable, has to have customer service skills to be stay calm & collected when a complaint occurs, and must be able to rectify the problem. As the course text book “Principles of Network and System Administration”, by author Mark Burgess mentions in chapter #1 section 1.6 The challenges of system administration : “System administration is not just about installing operating systems. It is about planning and designing an efficient community of computers so that real users will be able to get their jobs done. That means: • Designing a network which is logical and efficient. • Deploying large numbers of machines which can be easily upgraded later. • Deciding what services are needed. • Planning and implementing adequate security. • Providing a comfortable environment for users. • Developing ways of fixing errors and problems which occur. • Keeping track of and understanding how to use the enormous amount of knowledge which increases every year.” The author also mentions that some of the Network System Administrators are responsible for both the hardware of the network and the computers which it connects, i.e. the cables as well as the computers and some are only responsible for the computers. Most importantly a System Administrator must have...

Words: 337 - Pages: 2

Premium Essay

Network Administration Portfolio

...itself within a month. A subset of this trend that cannot be over looked is the use of software as a service. Many applications can be made available from any computer or any device. There are no patches for customers to install making the software very user friendly. While many companies utilize third party services such as Drop Box, or even Google Docs, many companies would rather keep these documents, secure, in house. A well-designed network infrastructure that has the applicable requirements of the users is often well worth the financial sunk cost. A solid network is considered one of the most critical resources in an organization, both in the private and public sector, especially with paperless transmission of business documents between companies. A solid network is the cornerstone for providing the means of transmitting data (sometimes sensitive), from one computer to another. The mission of any business is to offer a useful product, increase profits, and increase work force potential. Because of these possibilities networks may increase the organizational learning rate, which many business professionals believe is the only fundamental advantage in competition. The accuracy and speed of daily business transactions for large and small organizations are vital to their success....

Words: 867 - Pages: 4

Free Essay

Specialized Network Administration

...Specialized Network Administration INTA 457-1404A-01 AIU Online Anthony Cox 8/31/2014 Introduction Today’s business world requires network administrators to keep their systems compatible and competitive. Compatibility will keep their network systems current with today’s trends and recent developments and while there can be a certain cost expected when upgrades are implemented, it is a relatively small price to pay to remain competitive in today’s market. Questions have arisen about the current network and ways to improve the efficiency and effectiveness of our network system. The following problems have been researched and addressed in the following pages: 1. Toll charges are currently being applied to communications between Los Angeles (LA) and Miami offices 2. Network upgrade needs to be implemented to remain competitive a. Eliminate all interoffice toll charges b. No adverse effects on the Wide Area Network (WAN) c. Diagram the network layout The current network has been around for a while and is in desperate need of upgrade. It is my belief that the upgrade should begin at the local area networks (LANs) in both Miami and LA. Only by upgrading both offices equally, can we expect to achieve the efficiency which we desire. The recommended changes should be enough to lower the collective overhead and operational expenses while preparing the company for continued future growth. To implement this growth, many challenges will...

Words: 645 - Pages: 3

Free Essay

Network Systems Administration

...7.1.1 Cost and manpower and materials would be enormous. 7.1.2 Signal lost would affect transmission by increasing distances. 7.1.3 UTP is used for LAN’s as well as phone lines. Coaxial cables are also useful for internet connection. 7.1.4 Satellite is a way of creating a network over long distances. WiMAX, is a standards-based technology enabling the delivery of last mile wireless broadband access as an alternative to cable and DSL. HSPA+, enhances the widely used WCDMA (UMTS) based 3G network with higher speeds for the end user. 7.1 Review 1) UTP and Coaxial cables can be used if signal enhancers are placed at correct distances. 2) WLAN’s are limited to shorter distances due to signal interference from attenuation and objects between the AP and devices. 7.2.1 Dedicated lease lines are very effective in transmission, but can be costly. 7.2.2 Full mesh topologies are good for no fault networking. Creating it can be difficult to maintain and assemble. Partial mesh is good when every computer is not important in the network. 7.2.3 Star topologies are great for small LAN’s. But, they have a high level of fault error in the system. 7.2.4 T1 uses 24 DSO channels, E1 has a speed of 2048 Mbps, E3 has 16 E1 channels, T3 has 43,736 Mbps and 28 DS1 channels. 7.2 Review 1) PPP allows their frames to flow from the customer router to the ISP router. A control protocol is used to set a standard everyone can understand. 2) LAN’s tend to have more immediate clients...

Words: 341 - Pages: 2

Premium Essay

New Technology Research for Network Systems Administration

...My field of study is Network Systems Administrations. I am most interested in networking technology. I currently understand very little about networking, which is to say I understand the functionality but not how it works. The topic I chose was Home-linking Technology. The article I read was “Dual Band Router leverages 802.11ac wireless standard.” from the Product News Network. The article started by describing the speed of the new 802.11ac router. Equipped with the Broadcom 5 GHz WI-Fi chip, the Cloud Router 5700 can deliver speeds up to 1750 Mbps. Its predecessor, the 802.11n has vendor promised speeds of up to 600 Mbps. The Cloud Router also supports wireless HD streaming and multi-person online gaming. It allows users to monitor and control your network remotely. In addition the 5700 provides support of the IPv6 standard and is backwards compatible so the previous generation 802.11n will not become obsolete. I also learned new terminology; IEEE- Institute of Electrical and Electronics Engineers. It is listed as “the world’s largest professional association dedicated to advancing technological innovation and excellence for the benefit of humanity.” 802.11- Set of standards for implementing wireless local area network (WLAN) computer communication in the 2.4, 3.6 and 5GHz frequency bands. SPI Firewall- (Stateful Packet Inspection) is a firewall that keeps track of the state of the network connections traveling across it. WPA2- (Wi-Fi Protected Access II) is...

Words: 325 - Pages: 2

Free Essay

Network Systems Administration

...Everyone loves pizza and beer and I am certainly no exception so it would have surprised no one to find me at Frank’s Pizza on an otherwise unremarkable evening in 1987, what did surprise many was what happened less than a year after this particular night. In a small town in Northern California more famous for its rich gold rush era history than any culinary notoriety in a downtown still dominated by structures from the late 1800’s is a pizza joint named Frank’s, no one remembers who gave it that name, the owner for the vast majority of my life is named William Jackson Davis and if he ever knew the titular namesake he never told me or anyone I know, but history or name aside no one I ever heard of had anything but praise for the pies that were produced there, 4 hour waits on a Friday or Saturday were not uncommon. So it was there I was headed on that portentous evening nearly thirty years ago after a back breaking week of working in construction putting drywall on houses, with a great hunger and thirst only such demanding and dusty work can produce and looking forward to nothing more than the filling and delicious pizza and ice cold refreshing beer when I noticed that the owners had hired a new waitress, a striking Green eyed beauty with a bust that would cause babies for miles around to begin salivating, now as a young single man not many years out of the Marine Corps my reaction was somewhat predictable, I hit on her like a Miner Forty-niner on a rich vein in the Mother...

Words: 821 - Pages: 4

Free Essay

Network Systems Administration

...that can determine the latitude and longitude of a receiver on Earth by computing the time difference for signals from different satellites to reach the receiver. Today, it is widely used by the civilian public for both commercial and recreational use. In addition to GPS, other systems are in use or under development. The Russian Global Navigation Satellite System (GLONASS) was in use by only the Russian military, until it was made fully available to civilians in 2007. The navigational signals transmitted by GPS satellites encode a variety of information including satellite positions, the state of the internal clocks, and the health of the network. These signals are transmitted on two separate carrier frequencies that are common to all satellites in the network. Two different encodings are used: a public encoding that enables lower resolution navigation, and an encrypted encoding used by the U.S. military. So in 20 years you can just imagine where this will lead… As of December 2013, there are 32 satellites in the GPS constellation. The additional satellites improve the precision of GPS receiver calculations by providing redundant measurements. With the increased number of satellites, the constellation was changed to a non-uniform arrangement. Such an arrangement was shown to improve reliability and availability of the system, relative to a uniform system, when multiple satellites fail. About nine satellites...

Words: 358 - Pages: 2

Premium Essay

Network Systems Administration

...algorithm? a. AES b. 3DES c. RSA d. RC4 34. Identify a security principle that can be satisfied with an asymmetric digital signature and not by a symmetric signature. a. Nonrepudiation b. Integrity c. Authorization d. Access control 35. Which of the following is a mechanism for accomplishing confidentiality, integrity, authentication, and Nonrepudiation a. Cipher text b. Cryptography c. Access control d. Hashing 36. In which OSI layer do you find FTP, HTTP, and other programs that end users interact with? a. Application b. Network c. Physical d. Data Link 37. Identify the configuration that is best for networks with varying security levels, such general users, a group of users working on a secret research project, and a group of executives. a. Multilayered firewall b. Screened subnet firewall c. Border firewall d. Ordinary firewall 38. Which of the following would you not expect to find on a large network? a. Router b. Switch c. Hub d. Firewall 39. Which of the following is a weakness of WLANs? a. WPA b. RF shielding c. User groups d. SSID beaconing 40. Identify an advantage of IPv6 over IPv4. a. More secure b. Larger address space c. IPSec support d. More commonly used 41. Identify one of the first...

Words: 606 - Pages: 3

Free Essay

Resume

...Akarsh Avunoori akarsh.avunoori00 1@umb.edu 512-645-7475 OBJECTIVE  To attain a challenging and responsible position where I can contribute the best of my skill and the efforts for an organization that will provide a platform for the exploration and realization of my potential to the maximum QUALIFICATIONS       Organizational skills: Self and student organization. Ability to schedule and coordinate internal and external meetings, events, interviews, various department meetings and appointments. Knowledge on Disability and Rehabilitation laws Excellent written and verbal communication skills. Administration of distributed computing and storage systems Familiar with C, C++,Java, Matlab 8.0, Linux(Open source RHEL, Fedora) Computer savvy – proficient in Excel and Word, experienced in digital data input, Microsoft Project and Adobe products. PROFESSIONAL EXPERIENCE Sindhura College of Engineering, INDIA Designation: Assistant Administrative Officer       Prepare schedule for different courses, guide students complete final project by providing enough research resources(Ubuntu) Suggested and successfully implemented TRIM electronic filing system, leading to an almost entirely paperless office Manages daily activities of office as well as company-wide projects and activities. Suggest in developing and implementing the company's strategic plan, implementing budgets Assist in Reviewing administrative policy, Preparing financial...

Words: 487 - Pages: 2

Premium Essay

The Biz

...Consumer Information WVJC Morgantown Nursing - Associate Degree (CIP Code: 51.3801) Occupation Registered Nurses Clinical Nurse Specialist Acute Care Nurse Advanced Practice Psychiatric Nurse Critical Care Nurse SOC Code 29-1141.00 29-1141.04 29-1141.01 29-1141.02 29-1141.03 On-Time Graduation Rate: * Placement Rate: * Median Loan Debt: Private: * Institutional Financing Plan: * Title IV: * Cost of Program: Tuition: $39,960 Fees: $4,125 Supplies: $900 Total Cost: $44,985; For more information regarding the Cost of Attendance, please Click Here. For a downloadable copy of this information, please Click Here. *Nursing is a new program offering and therefore, information does not exist for on-time graduation rates, placement rates, and median loan debt. Medical Assisting - Associate Degree (CIP Code: 51.0710) Occupation Medical Assistant Medical Secretary SOC Code 31-9092.00 43-6013.00 On-Time Graduation Rate: 74% Placement Rate: 88.24% Median Loan Debt: Private: $0 Institutional Financing Plan: $0 Title IV: $9,346.00 Cost of Program: Tuition: $22,500 Fees: $2,750 Supplies: $400 Total Cost: $25,650 For more information regarding the Cost of Attendance, please Click Here. For a downloadable copy of this information, please Click Here. Placement Rates were produced from the annual Accrediting Council for Independent Colleges and Schools (ACICS) Campus Accountability Report (CAR). Medical Assisting - Diploma (CIP Code: 51.0710) Occupation Medical Assistant Medical Secretary On-Time...

Words: 2699 - Pages: 11

Premium Essay

Pursue a Master in Business Administration

...To pursue a master's in business administration Gary M. Newsome MGT/521 August 17, 2010 Stephanie Jackson To pursue a master's in business administration Many people set goals in life with a mindset of accomplishing these goals, and there is no more important goal than achieving a higher degree in education. It always has been my ultimate goal to achieve a master’s in business administration (MBA), but because of the time constraints and long deployments of military service, attending an institution of higher education for an MBA was out of the question. After 30 years of military service and beyond the age of 50, there is no better time to conquer my dreams and achieve my personal goal in obtaining my MBA. This accomplishment will open new a new path toward venturing into another outstanding career. The value of higher education is an important factor for advancement. The opportunity to excel would be the primary reason to achieve this goal while gaining the skills, and knowledge, of management. A position of increased responsibility requires much knowledge to be successful and a company, or business, may fail without these credentials. Mintzberg stated that “managers are important people who are supposed to sit above others, removed and disconnected from the work of making products and selling services. The higher they go, the more important they are, so that on reaching the top, becoming Chief Executive Officer; they are the corporation even if they arrived yesterday...

Words: 1190 - Pages: 5

Premium Essay

Domains

...1. Describe five factors that may lead you to create multiple domains for this organization. a. Decentralized administration – If the company doesn’t plan to centralize domains into one model, this factor would be a good choice due to the fact that the company has multiple branches in multiple locations. Each domain acts as a kind of security boundary which will only allow administrators within that domain to work only in that domain; for example, an administrator in England would not have privileges to work within a domain that is located in California. b. Geographic limitations – Due to the fact that the company has multiple locations scattered globally, links or data transfer may be slow if the entire network is under one domain. This alone doesn’t give enough reason for multiple domains, the main reason is so that an administrator will have control over his/her region and not have to contact another administrator halfway across the world. c. Unique DNS namespace considerations – If multiple organizations want to use similar registered namespaces, multiple domains are needed because each registered namespace has to be on a separate domain. d. Special password policies – password policies are setup on the domain lever so to separate the different policies multiple domains have to be setup. e. Enhanced security concerns – separating the schema master role into a different domain than what your users on can increase the security by nit having everything in...

Words: 312 - Pages: 2

Free Essay

Tracer Study

...TRACER STUDY OF BUSINESS ADMINISTRATION GRADUATES OF CAPITOL UNIVERSITY 2008-2010 A Research Paper Presented to The Faculty of the College of Business Administration Capitol University Cagayan de Oro City __________________ In Partial Fulfilment Of the Requirements for the Course ED12 RESEARCH METHODOLOGY PROF. CECILLE C. DEUDA (Professor) ________________ By: Arbuis, Arra Jynne S. Camero, Jeffrey Lou Q. Linogao, Rosario R. Toñacao, Cejane B. OCTOBER 2012 TABLE OF CONTENTS Page Title Page i Acknowledgement ii ABSTRACT iii List of Tables CHAPTER 1 Introduction 1 1.1 Conceptual Framework 3 1.2 Statement of the problem 4 1.3 Scope and Limitation 5 1.4 Significance of the study 6 1.5 Definition of terms 6 2 Review of Related Literature 9 3 Research Design and Methodology 12 3.1 Research Design 12 3.2 Methodology 12 3.2.1 Respondents of the study 12 3.2.2 Research Instruments Used 13 3.2.3 Statistical Treatment 14 4...

Words: 7296 - Pages: 30

Premium Essay

Resume

...BUSINESS ADMINISTRATION RESUME  Part 1 of this series talking about how goal setting is the most important step for running an efficient job hunt. We have to have clearly written career goals. Forgetting to set our goals is not a good thing. In Part 1, I also provided some recommended resources so we can set our goals and get that part of our job search settled. Here is a quote worth repeating from that earlier article,  Step 2 - Writing Our Business Card Resume Before our actually write our business card resume let's talk about how we are going to use it. Question: Who is the audience for the business card resume? We can play some Final Jeopardy music here if we like. Think about who gets our business card resume. Who will receive it and what will they do with it? Let me give we a few scenarios:  We are at a networking event and we meet someone  We are at Starbucks having coffee with someone and a third person comes up to say hello to our guest. We get introduced  We meet someone who needs something and we want to offer help We need a job. We want to make sure everyone hearing our message knows that and our goals is to enlist our every contact to help we secure our next job. My recommendation is to keep our message simple. The obvious stuff for our business card resume is our name, phone number (mobile only)preferred email and all other possible ways to reach you. Then deliver a clear message (the one's on those sites are move involved) using the front or possibly...

Words: 556 - Pages: 3