This website uses cookies to ensure you have the best experience. Learn more

It520 Unit 1 Assignment

560 words - 3 pages

Question 1 Define each of the following terms. In addition, provide an example of each term.

a. Entity Set - A collection of like entities.  Example: If a customer is an entity, then the entity set would be a collection of two or more customers.

b. Entity Instance - Each row in the relational table.  Example: A row of information beginning with the entity itself and showing the relations of that specific entity and none other.

c. Attribute - A characteristic of an entity.  Example: The information used to describe the entity.  If the entity is CLIENT, then the attributes would probably contain things like ‘address’, or ‘name’ or other specific bits of information.

d. Connectivity - This is the name given as a label for the different connection types, one to one, one to many, and many to many.  Example: If the Relationship is ...view middle of the document...

 The foreign key would be the attribute that allows somebody to

g. Associative Entity (Composite Entity) - This is an entity that seeks to convert a many to many relationship to a 1 to many relationship by either compiling foreign keys or creating a new primary key on a new table.  Example: Creating a table that tracks 2 or more foreign keys to identify a third attribute.

h. Cardinality Constraint - This a command used to restrict information based on a number value or range.  Example: doing a search for all prices higher than $5 but lower than $10.

i. Weak Entity - This is a two-part definition.  This entity must have the entity it is related to be present in order to exist, and must have a primary key that is partially or completely derived from the entity it’s related to.  Example: An example of this is if an entity is a person buying a car and they need a cosigner.  They could not get the car without that second signature.  Both people become entities, and the person needing the cosign is the weak entity.

j. Business Rule - This is a description of a policy or parameter within an organization and are used to define entities, attributes, relationships, and constraints.  Example: “A student may take 5 classes.” This rule will only allow a student (identified by a PK) to enroll in 5 courses (identified by a PK for classes) and will not allow any more enrollments.

Question 2 Business Rules

Database - Unit
ONE Database may Track MANY Units [M]
ONE Unit can be tracked by ONE Database [1]
Database 1:M Units.

Question 3 Entity Relationship Diagram

Question 4 Primary Key / Foreign Key Placement

Entity Set | Primary Key Attribute(s) | Foreign Key Attributes(s) |
Publisher | Publisher_ID | |
Volume | Volume_ID, Volume_Name | ISBN-13, ISBN-10, BOOK_Title |
Book | ISBN-13, ISBN-10, Book_Title | |
Book-Author | Author_ID | Author_Lastname, Author_Firstname |
Author | Author_Lastname Author_FirstnameAuthor_ID | |
Country | ID | |

Other Papers Like It520 Unit 1 Assignment

Is3230 Unit 7 Assignment 1

565 words - 3 pages | Unit 7 Assignment 1 | Implementation of Authentication Process | | | WLANs (wireless local area networks) are becoming increasingly prevalent, not only in schools, but in many businesses and establishments. They can provide a plethora of benefits within a school environment including flexibility, speed, and resource mobility. A WLAN would assist in ease of use, and make many of the day-to-day functions of school employees

Nt2580 Unit 1 Assignment 2

554 words - 3 pages Unit 1 Assignment 2 Impact of a Data Classification Standard Internal use only is information that may or may not be confidential. But is shared within a organization and kept away from the public. With that being said it is imperative that we seek the following to be incorporated within the standards in each domain. User Domain refers to the people who have access to the organizations equipment User domains is the worst domain for security

It500 Unit 2 Assignment 1

1789 words - 8 pages Unit 2: Assignment 1: Global Challenges Associated with E-Commerce December 18, 2012 IT500-01N: Critical Concepts and Competencies for the IT Professional Instructor: Dr. Sheila Fournier-Bonilla Kaplan University Unit 2: Assignment 1: Global Challenges Associated with E-Commerce E-Commerce has changed the ways that companies do business, they are no longer confined to certain areas, regions, or even countries. "E-Commerce and m

Nt1210 Unit 4 Assignment 1

1669 words - 7 pages Unit 4 Assignment 1. Answer These Questions 1. You have created a simple electrical circuit with a battery, wires, and a light bulb. Which of the following is true about this circuit? (Choose two answers.) a. The battery’s positive lead pushes current away from that lead. b.- The battery’s positive lead pulls current toward that lead. c.- The circuit creates a direct current. d. The circuit creates an alternating current. 2. A PC

Bu1410 Unit 2 Assignment 1

2804 words - 12 pages BU1410 Management Information Systems Unit 2 Assignment 1 Instructor: Willie Cooper Jr. Chapter 2 1. What are the major functions of a business that are important for understanding the role of information systems? * Define a business and describe the business functions. * According to the book “A business is a formal organization whose aim is to produce products or provide services for a

