Premium Essay

Ecd Diagram

In:

Submitted By puneetmaan
Words 1207
Pages 5
Example Case to 3NF Tables

Purpose

The COIS20025 textbook and assignments have numerous exercises that require you to take a given case and generate a data design for the case. The data design will typically consist of an ERD, 3NF table designs including keys (obviously) and sample data.

The purpose of this document is to give an example of how to do this. It walks you through the process of completing this task.

Preparation

This document draws on "Developing Entity Relationship Diagrams (ERDs)" available from the Assignment 2, Resources page. You should become familiar with that resource before going any further.

The Case

This document will use the same case as used in the "Developing Entity Relationship Diagrams (ERDs)" document. It is included below.

A company has several departments. Each department has a supervisor and at least one employee. Employees must be assigned to at least one, but possibly more departments. At least one employee is assigned to a project, but an employee may be on vacation and not assigned to any projects. The important data fields are the names of the departments, projects, supervisors and employees, as well as the supervisor and employee number and a unique project number.

You are required to:
1. Create an ERD with cardinality notation.
2. Create 3NF table designs.
3. For each of the entities identified, design tables and identify the possible candidate keys, the primary key, a probable foreign key, and potential secondary keys.
4. Use sample data to populate the fields for three records.

Create the ERD

This process is already shown in the "Developing Entity Relationship Diagrams (ERDs)" document. Please read through that document for an explanation of how it is done. The fully attributed ERD developed in that document is shown in Figure 1.

[pic]
Figure 1
Completed ERD.

Create the 3NF Tables

This process has

Similar Documents

Free Essay

Science

...Zones  Social Zones o   o Private Zones o Entries; living, dining, and family areas; rec rooms, home theaters; solariums, outdoor living; hallways Conversation, watching TV, listening to music, playing games, dining, etc. Bedrooms, dressing areas, bathrooms; private sitting or retreat areas o “Quiet” areas often separate from the rest of the house Service (Work) Zones o o Kitchen, laundry; workshop, craft/hobby; office; utility and mechanical storage Efficiency, energy conservation, and recycling important issues  Zone within Zone o Provides for a specific task located within a different zone o Computer in living, dining, or family area; computer in bedroom FLOOR PLAN DEVELOPMENT Schematics  Utilize schematic diagrams to...

Words: 367 - Pages: 2

Premium Essay

Essay Writing Guide

...Levi’s Essay Writing Guide Compiled by Levi Whitten-Connolly 15 September 2010 Page: 1 Below I have prepared a few pages to help guide you write a few essays – these are taken from my own notes. Page: 1 © 2010 Levi Whitten-Connolly (levi@whitten-connolly.net) Levi’s Essay Writing Guide Compiled by Levi Whitten-Connolly 15 September 2010 Page: 2 Page: 2 © 2010 Levi Whitten-Connolly (levi@whitten-connolly.net) Levi’s Essay Writing Guide Compiled by Levi Whitten-Connolly 15 September 2010 Page: 3 Page: 3 © 2010 Levi Whitten-Connolly (levi@whitten-connolly.net) Levi’s Essay Writing Guide Compiled by Levi Whitten-Connolly 15 September 2010 Page: 4 Page: 4 © 2010 Levi Whitten-Connolly (levi@whitten-connolly.net) Levi’s Essay Writing Guide Compiled by Levi Whitten-Connolly Mind Maps 15 September 2010 Page: 5 Mind Maps are a great way to organise your essay before you write it – they are als a great tool for writing down key information points before an exam. Below is an example of a mind map – make sure when you write one out that you colour code each section as your brain remembers things better this way. Page: 5 © 2010 Levi Whitten-Connolly (levi@whitten-connolly.net) Levi’s Essay Writing Guide Compiled by Levi Whitten-Connolly 15 September 2010 Page: 6 Page: 6 © 2010 Levi Whitten-Connolly (levi@whitten-connolly.net) Levi’s Essay Writing Guide Compiled by Levi Whitten-Connolly 15...

Words: 251 - Pages: 2

Premium Essay

Facebook

