Erd Designing

In: Computers and Technology

Submitted By dherms
Words 373
Pages 2
Description
For this assignment I want to know what players in the NFL are involved in a charity. We only care about the AFC players just for the sake of minimizing the data that would be entered into the DB. Each AFC team has at least one offensive and defensive player involved in a charity. The DB will keep track of what players belong to what team and vice versa. A player can only belong to one team, but one team will have many players. Each player in the DB will have the following attributes, their player number (unique), whole name, jersey number, and the player type discriminator to make it easy to search for even though it could create redundancy. Each player will be categorized into one of two sub-groups of players, offensive and defensive players. NFL players cannot play on both sides of the ball (a player can either be an offensive or defensive player, not both), due to the new collective bargaining agreement. For offensive players we want to keep track of what position they play, offensive players can only play one position due to a safety rule. For defensive players we want to keep track of which position they play, but unlike offensive players a defensive player can play multiple positions. For each team the DB will track the team name (which is unique) and the team location. Each player in this DB will be involved with at least one charity, and possibly others. Each charity in this DB will have at least one player associated with it, and possibly others as well. For each charity the DB will track the name of the charity, and the charity number (which is unique).

DPPosition
DPPosition
OPPosition
OPPosition
ERD
OPLAYER DPLAYER
OPLAYER DPLAYER d d
PType
PType
CHARITY
CHARITY PLAYER TEAM PLAYER…...

Similar Documents

Designing Recruitment

...to train others The benefits from in house Mentoring Program are far reaching. By working with Managers, the Talent Management group will identify and train Mentors in each business unit as well as develop the system to keep track of measurable impact of such program. This program would relate directly to job function and trainee would be provided with one on one consultative style coaching related directly to the job function. This approach would ensure the high performance and high level of engagement of the new employee, especially throughout the On-Boarding phase. The target group for these roles would be older workers which will add to their job satisfaction and engagement with the company. Designing knowledge database and Multimedia Learning Opportunities Designing the E-Learning programs E-Learning has rapidly taken stake in the global workforce for all industry sectors. An effective e-Learning strategy requires three main components: relevant and engaging course content, an effective platform for the delivery of courses, and an ability to manage employee learning. The e-Learning will be most beneficial and cost effective in the area of mandatory training and skills building. Even though it takes time to design and develop, it is proved to be highly cost effective solution to standardize training procedures across an organization and drill down specific skill sets. It is well received by GenX and GenY and would be highly It would highly beneficial in......

Words: 3443 - Pages: 14

Database and Web Designing

... A solid line indicates a mandatory relationship end that is read as "must be". f. unary relationship- Association is maintained within single entity. g. Entity- Used in Logical Data Modeling, an Entity is a thing of significance, either real or conceptual, about which the business or system being modeled needs to hold information. For example, if the business needs to process sales orders, an Entity to represent sales orders would be recorded. An Entity generally corresponds to a physical table. h. Relationship- A named, significant association between two entities. Each end of the relationship shows the degree of how the entities are related and the optionality. i. entity relationship diagram- ERD represents conceptual database as viewed by end user ERDs depict database’s main components: Entities Attributes Relationships j. Cardinality- Expresses minimum and maximum number of entity occurrences associated with one occurrence of related entity. k. Binary relationship- An ER term used to describe an association (relationship) between two entities. Example Professor teaches Course. 2. State the entity types you would expect to find in the following systems: a. A database to store details of your CD collection • Singer, Album, Year, Genre, ratings. b. An estate agent • Name, Contact, Office Address, office contact, land details. c. A travel agent • Agent, phone Contact, Address, destination, reason. d. A student records system for a......

Words: 804 - Pages: 4

Erd in Brief