Unit 4 Assignment 1: Visual Elements & Graphics

450 words - 2 pages SD1240 Unit 4 Assignment 1: Visual Elements & Graphics Course Objectives and Learning Outcomes Use HTML to define the structure of content. Use Cascading Style Sheets (CSS) to format Web pages. Use visual Elements and graphics on Web pages. Create and format lines and borders on Web pages. Decide when to use graphics and what graphics are appropriate. Apply the image element to add graphics to Web pages. Configure images as

Unit 2 Assignment 1: Service Provider Types

667 words - 3 pages Brenda Deni NT1310: Physical Networking Unit 2 Assignment 1 3/30/2014 Service Provider Types * RBOCS: Regional Bell Operating Company Service * Regional Bell operating company (RBOC) is a term describing one of the U.S. regional telephone companies (or their successors) that were created as a result of the breakup of American Telephone and Telegraph Company (AT&T, known also as the Bell System or "Ma Bell") by a U.S. Federal

Intro to Programming Unit 1 Research Assignment

697 words - 3 pages Unit 1 research assignment 1 1970’s 1) Pascal, Creator, Niklaus Wirth. The specific motivation behind this language was to encourage good programming practice using structured programming and data structuring. 2) SQL (Structured Query Language) designed by, Donald D. Chamberlin, and Raymond F. Boyce. The motivation behind this language was designed for managing data held in a relational database management system. ( RDBMS) 3) C

Unit 1 Research Assignment 1: Exploring Programming Languages

604 words - 3 pages Unit 1 Research Assignment 1: Exploring Programming Languages NT1420 In the late 1960’s Simula was invented by Nygaard and Dahl as a superset of Algol 60, this was the first language designed to support object-oriented programming. Then between 1969 and 1973 C was developed by Dennis Ritchie and Ken Thompson at Bell Labs. Smalltalk was created in the mid 1970’s that provided a complete ground-up design of an object-oriented language, and

Unit 8 Assignment: 1 Written Reflection On Our Interview

329 words - 2 pages Unit 8 Assignment:1 Written Reflection on Our Interview After conducting my interview, I can say that I walked away from this experience with many a lesson learned. The first lesson that I learned was that after choosing a person to interview, then asking that person, most will jump on the defensive and ask “about what”. This is due to the fact that most people are usually pressed for time. They initially want to know how

Unit 6 Assignment 1 - Ad User Group Design

320 words - 2 pages Unit 6 Assignment 1: AD User/Group Design Scenario To: Junior Admin I received your e-mail asking how to provide access to resources throughout your AD environment and you are not sure which strategies are best for the different situations you are encountering. I would recommend that since you have a domain for each department, such as Marketing, accessing one printer is very easy. To start, you will need to create a group that allows access

Related Essays

Unit 4 Assignment 1

271 words - 2 pages IS3340-WINDOWS SECURITY | Auditing Tools for Windows System | Unit 4 Assignment 1 | | | 5/1/2014 | | 1. You want to schedule a weekly analysis for the Windows servers in your data center. The command should run as a scheduled job and report any available patches for the Windows Server 2008 R2 operating system, Internet information services (IIS) Web server, or structured query language (SQL) server that have not been

Alternative Assignment Unit 1

549 words - 3 pages emails to clarify any questions. Unit 1: It is very important to think why writing matters. What do we try to accomplish by writing? In our day and age, we find that writing includes research, emails, blogs, text…etc we communicate through writing everyday. There are many elements to consider while writing: • Audience: knowing your audience changes the language. • Purpose: reason for writing complaints, catching up with friends, formal writing at work • Context: Considering where this paper or document will be presented, different ways of the writing styles • Writer’s goal: what is the outcome from this writing?

Unit 4 Assignment 1

1067 words - 5 pages 1 Running head: UNIT 4 ASSIGNMENT 1 Fundamentals of Finance BUS 3062 Rodtrice Johnson 3/7/16 Unit 4 Assignment 1 Dennis Hart 1. Q: Proficient-level: "How do Cornett, Adair, and Nofsinger define risk in the M: Finance textbook and how is it measured?" (Cornett, Adair, & Nofsinger, 2016). Distinguished-level: Describe the risk relationship between stocks, bonds, and T-bills, using the standard deviation of

Unit 5 Assignment 1 Video

671 words - 3 pages Unit 5 Assignment 1: Video Summary NT1110 There are two major manufactures we use in today’s market which are Intel and AMD. There are some minor competitions but don’t stay on the market for long. The system bus for the CPU is also known as the Front-side bus as it inserts the CPU and has a 64 bit data pass. In the CPU theirs a controller that controls communication between the motherboard and other components with the CPU. The ALU is