...| | ASSIGNMENT COVER SHEETElectronic or manual submission | UNITCode: CSG1132Dname: communicating in an it environment | NAME OF STUDENT (PRINT CLEARLY) Wickramasinghe Sarith FAMILY NAME FIRST NAME | STUDENT ID. NO.Wisac133 | NAME OF LECTURER (PRINT CLEARLY)Mrs Kala peris | DUE DATE05/08/2014 | Topic of assignmentuser mortivation in the use of social media | Group or tutorial (if applicable)      | CourseDiploma in computing | Campusacbt | I certify that the attached assignment is my own work and that any material drawn from other sources has been acknowledged. Copyright in assignments remains my property. I grant permission to the ACBT to make copies of assignments for assessment, review and/or record keeping purposes. I note that the ACBT reserves the right to check my assignment for plagiarism. Should the reproduction of all or part of an assignment be required by the ACBT for any purpose other than those mentioned above, appropriate authorisation will be sought from me on the relevant form. | OFFICE USE ONLY | If handing in an assignment in a paper or other physical form, sign here to indicate that you have read this form, filled it in completely and that you certify as above. Signature Date       | | OR, if submitting this paper electronically as per instructions for the unit, place an ‘X’ in the box below to indicate that you have read this form and filled it in completely and that you certify as above. Please include this page in/with your...

Words: 1101 - Pages: 5

Free Essay

Kristen's Cookie Company

...Case Report: Kristen’s Cookie Company Question 1 How long will it take to fulfill a rush order? | Gantt Chart for Kristen's Cookie Case | | | | | | | | | | | | | To fulfill the rush order it is still necessary to go through all parts of the process illustrated on the process flow diagram of the cookie-making process (it can be found on the last page). As there are no processes that can be done in a parallel way, every stage follows the other. Calculating the time needed for each step it can be concluded that the order can’t be prepared less than in 26 minutes. Question 2 How many orders can you fill in a night, assuming you are open 4 hours each night? We already know from the first question, the first dozen can be fulfilled in 26 minutes. Lets have a look, on the fastest possible way to prepare the second and all the following dozens. I can start preparing the 2nd order as soon as I start heating the oven (the chart visually demonstrates it): According to the chart it takes 26 minutes to fill the first order and 10 minutes more to fill each following order. From here we have: Operating time = 4*60 = 240 minutes The formula for counting the amount of orders that are able to be produced can be seen as: 16+10n <= 240 where n is the numbers of orders. From this equation we get, that n(max) = 22 dozen. So during 4 hours in a night one can prepare 22 dozen of cookies in 236 minutes. Question 3 How much of your own and your roommate’s valuable...

Words: 807 - Pages: 4

Premium Essay

It Paper

...System Analysis Design for a Library System CS200 Fundamentals of Information Technology Module 1 Assignment 2 System Analysis Design for a Library System Suppose you are helping to develop a library system for your community. Here is a brief description of various scenarios using this library system. • Bob wanted to become a member at his local library. He went in and filled out an application form with his name, address, phone number, and driver's license number and gave it to the librarian, Alice. Alice logged into the system with her id and created a new membership for Bob. She then provided Bob with his new library card, and a login and password to his account. • Bob wanted to borrow two novels by C.S. Lewis, but he couldn’t remember their names. He used one of the computers at the library to search for the books by using the author's name. He found the titles he wanted, which were “The Chronicles of Narnia” and "The Space Trilogy". The first book was shown as available, and the second book was shown as out on loan. • Using his new login and password, Bob logged into his account and requested the book "The Space Trilogy" in order to recall it, so that when the book was returned it would be held for him at the library. • Bob then went to the stacks and found the book "The Chronicles of Narnia" on the shelf, and waited in line at the desk to check it out. He presented his ID card, and checked out the book with the librarian. • Before leaving the library...

Words: 607 - Pages: 3

Free Essay

Cis 510 Wk 4 Assignment 2 Creating a Context Diagram