...An entity-relationship diagram is a data modeling technique that creates a graphical representation of the entities, and the relationships between entities, within an information system.(View diagram.) The three main components of an ERD are: • The entity is a person, object, place or event for which data is collected. For example, if you consider the information system for a business, entities would include not only customers, but the customer's address, and orders as well. The entity is represented by a rectangle and labelled with a singular noun. • The relationship is the interaction between the entities. In the example above, the customer places an order, so the word "places" defines the relationship between that instance of a customer and the order or orders that they place. A relationship may be represented by a diamond shape, or more simply, by the line connecting the entities. In either case, verbs are used to label the relationships. • The cardinality defines the relationship between the entities in terms of numbers. An entity may be optional: for example, a sales rep could have no customers or could have one or many customers; or mandatory: for example, there must be at least one product listed in an order. There are several different types of cardinality notation; crow's foot notation, used here, is a common one. In crow's foot notation, a single bar indicatesone, a double bar indicates one and only one (for example, a single instance of a product can only be......

Words: 534 - Pages: 3

Designing Wearables

...Designing Wearables Richard Hurford, Adam Martin & Povl Larsen Smart Clothes & Wearable Technology Research Group, University of Wales, Newport {richard.hurford1, adam.martin}@newport.ac.uk; plarsen-pdr@uwic.ac.uk Abstract One of the perennial criticisms of work in the field of wearable technology is that nobody seems to be wearing it! This is despite stunning advances in the underlying technology. At the Ninth ISWC there was a feeling that wearable computing development needs to progress on the issue of user acceptability. This poster describes a pilot survey of designers working within the field. The results provide a snapshot of wearable technology design practice and how User Centered Design (UCD) is perceived with the field. majority answered between five and ten people, with six respondents stating they worked individually. The survey was conducted on a multidisciplinary group, with many respondents reported having more than one specific role, these were: researcher (10), textile designer (5), clothing designer (5), artist (3), interaction/interface designer (2), electronics designer (2), software designer (1), other (4), with a mean involvement within the field of 5.4 years (SD 4.09 years). 3.1 UCD and the user Respondents were asked to rate their familiarity with UCD principals, the results were: very familiar (6), familiar (9), some familiarity (8), unfamiliar (4), no knowledge (3). When asked how frequently UCD practice was encountered within wearable......

Words: 1248 - Pages: 5

Designing a Winning Team

...Designing a Winning Team By: Vadim Dyachenko Management 521 2/19/2014 Ross Hopkins A company that employee’s more than 800 people has just realized there is a new market for their product. Leadership quickly assembled a new department in order to react and capitalize on the trend. It was thought that teams of four would be the most efficient way to move quickly and approached me with a proposal to run one of the teams. My manger has given me the results of my and three of my teammates, chosen by the leadership, personality test results. Putting me in charge to place everyone according to their strengths and weaknesses. Since we need to move quickly my team will be spearing a marketing and a sales blitz effort in order to gain a large market share on the product before it hits the general market. My goal is to create a democratic team that works together on all decisions and moves like a well-oiled machine. Placement of each member is more crucial in this leadership setting as everyone needs to pull equal weight, thus using factual and accurate test results are necessary to have a greater chance of success. Below is the breakdown of each team member personality analysis and the reason for placement in each position. Sasha scored ENTJ n his test results. This tells me primarily that he is a visionary, but has a low tolerance for incompetence. He works well with others and is very outgoing so being a leader comes naturally to Sasha. Placing him in a Senior Project......

Words: 927 - Pages: 4

Designing in the Tropics

...DESIGNING AND BUILDING IN THE TROPICS* Bruno Stagno In that vast moment, I saw millions of actions, some pleasurable, some horrible; none of them amazed me as much as the fact that they all existed at the same point, not superimposed, and not transparent. What my eyes saw was simultaneous. Jorge Luis Borges, El Aleph TRADITION AND AVANT-GARDE Traditional architecture and the avant-garde tendency are usually thought of as two opposed extremes. Because we are accustomed to defining tradition as something fixed, immovable, and the avant-garde position as what is progressive, we relate traditional architecture to a specific, pre-existing style and avant-garde architecture to the use of new technologies. When tradition plays a part in contemporary architecture it is most frequently as an aesthetic consideration in which the most obvious element is the use of some style from the past. At the other end of the spectrum is the avant-garde tendency, where the latest technology is the means architects use to achieve novel forms of expression. Both of these perceptions are limited. Not only are they presented to us as two extremes of one thing, opposed to one another, but also as excluding one another. An architecture that follows a given style cannot be avant-garde because it makes use of compositional rules derived from the past; it is backward-looking and dependent on various forms of counterfeit to create the look of a bygone era. It is this tendency...

