Premium Essay

Assignment 2: Logical Design, Part 1

In:

Submitted By lovelyophelia
Words 523
Pages 3
1. List the advantages of a relational model specific to ACME Global Consulting.
Relational models can provide some very significant advantages over other methods. First, they are very easy to read due to the nature of two-dimensional tables. Columns and row format is straightforward and consists of a collection of similar data among rows that allow for the user to easily locate what they need.
One of the biggest advantages of the relational model of database design is that its foundation is formal mathematical theory. It allows its concepts to be defined and examined with great precision. In other systems, the calculations may need to be done separately prior to using the database.
2. Summarize in your own words the purpose of an E-R model specific to ACME Global Consulting.

The E-R model can provide ACME Global with a specific, but open-ended design that is tailored to the company’s needs. This also allows us to sketch the design of a database informally and incorporate changes in order to avoid problems later on. The E-R model allows for growth beyond its ideas at inception. It lays the groundwork for later database relational designs.

3. List and describe essential components of the model such as entities, attributes, keys, relationships, roles, and dependencies specific to ACME Global Consulting.

Entity: real-world object or thing with an independent existence and which is distinguishable from other objects. Examples are a person, car, customer, product, gene, book etc. Attributes: an entity is represented by a set of attributes (its descriptive properties), e.g., name, age, salary, price etc. Attribute values that describe each entity become a major part of the data eventually stored in a database. A key is a set of attributes for one entity set such that no two entities in this set agree on all the attributes of the key.

4. Describe the

Similar Documents

Premium Essay

Unit 1 Labs

...ITT TECHNICAL INSTITUTE NT1210 Introduction to Networking Onsite Course GRADED ASSIGNMENTS Graded Assignment Requirements Retain all handouts issued in every unit, as well as any assignment, research, or lab documents you prepare as part of assignments and labs. Some may be used more than once in different units. NOTE: Always check with your instructor for specific due dates of assignments. Graded Assignments Unit 1 Assignment 1: Computer Basics Review Course Objectives and Learning Outcomes Identify the major needs and major stakeholders for computer networks and network applications. Describe how digital devices store data. Describe the differences between input and output devices. Assignment Requirements In the Chapter Review Activities at the end of Chapter 1 in the Odom textbook (answers can be found in the textbook): Respond to the multiple-choice questions. Complete the List the Words inside Acronyms table. Required Resources Odom textbook Computer with word processing software Internet access Printer Submission Requirements: Submit your responses as a typed document using Arial or Times New Roman 12-point font, double-spaced. Label your assignment Unit 1 Assignment 1. Unit 2 Assignment 1: Identifying Network Topologies Course Objectives and Learning Outcomes * Identify the major needs and major stakeholders for computer networks and network applications. * Identify the classifications of networks and how they are...

Words: 16182 - Pages: 65

Premium Essay

Police Abuse Essay

...ITT TECHNICAL INSTITUTE NT1210 Introduction to Networking Onsite Course GRADED ASSIGNMENTS Graded Assignment Requirements Retain all handouts issued in every unit, as well as any assignment, research, or lab documents you prepare as part of assignments and labs. Some may be used more than once in different units. NOTE: Always check with your instructor for specific due dates of assignments. Graded Assignments Unit 1 Assignment 1: Computer Basics Review Course Objectives and Learning Outcomes * Identify the major needs and major stakeholders for computer networks and network applications. * Describe how digital devices store data. * Describe the differences between input and output devices. Assignment Requirements In the Chapter Review Activities at the end of Chapter 1 in the Odom textbook (answers can be found in the textbook): * Respond to the multiple-choice questions. * Complete the List the Words inside Acronyms table. Required Resources * Odom textbook * Computer with word processing software * Internet access * Printer Submission Requirements: Submit your responses as a typed document using Arial or Times New Roman 12-point font, double-spaced. Label your assignment Unit 1 Assignment 1. Unit 2 Assignment 1: Identifying Network Topologies Course Objectives and Learning Outcomes * Identify the major needs and major stakeholders for computer networks and network applications. * Identify the...

