In this lab, you will draw a relationship diagram for two of the steps shown. Keep in mind when you are trying to decide which side of the relationship should be the "one" side and which should be the "many" that you must first decide which side has the primary key, or unique identifier.
Once you have decided the primary key of the relationship, you have identified the "one" side of the relationship. Note that for an RD, the foreign key "many" side of the relationship points to the primary key "one" side. The "one" side should have the arrowhead point of the connecting line.
This will familiarize you with how to set up MS Visio to draw database diagrams. The Customer table records clients who have placed orders. The Order table contains the basic facts about customer orders. The Employee table contains facts about employees who take orders.
Step 3 will require you to analyze the scenario given and present your own resolution to the question. Step 4 is an individual assignment that will introduce you to the group project and the process of identifying entities and attributes.
When finished with the lab, you should have a complete diagram using all 5 entities, a written explanation for 3, and two lists entities and attributes for Step 4. You should copy and paste the diagram from MS Visio into a Word document and use this document for Steps 3 and 4.
Drawing your first ER diagram Title Identify the foreign key columns in the table structures above and draw a relationship diagram depicting the relationships between the tables.
For each relationship, identify the table on the "1" side of the relationship and the table on the "Many" side. Table definitions for the table structures and primary keys constraints are shown below. When finished you should have a total of 5 tables represented in your diagram for this problem.
To copy and paste the diagram into Word, select Edit from the menu and then Copy Diagram. Should a NULL be allowed?
From examination of the sample data and your current understanding of businesses in which orders could be placed either in person, over the phone, or over the Internet, determine if it would be permissible for null values to be allowed for the foreign key EmpNo in the Order table.
This column would reference back to the EmpNo column in the employee table. Why or why not? Initial Project Exercise Although the overall project itself will be done as a group, this first exercise is designed as an individual effort and is intended to; 1 get you to read the project specifications, and; 2 introduce you to the first step in designing a database from scratch.
This little exercise will have you see how many entities and attributes you can find in the project specifications. In week three, you will work with your assigned project team and compare notes on what you have found.
This is not rocket science here so remember, you are looking for people, places, things, and events entities and the attributes that describe them. You will be given a business scenario for a company named Clapham Specialty Store, which is a small specialist grocery and delicatessen.
The business specifications will outline a number of things about the business, some of which will apply directly to the database you are being asked to model.
There is a table which lists the entities tables that will be needed for the database and related attributes columns for each entity.
There is also a column that lists specific information about the entity that will be helpful in determining its relationship to other entities within the model.
Be sure to include the minimum and maximum occurrences of each relationship cardinality and to supply a name to the relationship that will work in both directions. If there is not a single word that will apply, then supply a separate name for each direction of the relationship. A new owner, John Balfour, who would like to expand the store and improve its profits, has recently purchased the store.
The store sells general groceries, wines and liquors, and has a small deli counter.Related posts:?BSHS Week 4 Individual Literature Review Paper ; BSHS COURSES / SNAPTUTORIAL?BSHS Week 5 DQ 2 ; RES WEEK 4 INDIVIDUAL ASSIGNMENT UNDERSTANDING BUSINESS RESEARCH TERMS AND CONCEPTS PART 1.
Check out our top Free Essays on Bshs Week 4 Quiz to help you write your own Essay. Invited audience members will follow you as you navigate and present; People invited to a presentation do not need a Prezi account; This link expires 10 minutes after you close the presentation; A maximum of 30 users can follow your presentation; Learn more about this feature in our knowledge base article.
Bshs Week 4 Quiz Essay; Bshs Week 4 Quiz Essay. Words May 26th, 5 Pages. Show More. Please pick 3 of the provided topics, your choice, and define AND provide a solid real-life example for each topic. Each question is worth (1) point total.
It will be scored ½ point for your definition and ½ point for your example. Bshs Week 4 Quiz. Eth Week 4 Quiz. ETH Week 4 Quiz Ch. 5 Ethnicity and Religion This is a multiple choice quiz and each item is worth two points for a total possible of 50 points.
There is only one correct response for each numbered item, and you should use the Schaefer text as needed to determine the best response.
Bshs Week 4 Quiz Essay; Bshs Week 4 Quiz Essay. Words May 26th, 5 Pages. Show More. Please pick 3 of the provided topics, your choice, and define AND provide a solid real-life example for each topic. Each question is worth (1) point total. It will be scored ½ point for your definition and ½ point for your example. BSHS Week 4 Individual Assignment Concepts And Terms Quiz Click Below URL to Purchase Homework. BSHS Week 3 Team Assignment Interview of a Social Service Agency on Their Use of Mediation 3 University of Phoenix BSHS - Summer BSHS Week 3 Team Assignment Interview of a Social Service Agency on Their Use of Mediation 3 BSHS week 4 .
BSHS Week 3 Team Assignment Interview of a Social Service Agency on Their Use of Mediation 3 University of Phoenix BSHS - Summer BSHS Week 3 Team Assignment Interview of a Social Service Agency on Their Use of Mediation 3 BSHS week 4 .