...WK 4 ASSIGNMENT 2 CREATING A CONTEXT DIAGRAM To purchase this visit here: http://www.activitymode.com/product/cis-510-wk-4-assignment-2-creating-a-context-diagram/ Contact us at: SUPPORT@ACTIVITYMODE.COM CIS 510 WK 4 ASSIGNMENT 2 CREATING A CONTEXT DIAGRAM CIS 510 WK 4 Assignment 2 - Creating a Context Diagram Refer again to the information about the Reliable Pharmaceutical Service (RPS) at the end of Chapter 1, “The World of the Information Systems Analyst.” Write a two to three (2-3) page paper in which you: 1. Create a context diagram using Visio or its open source alternative software based on the information provided. Note: The graphically depicted solution is not included in the required page length. 2. Write a narrative describing the diagram. The narrative should include: a. An overview of the diagram. b. A description of the primary system users. c. A description of the information exchanged between the users and the system. Activity mode aims to provide quality study notes and tutorials to the students of CIS 510 WK 4 Assignment 2 Creating a Context Diagram in order to ace their studies. CIS 510 WK 4 ASSIGNMENT 2 CREATING A CONTEXT DIAGRAM To purchase this visit here: http://www.activitymode.com/product/cis-510-wk-4-assignment-2-creating-a-context-diagram/ Contact us at: SUPPORT@ACTIVITYMODE.COM CIS 510 WK 4 ASSIGNMENT 2 CREATING A CONTEXT DIAGRAM CIS 510 WK 4 Assignment 2 - Creating a Context Diagram Refer again to the information about...

Words: 574 - Pages: 3

Premium Essay

Nt1310 Unit 1 Assignment