Words: 16043 - Pages: 65

Premium Essay

Introduction to Networking

...ITT TECHNICAL INSTITUTE NT1210 Introduction to Networking Onsite Course GRADED ASSIGNMENTS Graded Assignment Requirements Retain all handouts issued in every unit, as well as any assignment, research, or lab documents you prepare as part of assignments and labs. Some may be used more than once in different units. NOTE: Always check with your instructor for specific due dates of assignments. Graded Assignments Unit 1 Assignment 1: Computer Basics Review Course Objectives and Learning Outcomes * Identify the major needs and major stakeholders for computer networks and network applications. * Describe how digital devices store data. * Describe the differences between input and output devices. Assignment Requirements In the Chapter Review Activities at the end of Chapter 1 in the Odom textbook (answers can be found in the textbook): * Respond to the multiple-choice questions. * Complete the List the Words inside Acronyms table. Required Resources * Odom textbook * Computer with word processing software * Internet access * Printer Submission Requirements: Submit your responses as a typed document using Arial or Times New Roman 12-point font, double-spaced. Label your assignment Unit 1 Assignment 1. Unit 2 Assignment 1: Identifying Network Topologies Course Objectives and Learning Outcomes * Identify the major needs and major stakeholders for computer networks and network applications. * Identify the...

Words: 16043 - Pages: 65

Premium Essay

Health Concept Assignment

...Part 1: Wellness Center The Wellness Center currently tracks its members using a spreadsheet, and wants to upgrade to using a relational database. You have been tasked with this conversion, and need to convert this flat field design into a relational database design. The Wellness Center has given you its current spreadsheet design, which contains the following fields (columns). • Member ID • Member Name • Member Phone • Member Email • Health Plan Level Name • Health Plan Level Description • Health Plan Price • Price w/tax • Paid Until Date • Member Since • Event 1 Name • Event 1 Description • Event 1 Attended • Event 2 Name • Event 2 Description • Event 2 Attended • Event 3 Name • Event 3 Description • Event 3 Attended The Wellness Center has also given you the following business rules, which are incomplete and are not all necessarily structural. • Members purchase a yearly health plan. • The health plans are one of three levels: Basic, Deluxe, or Executive. • Health plans are generally paid for once per year. • Three special Healthy Living Symposium events are offered each year. Attendance is tracked for each member. 1. To get started, create a complete list of business rules that you will use as a basis for your logical diagram. Your list of business rules should specify all entities, relationships, optionality constraints, and plurality constraints...

Words: 1250 - Pages: 5

Premium Essay

History

...OF GRAPHIC DESIGN 3 ASSIGNMENT 5 and 6 This module is presented on NQF Level 6 FACULTY OF CREATIVE ARTS AND COMMUNICATION Module leader: MIRANTHE VAN STADEN GARBETT miranthev@mgi.ac.za: Phone: (011) 690-1825 Office number: 4 Lecturer (Remote Campus): E-mail: Due Dates: Assignment 5: Week 13 and 20 Assignment 6: Week 27 Assessments: Assignment 5: 200 Marks ( 10% final mark) Minus 5% per day deducted for late submissions Phone: Assignment 6: 100% (30% final mark). No late submissions will be accepted 1) Learning Outcomes Through this assignment, the student should achieve the following outcomes: • • • • Research, structure and write a formal academic article. Formulate an appropriate research question Apply an appropriate methodology to a specific topic Research, acquire and present in digital format a specialised knowledge of an aspect or area of African discourse or aesthetics, whether historical or contemporary. • • • Apply knowledge of history and/or theory to the chosen topic and evaluate contemporary relevance Identify and evaluate a specific case study that illuminates an aspect of African discourse or African aesthetics. Be able to explain, interpret and apply key terminologies, concepts, principles and theories in the development of a logical argument • • Formulate findings and interpretations into a sound, logical argument Support opinions and statements using authoritative sources and the correct Harvard method 2) Scope For...

Words: 2263 - Pages: 10

Premium Essay