Words: 5561 - Pages: 23

Costume Designing

...Costume Designer What is costume? Costume is clothing which is worn by actors on stage, film and television to portray their character and blend into their scene. What is a costume designer? A costume designer is a person who designs costume for actors on stage/film or T.V, he/she may do this by making the costumes from raw materials or simply just buying the costumes or maybe even borrowing from other companies to get the job done. Their responsibilities include designing the costume to satisfactory condition in order for the costumes to fit the actors and also having them completed by deadlines. Who do the work with? They work with a number of people and they are directors, actors, financial teams, wardrobe and lighting. They would work with directors as they need to know what costumes they need and need to get the description from them. They work with actors as they need to get their body measurements and make sure each actor has their costume fitted to their standard. They work with the financial team as they provide the budget for all the materials and costs without the financial team costumes wouldn’t be made. They work with the wardrobe as they give them the roles and tasks to make sure everything is done on time and finally they work with the lighting to work out which lights would look good with which costume. What does the job entail? The costume designers would sit in rehearsals so they can have a feel about what the play is like...

Words: 658 - Pages: 3

Designing Visual Effective Communication

...Designing Visual Effective Communication Names Institutional Affiliation Result from self-administer questionnaire 1(a), 2(a), 3(a), 4(a) 5(b), 6(b), 7(c), 8(b), 9(a), 10(b), 11(c), 12(c), 13(c), 14(a), 15(a), 16(a), 17(c), 18(a), 19(b), 20(a), 21(a), 22(a), 23(a), 24(a), 25(c), 26(b), 27(a), 28(c), 29(c), 30(b). Result tallying: total number of a=15, b= 7 and c= 8 Result from the second person 1(a), 2(a), 3(a), 4(c) 5(b), 6(b), 7(c), 8(a), 9(b), 10(b), 11(c), 12(c), 13(a), 14(c), 15(a), 16(c), 17(c), 18(b), 19(b), 20(c), 21(a), 22(a), 23(b), 24(a), 25(c), 26(b), 27(a), 28(a), 29(a), 30(b). Result tallying: total number of a=12, b = 8 and c=10. The design of visual communication is composed of the modeling of visual language and graphic design with the motive of relaying information, ideas and messages in the field of industrial design. In order to create effective visual communication design, the designer should develop design skills to manipulate and organize elements, design principles, production method, selected media and materials(Brown, 2007). Successful design of efficient requires the designer to have the ideas of the kind of learning style of the recipient. The main aim of the designer is effectively to convey a message that is clear accessible and easy to understand to the end user. Various learning styles have enormous implications for the visual communication (Bergström, 2008). These learning styles enlighten the designer on matters pertaining to......

Words: 782 - Pages: 4

Bis245 Week 3 Lab - Visio Erd

...BIS245 Week 3 Lab - Visio ERD Click Link Below To Purchase or visit homework-aid.com : http://homework-aid.com/BIS245-Week-3-Lab-Visio-ERD-1787.htm?categoryId=-1 Part A: Create a Visio ERD from Data Requirements and Business Rules Step 1: Open Visio a. Open Microsoft Office, Visio application or b. If you are using Citrix, click on Microsoft Office Applications folder to start Visio. Step 2: Identify and create the entities a. Open a new blank Database Model Diagram. b. Save the file as YourName_Lab3.vsd. c. Based on the information provided below, create the necessary entities for the Pages in Time database. If you need assistance to create the entities, refer to labs from Weeks 1 and 2. Pages in Time Pages in Time is a small bookstore carrying a variety of books. The owners have decided to computerize the books available through the store so that they can determine more easily what books are on hand and which books need to be special ordered to meet customer needs. Because customers do not always remember the name of a desired book, the owners want to be able to look for books by author or by type (genre). They also want to be able to find the publisher s information using the system so that they can order books more easily. After visiting with the owners, you have gathered the following information on data requirements and business rules to develop a conceptual design (ERD), prepare it for conversion to an Access......

