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
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
Describe a situation where it would be useful to use data validation in a table.
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
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
Note:-
Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
Answer completely.
You will get up vote for sure.
arrow_forward
Which algorithm uses parametric line equations for clipping?
- A) Cohen-Sutherland
- B) Liang-Barsky
- C) Sutherland-Hodgman
- D) Midpoint subdivision.
arrow_forward
Volumetric Glassware: Utility and Calibration (Dry Lab)
Table B1: Calculation of a 100-mL Volumetric Flask.
temperature of the Distilled H2O (°C)
27
density of distilled H2O at calibration temperature
mass (g) of volumetric flask + distilled H₂O
Trial 1
198.5893
Trial 2
198.6114
Trial 3
mass (g) of dry volumetric flask
98.6563
98.7503
198.6001
98.7145
mass (g) of distilled H₂O
m true g
calculated volume of water dispensed, cm³
corrected volume, V20 °c, cm³
average corrected volume, V20 °C, cm³
standard deviation (4 sig figs)
%RSD (2 sig figs)
arrow_forward
Please no written by hand solutions
In a recent commercial, a weight-loss company featured testimonials touting their “miracle shake” nutritional supplement.
Satisfied Customer
Time (days)
Weight loss (kg)
Sarah, from Toronto
30
11
Zack, from New York
45
16
Eli, from Detroit
90
36
Yvette, from Montreal
10
4.5
Lynn, from San Diego
30
8.5
Kulwinder, from Vancouver
60
20
The commercial claims that the miracle shake will provide guaranteed weight loss.
a) Use this data to determine the correlation between time on the diet and weight loss (either the Spearman's Rank Coefficient, or the PPMCC, but state which you are calculating. You are welcome to use a spreadsheet).
b) Does the correlation imply that the miracle shakes cause weight loss? Identify any possible outliers.
arrow_forward
Resistors for electronic circuits 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 13.7.
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.
1
2
3
4
5
6
7
SAMPLE
NUMBER
1
2
8
9
10
11
3
4
5
12
13
6
7
14
15
8
9
10
11
12
13
14
a. Calculate the mean and range for the above samples. (Round "Mean" to 2 decimal places and "Range" to the nearest whole
number.)
15
READINGS (IN OHMS)
1094
983
1026
1013
988
1014
991
1030
995
991 1023 1014
982
970
1016
986 1811 1030
1027
1826
983
1817
1004
1817 1018
995
982
994 1008
1897
978
976
1016
977
1010
987
994
981
1820 1001
1004
995 1015 1026
984
1030
978 1017
974
995 1007 988
995
970 1004 1028
1012 1019 983 990
Sample Number
Mean
Range
arrow_forward
Discuss the purpose of employing business process modeling and notation in organizations, why it is essential, and when should you implement BPMN.
Note: please make it a unique answer.
arrow_forward
Please do not give solution in image format thanku
what is the upper and lower limit answer asap
arrow_forward
I need help with part c of the question.
arrow_forward
Operaion management
No excel screen shot please
arrow_forward
When would you use/not use this formatting on a chart. Explain why by providing specific examples.
arrow_forward
The three key philosophies of TQM are
O a. Reducing cost, continuous improvement and involvement of all employees in the
organization
O b. Customer satisfaction, continuous improvement and involvement of all employees in the
organization
Oc. Reducing cost, customer satisfaction and involvement of all employees in the organization.
O d. Customer satisfaction, supplier and quality improvement
O e. None of these
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- 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_forwardExperiment1: 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 labarrow_forwardUse 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 okarrow_forwardNote:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.arrow_forwardWhich algorithm uses parametric line equations for clipping? - A) Cohen-Sutherland - B) Liang-Barsky - C) Sutherland-Hodgman - D) Midpoint subdivision.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you