Information

...Logical Design, Part I Wayne Murphy Strayer University Introduction to Relational Database Management System CIS111019VA016-1132-001 Jean-Robert Bokino January 11, 2013 Logical Design, Part I In this assignment, I will write a two to three page paper titled “Logical Design, Part 1” whereas I am a recently hired consultant for ACME Global Consulting to procure requirements for a large database. In this scenario, “Logical Design, Part 1”, I will develop a database management systems to convince a set of clients of the benefits of using the Entity–Relationship model (E-R) in developing a database. In addition, my management would like the following points addressed in my design: (1). List the advantages of a relational model specific to ACME Global Consulting. (2). Summarize the purpose of an Entity–Relationship Model (E-R) specific to ACME Global Consulting. (3). List and describe essential components of the model such as entities, attributes, keys, relationships, roles, and dependencies specific to ACME Global Consulting. (4). Describe the need for the enhanced E-R model and how we can create sophisticated models to help us in complex environments. (5). Outline and describe the advantage of using the relational model. (6). Create an E-R diagram using graphical depicting software that could theoretically be used in a restaurant application. Now that you know the purpose of this assignment, I will define three key terms that will be discussed in this assignment. The first term...

Words: 1493 - Pages: 6

Free Essay

Chapter 1

...Chapter 1 assignment Nouf Mohammad Alshammiri ID:209117509 (1) Analysis: the second phase of the SDLC in which system requirements are studied and structured. (2) Application Software: Computer software designed to support organizational functions or processes. (3) Computer aided software engineering (CASE) tools: systems development methodologies created to radically decrease the time needed to design and implement information systems. This methodology relies on extensive user involvement, prototyping, integrated CASE tools and code. (4) Design: the third phase of the SDLC in which the descriptions of the recommended solution in converted into logical and physical system specifications. (5) Implementation: the fourth phase of the SDLC in which the information system is coded, tested, installed, and supported in the org. (6) Information system analyses and design: the complex organizational process whereby computer-based information systems are developed and maintained. (7) Inheritance: the property that occurs when entity types or object classes are arranged in a hierarchy and each entity type or object class assumes the attributes and methods of its ancestors; that is, those higher up in the hierarchy. The property allows new but related classes to be deirved from existing classes. (8) Logical design: the part of the design phase of the SDLC in which all function features of the system chosen for development are described independently of any computer platform...

Words: 489 - Pages: 2

Premium Essay

Explain How Quartiles, Percentiles and the Correlation Coefficient Are Used to Draw Useful Conclusions in a Business Context.

...! ! Course Unit No. Unit Name Unit code Batch Student Assignment Covering Form Course/Unit Information Pearson (Edexcel) BTEC Level 5 Higher National Diploma Unit 6 Business Decision Making D/601/0578 J65-1403/E65-1403 ! Name Phone Skype ! ! Instructor Information Anil Ahluwalia +971 52 905 9904 anilbaljit anil@westford.org.uk ! ! ! Email Assignment Information Full/ Part Assignment Date Assignment Issued Part 11/03/2013 Tasks-1&2: 29/03/2014 ! Date Assignment Due ! ! Student Information (To be filled by the student prior submitting the assignment) Name Westford Student ID Edexcel Student ID Email Tsion Girma Birru tsn_grm@yahoo.com Date of Submission March 29,2014 All the submissions to be done through e-front LMS, no email or other format will be accepted.Student Assignment covering form is an integral part of the assignment document and should be submitted along with all submissions. ! ! Student Declaration ! ! I, Tsion Girma Birru hereby confirm that this assignment is my own work and not copied or plagiarized. It has not previously been submitted as part of any assessment for this qualification. All the sources, from which information has been obtained for this assignment, have been referenced as per Harvard Referencing format. I further confirm that I have read and understood the Westford School of Management rules and regulations about plagiarism and copying and agree to be bound by them. ! ! ! ! ! ! !...

Words: 3533 - Pages: 15

Premium Essay

Management Information Systems: Managing the Digital Firm