Words: 1019 - Pages: 5

Designing for Security

...Midterm Examination Written Responses Presented in ITS-331 Designing for Security By QUESTION 1 In Chapter 1 of Weaver, Weaver, and Farwood (2013), we considered various THREATS to network security, the FUNDAMENTAL goals of network security, and how LAYERED approaches to defense contributed to the overall security posture of an organization’s information infrastructure. Chapter 2 explored Transmission Control Protocol / Internet Protocol (TCP/IP), the Open Systems Interconnect (OSI) Model, and how various protocols operated within, as well as across OSI layers to enable telecommunications to function. In a scholarly peer-reviewed journal article entitled: "Cyber security in the Smart Grid: Survey and challenges," Wang and Lu (2013) examined security requirements, network vulnerabilities, attack countermeasures, secure communication protocols and architectures in the U.S. Smart Grid. Based upon what you read in Chapters, one, and two of Weaver et al. (2013), as well as the journal article, COMPARE and CONTRAST Vulnerabilities, Attacks, or Threats shared from the text against those provided within the journal article. IDENTIFY Three Similarities AND Three Differences that exists between the text and literature. Wang, W., & Lu, Z. (2013). Cyber security in the Smart Grid: Survey and challenges. Computer Networks, 57(5), 1344-1371. Weaver, R., Weaver, D., & Farwood, D. (2013). Guide to Network Defense and Countermeasures (third Ed.). Boston, MA: Course......

Words: 1934 - Pages: 8

Designing for Dollrs

...“Design is not what it looks like or feels like, design is how it works” -Steve jobs Designing for Dollars (Design Investment Decisions) Would you characterize product design decisions as structured or unstructured problems? A mix. Product design is a balance of art and science. The first thing designers do on any new product design is to explore its basic form (what it looks like). This is not a scientifically structured phase, rather it relies on one's having a "good eye" for aesthetic. Once that's finished, then the structured phase begins: defining geometry, understanding the interfaces, applying appropriate materials, etc. Ultimately product development is a back and forth iteration with both structured and unstructured phases. 2. Describe and evaluate the process Chuck went through to change the way design decisions were made. Describe and evaluate the company’s new design decision process. Making great decision of a consumer product is a critical challenge for the companies. In case of failing the customer, it leads to the decrease in market of that particular product. For example, according to this case study, the product designer Mr. Chuck Jones is realizing that the process of making design decisions should be improved. But the difficulty is the extra cost occuring of 5 dollars and being asked by the management what would be the return on investment, and he doesn't...

Words: 637 - Pages: 3

Designing a Program

...Designing a Program When creating anything no matter what it is, a good design is always going to be very beneficial and in most cases required. When creating a new program, designing it will make things so much easier. Designing a new program will allow you to “see” what steps you need to accomplish in order to get what you want. In the long run it also save time because without a good design you would just be going into the project blindly and will more than likely need redoing over and over again. Designing a program using algorithm, flowcharts and pseudocode are all very important and I will use all of them but I think that the most important one would be the algorithm. We need to know what steps we need to take in order to get the results that the customer wants. Without the algorithm you really wouldn’t know what to put in the flowchart or what needs to be in the mock up or pseudocode. So for me the algorithm is the most important part of the designing process. Now let’s say we wanted to start a new project to design a game but didn’t want to take the time to design it. Well where would you start? I guess pull up the IDE that you will be working with and then? What do you want the game to be about? What do you need to do in order to play the game? I mean where do you start? That’s why designing is almost a necessity. References Gaddis, T. (2012). Starting Out with Programming Logic & Design, Custom Edition. [VitalSource Bookshelf Online]. Retrieved......

