DBS211-LAB02-Questions
.docx
keyboard_arrow_up
School
Seneca College *
*We aren’t endorsed by this school
Course
501
Subject
Business
Date
Jun 19, 2024
Type
docx
Pages
3
Uploaded by SargentCaribouMaster1033
DBS211 -LAB02
Lab 02
Objectives:
The purpose of this lab is to familiarize you with tables, columns, relationships, and constraints as provided to you within
the sample database. By the end of this lab you should be able to:
Produce a relationship diagram of an existing database
Visualize the sample database provided to you and display the relationships between the tables
Be familiar with the sample database that we will be using for the remainder of the term
Preface:
During this lab, you will need to create a relationship diagram. There are many free tools available to you for this task. One example would be http://draw.io
. Explore the Database
By navigating through SQL Developer and looking at the Columns, Data and Constraints tabs for each table, you will create a relationship diagram for all the tables in the database.
Your diagram must include:
ZERO MARKS WILL BE GIVEN IF USING SOME OTHER SCRIPT DIAGRAMS. Answers cannot be combined for all the questions together as one diagram.
ZERO MARKS WILL BE GIVEN if using direct model diagrams.
The names of the entities (tables)
The attributes (columns) for each table
Lines representing the relationships between tables, try to get the lines to as closely point to the correct fields as
possible (not always possible to be exact, but do your best here). Do not overlap or cross the lines.
Crows Foot Symbols on the lines representing the type of relationship (1-1, 1-many)
Required fields should be bolded
Primary Key fields should be underlined or
indicated with a PK beside it.
Child fields in the relationships should be indicated with an FK beside it.
Example
:
DBS211 -LAB02
LAB 02 – SUBMISSION
You will be submitting a Word document with the screenshots of a completed database relationship diagram of the following 5 questions.
In the ERD picture have your Name, Student ID number, section. This can be achieved by creating a simple box in the diagram before saving it.
QUESTION 1
Draw the Entity Relationship diagram of the following tables PRODUCTLINES and RETAILPRODUCTS
QUESTION 2
Draw the Entity Relationship diagram of the following table RETAILEMPLOYEES. QUESTION 3
Draw an Entity Relationship diagram for the following.
The online movie rental service offers a catalog of movies available for rental.
Each movie has a unique Movie_ID. Movies have attributes such as Title, Genre, Director, Release Year, and Rating. A movie catalog requires at least the title and Genre as required fields.
Customers can register for an account to rent movies. Each customer has a unique Customer_ID. Customer information includes attributes such as Name, Email, Address, and Payment Information. A customer catalog requires at least the name and email address of the customer.
Each rental transaction is recorded. A rental has a unique Rental_ID. Rental information includes attributes such as Customer_ID, Movie_ID, Rental Date, Due Date. Each customer can rent more than 1 movie and each movie can be rented by many or zero customers.
QUESTION 4
Find the primary keys and foreign keys for all the tables created in LAB 01. See an example below and follow the same way to find these keys from constraints tab in the tables. Mention “n/a” if there is no primary key or foreign key.
Table Name
Primary Key fieldname
Foreign key fieldname(Reference Parent table name)
RETAILEMPLOYEES
EMPLOYEENUMBER
OFFICECODE(RETAILOFFICES), REPORTSTO(RETAILEMPLOYEES)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Background: Data about the frequency of adverse events related to inappropriate care in hospitals come from studies of medical records as if they represented a true record of adverse events. In a prospective, observational design we analyzed discussion of adverse events during the care of all patients admitted to three units of a large, urban teaching hospital affiliated to a university medical school. Discussion took place during routine clinical meetings. We undertook the study to enhance understanding of the incidence and scope of adverse events as a basis for preventing them
Methods: Ethnographers trained in qualitative observational research attended dayshift, weekday, regularly scheduled attending rounds, residents' work rounds, nursing shift changes, case conferences, and other scheduled meetings in three study units as well as various departmental and section meetings. They recorded all adverse events during patient care discussed at these meetings and developed a…
arrow_forward
Background: Data about the frequency of adverse events related to inappropriate care in hospitals come from studies of medical records as if they represented a true record of adverse events. In a prospective, observational design we analyzed discussion of adverse events during the care of all patients admitted to three units of a large, urban teaching hospital affiliated to a university medical school. Discussion took place during routine clinical meetings. We undertook the study to enhance understanding of the incidence and scope of adverse events as a basis for preventing themMethods: Ethnographers trained in qualitative observational research attended dayshift, weekday, regularly scheduled attending rounds, residents' work rounds, nursing shift changes, case conferences, and other scheduled meetings in three study units as well as various departmental and section meetings. They recorded all adverse events during patient care discussed at these meetings and developed a classification…
arrow_forward
Yayy Online Revenue Process
Computer
Customers
Bank
Releases
product page at
midnight
Buy this
product?
Register & login
Saves customer
details
Enters product
and payment
option
Calculates and
displays order
totals
Inputs payment
data
Processing a sales order
Process
payment data
Receives
payment data
for verification
arrow_forward
subpart #2 Brenda appears to have an advantage with her products and services. Develop a plan for Brenda to overcome the sales resistance she is receiving.
arrow_forward
28
PDCA, developed by Shewhart, stands for which of the following?
Select one:
a. Plan-Develop-Check-Accept
b. Problem-Do-Continue-Act
c. Prepare-Develop-Create-Assess
d. Plan-Do-Check-Act
e. Problem-Develop Solution-Check-Act
arrow_forward
How can I match the term with its defin
arrow_forward
Don't use chatgpt..
arrow_forward
III. What is the expected value of sample information
IV. What is the efficiency of the survey information
arrow_forward
Solve full correct complete solutions with final answers
arrow_forward
Cross-functional teams (those that work in brief production cycles to produce product increments over time) perform work in parallel. Is it necessary to construct numerous models to convey the process model of COVID-19?
arrow_forward
week 7With regard to “Consumer Perceptions of Price, Quality, and Value: A Means-End Model of Synthesis of Evidence,” comment on the problem of perceived versus objective quality. Provide examples. How does this affect the marketing of services?2Think of two creative ideas for services to be provided by the grocery business industry. Be very specific in terms of the rationale behind your approach, and the systematic procedures (e.g., questionnaire) you would use to introduce your services to the market.In the health care industry, what other ideas do you have for providing better services to customers? Analyze and discuss your judgment about whether marketing in this industry is different because human life is involved.week 8″National Cultures in Four Dimensions: A Research-Based Theory of Cultural Differences Among Nations,” is considered seminal in several fields, including marketing, international business, and organizational development. Based on your…
arrow_forward
Can you assist me with Question 4.48 I've made attempts to solve but still don't understand. Can you please write the process out step by step? It's easier to follow along. Thank you kindly.
arrow_forward
The manager of a local restaurant “RRR” asks you to improve the existing “online food ordering system” with an additional function. It is desired that the new function informs the customer about the approximate time needed to deliver the foods after customer submits the order via the website of “RRR”.
If you plan to prepare an online questionnaire for the customers that they may fill on theweb site of “RRR”
Write 2 questions that you may use nominal scale and 2 questions that you may useinterval scale.
arrow_forward
A
enables you to view
data from a table based on a specific
criterion
O Query
O Report
O Form
O All of the above
arrow_forward
Experiment1: application of excel 2010 (if you have EXCEL installed on your computer)
Requirement: create a pivot table and chart in excel
1. pivot table
(1) basic data
Please paste the table header and 1-2 rows of the data, and explain the meaning of the data.
(2) pivot table
Please paste the pivot table here.
(3) function of this pivot table
Please explain the pivot table that you have created, what is the function of the result.
2. chart
(1) basic data
As above
(2) chart
Please paste the chart here, and tell me which type of chart you have used.
(3) function of this chart
Please explain the chart that you have created, what is the function of the result.
its management information system lab
arrow_forward
Use a flowchart to illustrate the activities and parties that Walter would have involved during the
purchasing process of the folding machine.
arrow_forward
Solve it accurate no need guidelines answers ok
arrow_forward
15. A researcher wishes to study developmental changes in the
music people prefer to listen to. The researcher locates 50
people who are about 20 years old. She sends these people
a questionnaire every year for the next 10 years asking
about the types of music they prefer to listen to. This is an
example of which type of design?
a. cross-sectional
b. panel
c. longitudinal
d. nested
arrow_forward
Resistors for electronic circults are manufactured on a high-speed automated machine. The machine is set up to produce a large run of
resistors of 1,000 ohms each. Use Exhibit 10.13.
To set up the machine and to create a control chart to be used throughout the run, 15 samples were taken with four resistors in each
sample. The complete list of samples and their measured values are as follows: Use three-sigma control limits.
SAMPLE
NUMBER
LA3A669 ELE
1
2
4
5
7
8
10
11
12
13
14
15
1
2
3
4
5
6
7
8
9
10
11
READINGS (IN OHMS)
985
1,009
1,003 1,015
1,009
1,019 1,005
1,010
995
990
1,015 1,020
1,013
Sample Number
12
13
14
15
991
996
994 1,001
989
992
986
989
1,001
1,006
1,005
992
1,006
996
997
1,019
991
981
989
999
993
988
1,013 1,002 1,005
1,007
1,006
996
991
994
982
996
a. Calculate the mean and range for the above samples. (Round "Mean" to 2 decimal places and "Range" to the nearest whole
number.)
Mean
986
994
1,008
998
993
1,005
1,020
996
1,007
979
989
1,011
1,003
984
992
Range
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- Background: Data about the frequency of adverse events related to inappropriate care in hospitals come from studies of medical records as if they represented a true record of adverse events. In a prospective, observational design we analyzed discussion of adverse events during the care of all patients admitted to three units of a large, urban teaching hospital affiliated to a university medical school. Discussion took place during routine clinical meetings. We undertook the study to enhance understanding of the incidence and scope of adverse events as a basis for preventing them Methods: Ethnographers trained in qualitative observational research attended dayshift, weekday, regularly scheduled attending rounds, residents' work rounds, nursing shift changes, case conferences, and other scheduled meetings in three study units as well as various departmental and section meetings. They recorded all adverse events during patient care discussed at these meetings and developed a…arrow_forwardBackground: Data about the frequency of adverse events related to inappropriate care in hospitals come from studies of medical records as if they represented a true record of adverse events. In a prospective, observational design we analyzed discussion of adverse events during the care of all patients admitted to three units of a large, urban teaching hospital affiliated to a university medical school. Discussion took place during routine clinical meetings. We undertook the study to enhance understanding of the incidence and scope of adverse events as a basis for preventing themMethods: Ethnographers trained in qualitative observational research attended dayshift, weekday, regularly scheduled attending rounds, residents' work rounds, nursing shift changes, case conferences, and other scheduled meetings in three study units as well as various departmental and section meetings. They recorded all adverse events during patient care discussed at these meetings and developed a classification…arrow_forwardYayy Online Revenue Process Computer Customers Bank Releases product page at midnight Buy this product? Register & login Saves customer details Enters product and payment option Calculates and displays order totals Inputs payment data Processing a sales order Process payment data Receives payment data for verificationarrow_forward
- subpart #2 Brenda appears to have an advantage with her products and services. Develop a plan for Brenda to overcome the sales resistance she is receiving.arrow_forward28 PDCA, developed by Shewhart, stands for which of the following? Select one: a. Plan-Develop-Check-Accept b. Problem-Do-Continue-Act c. Prepare-Develop-Create-Assess d. Plan-Do-Check-Act e. Problem-Develop Solution-Check-Actarrow_forwardHow can I match the term with its definarrow_forward
- Cross-functional teams (those that work in brief production cycles to produce product increments over time) perform work in parallel. Is it necessary to construct numerous models to convey the process model of COVID-19?arrow_forwardweek 7With regard to “Consumer Perceptions of Price, Quality, and Value: A Means-End Model of Synthesis of Evidence,” comment on the problem of perceived versus objective quality. Provide examples. How does this affect the marketing of services?2Think of two creative ideas for services to be provided by the grocery business industry. Be very specific in terms of the rationale behind your approach, and the systematic procedures (e.g., questionnaire) you would use to introduce your services to the market.In the health care industry, what other ideas do you have for providing better services to customers? Analyze and discuss your judgment about whether marketing in this industry is different because human life is involved.week 8″National Cultures in Four Dimensions: A Research-Based Theory of Cultural Differences Among Nations,” is considered seminal in several fields, including marketing, international business, and organizational development. Based on your…arrow_forwardCan you assist me with Question 4.48 I've made attempts to solve but still don't understand. Can you please write the process out step by step? It's easier to follow along. Thank you kindly.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you