...ELP ASSIGNMENT – WEEK 01 Avinash Shankar Coleman University Database Integration – A framework The Physical Database Design depicts the actual structure of a set of relational tables specific to the platform and Database Management Systems (DBMS) on which the database is implemented. It is used to transition a logical data design into a physical database design that can be used to generate Data Definition Language (DDL). It also takes the current Systems environment into consideration, as well as some non-functional requirements. Basically the Physical Database Design is the implementation of the logical data design with any changes needed for physical considerations, such as capacity and performance. A physical database design is performed in three stages (LePendu, P., & Dou, D., 2011, p. 217 to 244): 1. Logical database design, which includes gathering of business requirements, developing a logical data model, and designing how to load the data 2. Conversion of the logical data design into a Physical Database Design includes table definitions, primary and foreign key relationships, and basic indexing 3. Post deployment Physical Database Design (often performed by a database administrator) includes improving performance, reducing I/O, and streamlining administration tasks. Data Integration Layer The data integration layer should be modeled in 3rd normal form or near 3rd normal form and is considered to be similar to an operational data design. In...

Words: 582 - Pages: 3

Premium Essay

Prg 211 Week 4

...Personal Learning Management Part Three University of Phoenix PRG 211 09-23-2013 Contents Introduction 3 Problem Statement and Solution 4 Conclusion 6 Introduction Parallel array structures can be used for many instances where an individual wants to input information that is unique to them, such as keeping track of their value items of learning. The entire process of putting pen to paper and creating a program is methodical in nature. The code does not have to be complicated and can be written in plain spoken English. Testing a program to see if it works is a simple task. All the programmer has to do is to input the data into the program and if it is functioning properly, a result based on the input and output will appear of the screen. The results come from a calculated list of items that have a represented value declared by the programmer. For instance, if a programmer wanted to design a program to calculate an entire course’s worth of an item with high value, then they would most likely declare the item of high value as the starting declaration and then say how many of that item are in an entire course. Problem Statement and Solution Arrays have been used in a whole host of problems to arrive at solutions for daily routines and tasks that people are involved in. Parallel arrays operate on a “grab that” basis where the values within the strings grab data from each other and produce information...

Words: 772 - Pages: 4

Premium Essay

Information System

...AACS1733 Information Technology and Systems ASSIGNMENT 2010/2011 Objective This coursework aims to provide students an opportunity to explore the use of Microsoft Excel and PowerPoint so as to enhance their understanding of the application software features in spreadsheet and presentation. Grouping This is a group-based assignment. Student may form a group of minimum 4 students and maximum 5 per group (ACCORDING TO ATTENDANCE LIST NAME SEQUENCE). A group leader is to be selected to ensure equal allocation of tasks among each student in the group before assembling a complete assignment report. Plagiarism All work is to be the result of the student's own individual and group effort. Assignment contents are not allowed to be copied from the Internet or from other students. A student who plagiarizes will receive zero point credit on the assignment. Late Policy The assignment should be submitted on the due date stated below unless there is any legitimate reason as to why it is impossible for the student to complete the assignment. As a general rule, no extension of time will be granted. Assignment received after the due date without legitimate reason will be penalized. Submission date: 6/12/2010 (Monday) (Week 11) Assignment return week: Week 14 Assessment This assignment is worth 40% of the overall course assessment. The marks allocations are divided into 2 categories. The first category is an individual mark which is awarded based on each...

Words: 2098 - Pages: 9

Premium Essay

Commcates a Risk

...your business. If you need LAN or WAN support availability and quality of technical support and documentation of training and vendor. For switch and bridges you have to look at number of MAC address can learn, support of port security, support for cut through switching and support for adaptive cut through switching. Don’t forget amount of memory. The router network layer protocols supported, routing protocols support, support for multicast, support for advanced queuing switching and other optimization. These are all important of selecting internetworking. You have to look at the business and customers that you are support then you use these internetwork criteria to make your decisions. Priscilla Oppenheimer (2012). Top-Down Networking Design. (Special Edition for Strayer University) Boston, MA, Pearson Learning Solutions Describe the key criteria involved in selecting WAN technologies and WAN providers. Discuss which criteria is the most important from your perspective and state why. When selecting WAN technologies and WAN provider this will vary from company to company one of the most important factors would be the cost. This would also include business requirements and technical goals of the company. With WAN provider it would depend on the cost and what the provider offers from global coverage management or monitoring capabilities. In mine opinion it is up to the business that needs the WAN and provide and how much money they want to spend on it. You can make big...