...1A) STUDENT NAME:- RENISH SURANA STUDENT ID:- 100670335 ASSIGNMENT 1(DAD) TASK 1 1B) One state many have many supplier. One supplier may purchase many products. One product must belong to one category. One category may have many products. One product must be purchased from one supplier. One supplier must be located in one state. 1C) THE RELATIONAL SCHEMA ARE:- --CATEGORY(Catcode,Catname) --primary key Catcode -- --STATE(Statecode,Statename) --primary key Statecode -- --SUPPLIER(Suppcode,Suppname,City,Statecode) --primary key Suppcode --foreign key Statecode References STATE -- --PRODUCT(Prodid,Descr,Sellingprice,Purchasecost,Weight_kg,Suppcode,Catcode) --primay key prodid --foreign key suppcode References SUPPLIER --foreign key Catcdode References CATEGORY -- 1D) --Prompt Creating Table Category; create table CATEGORY ( catcode varchar2(4), catname varchar2(30), primary key (catcode) ); --Prompt Creating table STATE; create table STATE ( statecode varchar2(4), statename varchar2(30), primary key (statecode) ); --Prompt Creating Table SUPPLIER; create table SUPPLIER ( suppcode number(4), suppname varchar2(30), city varchar2(30), statecode varchar2(4) , primary key (suppcode), foreign key (Statecode) References STATE ); --Prompt Creating Table PRODUCT; create table PRODUCT( prodid number(4), descr varchar2(30), sellingprice number(6,2), purchasecost number(6,2), weight_kg number(6,2), suppcode number (4), catcode varchar2(4),...

Words: 679 - Pages: 3

Premium Essay

Nt1310 Unit 5 Assignment 2 Area 5

...I continued transferring the data I gathered last Friday. I had scheduled my self that I need to finish the reports by 10:00 am to start the tasks given by Sir TJ and Ma’am Loi. Sir TJ asked me to determine the time it takes to finish the four tests in the PCM Wire bond Area 4 and Area 5. The tests included were Ball Shear Test, Wire Pull Test, Ball Access Ratio, and Loop Height. For Area 4 I had already data regarding the Ball Shear Test and the Wire Pull Test, so I just need to time the remaining two test. However, I need it would be my first time for the four tests in Area 5. Moreover, I need to identify what type of die (quad or dual) was being processed. On the other hand, ma’am Loi urgently needs the data about the length of time it takes to finish the Vacuum Dry Pack Operation in Packing Area EOL Area 5. It was already 9:30 but I was still organizing the data for the utilization report. The utilization project was the hardest I had handled so far, because I need to continously observe the time of both the operator and the machine. Ma’am Gem came and asked me if I had sent it to her. I told her that I am still typing the utilization report for Day 2 but I am already done with Day 1. She told me to send the report for her to see the results. She sat beside me and asked about the details of my report. We found out the only 37% was the utilization of the machine and the operator for four hours I conducted TMS. We were discussing about the results and I was struggling to continue...

Words: 784 - Pages: 4

Free Essay

Unit 4 Project

...IT460 Unit 4 Assignment Dwayne M Sullivan Kaplan University Context Level Diagram This context diagram shows the scope and boundaries of the Training Information Management System. In this diagram, we see that the central process, which is the TIMS, will interact with six entities, which include the corporate client, the training administrator, the instructor, the student, the course, and the accounting system. Moreover, the interaction among these entities will involve six different data flows. The corporate client will be provided a training summary. The training administrator will receive training reports and will supply schedule decisions. The instructor will supply completion data and receive a class roster and course assignments. The accounting system will receive data regarding accounting. The course will receive course data from and supplied data back to the system. The student will request courses. When their request is processed, they will receive a confirmation and an invoice. The student can then submit a payment. Level 0 Diagram The training administrator will submit schedule decisions which are processed by the manage course scheduling process. The course management scheduling process will supply information about the course offered. This information might include course times, schedules, descriptions and so forth. The manage course scheduling process will also receive information from the courses. The Manage Course Scheduling process...

Words: 694 - Pages: 3

Premium Essay

Osamah Alqurashi

...in an organization. For this a comparative study of paper based system against ES system is being undertaken. In this report we develop the diagrams of two process the benefits of other 2- a- Diagram of paper based process b- Disadvantages of paper based process * Too much paper work, many documents are created to capture and transfer data/information. * Due to paper work there is always a chance of incorrect capturing of data and mistakes. * Requires physical transfer of data, through sending documents to other departments. * Redundancy/duplication of data at several places. * Analysis of information and it’s reporting is laborious hectic and might not be accurate. * Delays, all the tasks in a paper based environment takes longer time, causing waste of resources as well. c- Diagram of Enterprise based process d- Benefits of ES process * Based on common, shared database, can be used across the whole organization. * Minimum of paper work * Easier input, and access to Data/information. * Easier analysis and reporting * Minimize data entry/transfer error. * Minimize time * No redundancy of data, No data conflicts * Integration of business functions and processes 3-Conclusion: From the basic thing in the report is you have to summaries the work, also study the diagram to find out what is the disadvantages of paper based process and what are the benefits of ES Process The result would be that ES based processes...

Words: 301 - Pages: 2

Premium Essay

Revision Strategies

...AND ALBERT SCHOOL Revision Strategies General for all subjects: • Exam structure (essay-based subjects) • Use the exam specification (all subjects) • Reading over revision notes • Completing past papers AND learn from the mistakes made • Question practice • Put down enough points to reflect the number of marks eg 2 marks = 2 points • Questions – time management: set time depending on the marks allocated to the question • Look at model answers • Plan answers • Repetition Exercises • Test yourself at the end of each chapter where possible using exercises at the end of the chapter and get others to test you • Summarise Work (note-taking) • Making and using flash cards – particularly useful for key terms, formulas or diagrams • Record yourself speaking and put on an iPod (particularly useful for languages) • Make sure environment is conducive to revision • Music • Nice food to keep you going and to use as a reward • Study leave is important but take regular breaks • Focused group and paired revision – possibly using white board • Teach subject to others • Hold discussions • One to one session with teacher • Use of dictionary • Anagram of dates • Revision Posters (all subjects) • Mind Maps Creating mind maps on topic areas/key terms - most useful on really large sheets of paper – colour co-ordinated • Writing it out again in own words • Highlight key words/ideas/concepts/points • Revision cards/notes – key points and definition, colour...

Words: 291 - Pages: 2

Free Essay

Concept Map

...NUR1099 Professional Nursing for the Older Person Assessment Two Template Marks out of 100 Weighting: 70% Due: Week 9 Thursday 13th September 2012 & Upload via Ease There are five main categories for this assessment. Please use this template for categories 1,3, 4 & 5, while category 2 is the concept map and will require the mind map software to complete. The mind map is to be uploaded as a separate document into ease with this completed Assessment Two template. 1. KWL Chart (20 marks) 2. Concept Map (25 marks) 3. Written prose – justification (35 marks) 4. Nursing Process of Care – Care Plan (20 marks 5. Academic writing and referencing. (Deductions up to and including 5 marks) The following information on pages two - six of this document details each category. 1. 1. KWL - Using the ‘KWL’ template provided, fill in the four column template. Theme Headings – Identify ten major themes for approaching holistic patient care K – What do I already know about the older person and caring for the older person? W – What do I want/need to know about the older person and caring for the older person? L – What have I learnt about the older person and caring for the older person? Theme Headings(Identify the ten major themes) | K | W | L | 1. | | | | 2. | | | | 3. | | | | 4. | | | | 5. | | | | 6. | | | | 7. | | | | 8. | | | | 9. | | | | 10 | | | | (20marks) 2. Concept Map – (Please...

Words: 1929 - Pages: 8

Premium Essay

Article Critique

...Article Critique MGMT Jacobson, Janet (2009). “Quality club teaches today’s learners to become tomorrow’s leaders.” A group of young students gather to study quality tools such as affinity diagrams, run charts, and histograms. Koality Kid Club at Hunter Ridge School won the 2008 Academic excellence award and serves 700 kids from kindergarten to sixth grade with knowledge and understanding of leadership skills they will need to become the next leaders of our country. These kids are handpicked judged by the qualities of responsibility, good listening skills, comfortable speaking in front of peers, and cooperation with students and adults. These are the qualities of a good leader and deserve to be treated in an honor program to help build on these leadership skills. This has been a great program not only for the kids but the teachers as well. It gives the students the extra edge they need to make it in the real world and it also gives the teachers a sense of purpose in these kids’ lives. In the program, the teachers go over simple tools such as a run chart, affinity diagram, and fishbone diagram. They relate these simple tools to everyday situations at home such as organizing a birthday party. It not only prepares them for later on in their lives but also helps them exercise these skills in the present. This is a great program for a gifted child that deserves to be treated like the leaders that they have the potential to be. The only question I have regarding...

Words: 302 - Pages: 2

Premium Essay

Sour Grapes Case Study

...Case Study 8.1: Sour Grape Ice Cream Kelly Epps Reyes Grantham University Case Study 8.1: Sour Grape Ice Cream There are seven common quality tools that the Quality Ice Cream Company could use to understand and improve processes during a production run with the Sour Grape Ice Cream. Flow Chart, Run Chart, Process-Control Chart, Check Sheet, Pareto Diagram, Cause-and-Effect Diagram, and Scatter Diagram. Each of these tools helps to identify sources of variation and aids in the analysis, documentation, and organization of the information, which will leads to process improvement. The company should start with a flowchart or process map to visually represent relationships among the activities and tasks that make up a process. At high levels, process maps help you understand process complexity. At lower levels, they help analyze and improve the process. This will give the company a better idea of what is causing the rejections form happening. A scatter diagram should be made from the data, collected by the production operator. This will show the relationship between the run time and the viscosity of the ice cream. This will also help in finding out how long the ice cream should be mixed for to keep the ice cream from being too soupy or too stiff. From the data collected over the 10 days, it seems like it is not run for enough time, most of the time, resulting in a too soupy product. (Sower, V. 1996, pg. 201-202) After the best run time is determined, they...

Words: 463 - Pages: 2

Premium Essay

PEGN 361: Completion Engineering

... PEGN 361: Completion Engineering Section A Maurice Polycarp MPOLYCAR Project 2 Pages: Date: 4/20/2016 Minimum Casing Requirement (Onshore) There are a few types of casings which are commonly installed. Therefore, it is imperative to understand the design criteria for these casings in order to prevent any well problems. 1) Conductor Casing Conductor casing is the first pipe installed in the wellbore. It is shallow and serves to prevent the hole from washing out under the rig. It also supports the weight of other casing strings. Besides, it returns drilling fluids to elevated pits while drilling the next section of the well. For the burst design of conductor casing, the internal pressure should be the lower value of either the 2) Surface Casing Surface casing serves to protect freshwater aquifer and also protects the borehole from potentially poor shallow formations. It is also the initial anchor for the blowout prevention equipment (BOPE). It also helps suspend the weight of the remaining casing strings. For burst design, the internal pressure of a surface casing should be the lesser value of either the fracture gradient pressure at its shoe or the maximum formation pressure in the next hole section less a gas gradient. On the other hand, the external pressure should be assumed to be 0 kPa at the surface and to have a 10 kPa/m fluid gradient. There are three available design factors while considering burst design. First, a design factor of 1.1 should be used for sweet...

Words: 1374 - Pages: 6