Words: 286 - Pages: 2

Designing the Experience

...Designing forAn Experience: Design Approach to Human-centered Jodi L. Forlizzi Designing forAn Experience: Design Approach to Human-centered Jodi L. Forlizzi Submitted to the Department of Design, College of Fine Arts, Carnegie Mellon University, in partial fulfillment of the requirements for the degree of Master of Design in Interaction Design © Carnegie Mellon University, 1997. All Rights Reserved. Author Advisor Richard Buchanan Department Head & Professor of Design Carnegie Mellon University Advisor Suguru Ishizaki Assistant Professor of Design Carnegie Mellon University May 1997 Designing forAn Experience: Design Approach to Human-centered Jodi L. Forlizzi Submitted to the Department of Design, College of Fine Arts, Carnegie Mellon University, in partial fulfillment of the requirements for the degree of Master of Design in Interaction Design Abstract My thesis attempts to understand experience as it is relevant to interaction design. Based on the work of John Dewey, Mihalyi Csikszentmihalyi, and Richard Carlson, I identify two types of experience in user–product interactions: satisfying experiences and rich experiences. A satisfying experience is a process–driven act that is performed in a successful manner. A rich experience has a sense of immersive continuity and interaction, which may be made up of a series of satisfying experiences. Based on this definition, I identify a set of design principles with which to create products that...

Words: 13374 - Pages: 54

Designing Compensation

...Designing Compensation Systems and Employee Benefits 1. Describe the differences between job analysis and job evaluation and how these practices help establish internally consistent job structures. Job analysis is the fundamental process that creates the support of all human resource activities. It is also explained in a clearer way as the process of gathering, documentation and analyzing information about the work needs for a job. The information collected in a job analysis, and reflected through a job description; contain a description of the framework and the principal requirements of the job, and information about the skills, responsibilities, mental models and methods for job analysis. They include, the Position Analysis, Questionnaires, which converge on generalized human behavior and interviews, task inventories, fundamental job analysis and the job element method. A job analysis gives a goal picture of the job, not the person implementing the job, and as such, provides fundamental information to aid all subsequent and related HR activities, such as recruitment, training, development, performance management and succession planning. Job analysis is the method for acknowledging responsibilities or behaviors that describe a job. Separately from attesting the integrity of selection methods, job analysis is the support of virtually scales every other section of industrial psychology, involving performance appraisal training and human elements. Furthermore, job analysis......

Words: 1367 - Pages: 6

Designing Global Strategies

...SMR001 rP os t MIT Massachusetts Institute of Technology Summer 1985 Designing Global Strategies: Comparative and Competitive Value-Added Chains No Bruce Kogut tC op yo Volume 26 Number 4 Do Reprint 2642 This document is authorized for use only by Fernando Juarez until October 2010. Copying or posting is an infringement of copyright. Permissions@hbsp.harvard.edu or 617.783.7860. PDFs I Reprints I Permission to Copy I Back Issues Electronic copies of MIT Sloan Management Review articles as well as traditional reprints can be purchased on our web site: www.mit-smr.com or you may order through our Business Service Center (9 a.m.-5 p.m. ET) at the phone numbers listed below. op yo To reproduce or transmit one or more MIT Sloan Management Review articles by electronic or mechanical means (including photocopying or archiving in any information storage or retrieval system) requires written permission. To request permission, use our web site (www.mit-smr.com), call or e-mail: rP os t MITSloan Management Review Toll-free in U.S. and Canada: 877-727-7170 International: 617-253-7170 e-mail:smrpermissions@mit.edu To request a free copy of our reprint catalog or order a back issue of MIT Sloan Management Review, please contact: MIT Sloan Management Review 77 Massachusetts Ave, E60-100 Cambridge, MA 02139-4307 Do No tC Toll-free in U.S. and Canada: 877-727-7170 International:......

Words: 7808 - Pages: 32

Sheena, Queen of the Jungle | Adventures of the Gummi Bears (95) | 12.15 살림9단의 만물상.E273.181214.720p NEXT