Words: 514 - Pages: 3

Premium Essay

Nursing

...Benchmark - Research Critique Part 2 View Rubric Due Date: Apr 19, 2015 23:59:59       Max Points: 150 Details: Prepare a critical analysis of a quantitative study focusing on protection of human participants, data collection, data management and analysis, problem statement, and interpretation of findings. The quantitative research article can be from your previous literature review or a new peer-reviewed article. Each study analysis will be 1,000-1,250 words and submitted in one document. As with the assignments in Topics 1-3, this should connect to your identified practice problem of interest. Refer to the resource entitled “Research Critique Part 2.” Questions under each heading should be addressed as a narrative, in the structure of a formal paper. You are also required to include an Introduction and Conclusion. Prepare this assignment according to the APA guidelines found in the APA Style Guide, located in the Student Success Center. An abstract is not required. This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. You are required to submit this assignment to Turnitin. Submit the assignment along with an electronic version of the article used for the analysis. If an electronic version is not available, submit a clean unmarked copy of the article. NRS433V.v10R.ResearchCritiquePart2Guidelines_student.docx ------------------------------------------------- ...

Words: 1436 - Pages: 6

Free Essay

Managing Activities to Achieve Results

...------------------------------------------------- Associate’s Degree in Business Management/HR Management/Marketing The student must fill the relevant parts of the following table. Student First Name | Student Last Name | Student ID | Date submitted | | | | __/__/__ | Statement of authenticityI, the above named student, hereby confirm that this assignment is my own work and not copied or plagiarized. It has not previously been submitted as part of any assessment for this qualification. All the sources, from which information has been obtained for this assignment, have been referenced. (Harvard format). I further confirm that I have read and understood the Malé Business School rules and regulations about plagiarism and copying and agree to be bound by them. | Assignment summary information Assignment type | Task 1: Individual, collaboration not allowed. Task 2: Group role play, collaboration allowed. | Activity title | How activities are managed to achieve results at (company name) | Assignment reference | 1 | Unit | 15. Managing Business Activities to Achieve Results | Date issued: | 1 October 2013 | Date due: | 14 December 2013 | Presentation Date | 21 December 2013 | Extensions | The due date will not normally be extended. The maximum number of days allowable for an extension to the deadline for this assignment is 5 days. An extension must be applied for in writing by individual students and will only be granted for valid reasons. | Late submissions |...

Words: 6223 - Pages: 25

Premium Essay

Commcates a Risk

...your business. If you need LAN or WAN support availability and quality of technical support and documentation of training and vendor. For switch and bridges you have to look at number of MAC address can learn, support of port security, support for cut through switching and support for adaptive cut through switching. Don’t forget amount of memory. The router network layer protocols supported, routing protocols support, support for multicast, support for advanced queuing switching and other optimization. These are all important of selecting internetworking. You have to look at the business and customers that you are support then you use these internetwork criteria to make your decisions. Priscilla Oppenheimer (2012). Top-Down Networking Design. (Special Edition for Strayer University) Boston, MA, Pearson Learning Solutions Describe the key criteria involved in selecting WAN technologies and WAN providers. Discuss which criteria is the most important from your perspective and state why. When selecting WAN technologies and WAN provider this will vary from company to company one of the most important factors would be the cost. This would also include business requirements and technical goals of the company. With WAN provider it would depend on the cost and what the provider offers from global coverage management or monitoring capabilities. In mine opinion it is up to the business that needs the WAN and provide and how much money they want to spend on it. You can make big...

Words: 514 - Pages: 3