DAD 220 Lab 4
.docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
220
Subject
Computer Science
Date
Apr 3, 2024
Type
docx
Pages
5
Uploaded by MajorNightingalePerson1051
Cardinality and Targeted Data
DAD-220-T3775
Professor Marcia Rogowsky
Shaun Saini
01/25/22
DAD 220 Cardinality and Targeted Data Template
Replace the bracketed text in this template with your screenshots and responses to the Module Four Lab for submission, grading, and feedback. Screenshots should be sized to approximately one quarter of a page. Written responses should be in complete sentences. Rename this document by adding your last name to the file name before you submit.
1.
Retrieve employee tuples and identify the number of employees
in San Francisco and New York.
2.
Retrieve order details for orderNumber
10330, 10338, and 10194 and identify what type of cardinality this represents in the entity relationship model.
The type of cardinality used in the ERD document would be multiple attributes. The reason for this is
because there is one order with multiple order details. The order details show products from that
specific order. 3.
Delete records from the payments table where the customer number equals 103.
Before Delete.
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
WORD 2016
when creating envelopes using mail merge each envelope in the final, merged document is separated by a:
1, page break
2, continuous section break
3, next page section break
arrow_forward
PHP
According to table the in the image
(Build a file to link to your database and give it the file name config.php)
(Build a file to display matrixnum, name from students table, subject_code and sub_name from subjects table and total_marks, grade from assessment table.)
Build code using javascript, to calculate total_marks and determine grade. Where total_marks are calculated by adding quiz, assignment and project and divided by 3. Where the value range of each quiz, assignment and project is 0 to 100. Next the grade will be determined based on the grading system (refer to the grading table)
arrow_forward
EXCEL - VBA - MACRO
Create a code in VBA EXCEL, where every time you change cell B1 on Sheet1, a new tab is created, renamed with what is written in that cell. Each new tab created must contain all the information that is on Sheet1, if they are updated.
arrow_forward
With the frmTutorSearch form still open in Design View, use the Title button to add a title to the form. Replace the default title text with Tutor Information Form. (Hint: Do not include the period.) Save and close the frmTutorSearch
arrow_forward
Move the appropriate file types from the list on the left to the correct descriptions on the right.
File Types (Icons)
XE
F
E
4
Answer Area
A file where you create the user interface
allowing you to display information and react to
user input.
A file that contains all the setup information for
your app.
A file that contains coded app logic.
A file that contains a list of available resources
to be used in the project.
arrow_forward
Written Use Case
Follow the sample format shown in the attached photo.Sample have its label, while the one you should make a written use case is the one who have blue ovalsNOTE: YOU SHOULD MAKE THE WRITTEN USE CASE AS YOU CAN SEE IN THE SAMPLE TABLE. SOMEONE IS ANSWERING MY QUESTION WRONG!
arrow_forward
5- The data editor has tabs for switching between (0.5 mark)
a- Data View and Variable View.
bvalues and cell contents.
c-Rows and called cases
d- the column and header,
e- each respondent in a study
arrow_forward
EXCEL VBA EXERCISE:
Create a VBA macro where for each change made in cell A1 on Sheet1, create a new tab, rename the tab with what was entered in cell A1 and copy the other information that is in the spreadsheet. As in the example made below, where in image 1 "aaa" was typed and a new tab was made with the same information present in the original spreadsheet and in image 2, the spreadsheet was changed and with a new value for A1, another tab was created.
arrow_forward
Document I
Review
View
Help
Telmewat you want to do
Relerences
Mailings
AA Aa-
E bceDd AaBbCcDd AaBbC AaBbCcC AaB AaBbCcD AaBbCcDd AaBbCcC
A-7-A
Normal
1 No Spac. Heading 1
Heading 2
Title
Subtitle
Subtle Em...
Emphas
Font
Paragraph
Styles
Write a program to insert an element in the given array (1D) at the beginning. After insertion,
identify the largest element from the array, and delete it. After deleting the largest element, display
the final array elements on the screen.
O (Ctrl)-
IF
arrow_forward
4_6008298641649830002.doc [Compatibility Mode] - Word
Table Tools
Sign in
File
Home
Insert
Design
Layout
References
Mailings
Review
View
Help
Design
Layout
O Tell me what you want to do
& Share
X Cut
P Find -
Times New Ro
12
- A A Aa -
AaBbCcl AABBC AaBbC AaBbCc AaBbCcI AaBbCc]
ab. Replace
A Select
B Copy
Paste
BIU - abe x, x A - aly , A -
Emphasis T Heading 1 T Heading 2 T Heading 3 1 Normal
Strong
Format Painter
Clipboard
Font
Paragraph
Styles
Editing
secona semester - 2020/ZI
Injormanon 1есппогogy
Department of IT
Field of Study: General
VERSITE
Tuesday 06/04/2021
اسم الطالبارة
Midterm Exam
رقم الطالبارة
Question Paper
FIRST QUESTION:
An embassy records details of interviews of visa applicants in the table below. Interviews are
conducted by members of staff in some of the embassy rooms. In any given day, a member of
staff tends to use the same room throughout that day. An applicant cannot have two interviews in
the same day:
+ R:
applicant No
interview Date
interview Time
staff No…
arrow_forward
CPE162_exer3_5 [Read-Only] [Compatibility Mode] - Word
Table Tools
Ace Jan C. Lape
File
Home
Insert
Design
Layout
References
Mailings
Review
View
Help
Design
Layout
O Tell me what you want to do
& Share
X Cut
P Find -
- 11
- A A Aa -
Arial
AABBCCL AABBC AaBbCc[ AaBbCcl AaBbCcD AaBbC
akc Replace
A Select -
EE Copy
Paste
U - aly , A-
- abe x, x A
Emphasis
Heading 1
I Normal
Strong
Subtitle
Title
Format Painter
Paragraph
CPE162
Clipboard
Font
Styles
Editing
Course Number
Course Title
Computer Programming 2
Topics Covered:
ARRAY
To know what arrays are
• Implement a program to apply array manipulation and apply how to
declare arrays
Declare, define, and initialize arrays
• Write programs that access data in the array list
Objectives:
Description
Create an array of 15 integers. Add all elements located at ODD index positions and sum also
all numbers located at EVEN (Assume zero index is even) index positions in the linear array.
The user will be the one to input each item in the array of 15…
arrow_forward
A (n) is a line style applied to individual cells, and entire tables , or individual areas within a table
a) border
b)outline
c) margin
d) frame
arrow_forward
MM Image Processing Project
Use your own images that are different than the images in the tutorial file.Include in your report the following only:
1) all the commands producing images,
2) the images produced, and
3) comment briefly on every image showing what was done and describe the result.
All commands and comments MUST BE IN TEXT (NOT IMAGES).You may modify the filters and show the result as well.Compile all commands text that you used in an appendix.Save your WORD file as PDF as well.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:9781305503922
Author:Patrick M. Carey
Publisher:Cengage Learning
Related Questions
- WORD 2016 when creating envelopes using mail merge each envelope in the final, merged document is separated by a: 1, page break 2, continuous section break 3, next page section breakarrow_forwardPHP According to table the in the image (Build a file to link to your database and give it the file name config.php) (Build a file to display matrixnum, name from students table, subject_code and sub_name from subjects table and total_marks, grade from assessment table.) Build code using javascript, to calculate total_marks and determine grade. Where total_marks are calculated by adding quiz, assignment and project and divided by 3. Where the value range of each quiz, assignment and project is 0 to 100. Next the grade will be determined based on the grading system (refer to the grading table)arrow_forwardEXCEL - VBA - MACRO Create a code in VBA EXCEL, where every time you change cell B1 on Sheet1, a new tab is created, renamed with what is written in that cell. Each new tab created must contain all the information that is on Sheet1, if they are updated.arrow_forward
- With the frmTutorSearch form still open in Design View, use the Title button to add a title to the form. Replace the default title text with Tutor Information Form. (Hint: Do not include the period.) Save and close the frmTutorSearcharrow_forwardMove the appropriate file types from the list on the left to the correct descriptions on the right. File Types (Icons) XE F E 4 Answer Area A file where you create the user interface allowing you to display information and react to user input. A file that contains all the setup information for your app. A file that contains coded app logic. A file that contains a list of available resources to be used in the project.arrow_forwardWritten Use Case Follow the sample format shown in the attached photo.Sample have its label, while the one you should make a written use case is the one who have blue ovalsNOTE: YOU SHOULD MAKE THE WRITTEN USE CASE AS YOU CAN SEE IN THE SAMPLE TABLE. SOMEONE IS ANSWERING MY QUESTION WRONG!arrow_forward
- 5- The data editor has tabs for switching between (0.5 mark) a- Data View and Variable View. bvalues and cell contents. c-Rows and called cases d- the column and header, e- each respondent in a studyarrow_forwardEXCEL VBA EXERCISE: Create a VBA macro where for each change made in cell A1 on Sheet1, create a new tab, rename the tab with what was entered in cell A1 and copy the other information that is in the spreadsheet. As in the example made below, where in image 1 "aaa" was typed and a new tab was made with the same information present in the original spreadsheet and in image 2, the spreadsheet was changed and with a new value for A1, another tab was created.arrow_forwardDocument I Review View Help Telmewat you want to do Relerences Mailings AA Aa- E bceDd AaBbCcDd AaBbC AaBbCcC AaB AaBbCcD AaBbCcDd AaBbCcC A-7-A Normal 1 No Spac. Heading 1 Heading 2 Title Subtitle Subtle Em... Emphas Font Paragraph Styles Write a program to insert an element in the given array (1D) at the beginning. After insertion, identify the largest element from the array, and delete it. After deleting the largest element, display the final array elements on the screen. O (Ctrl)- IFarrow_forward
- 4_6008298641649830002.doc [Compatibility Mode] - Word Table Tools Sign in File Home Insert Design Layout References Mailings Review View Help Design Layout O Tell me what you want to do & Share X Cut P Find - Times New Ro 12 - A A Aa - AaBbCcl AABBC AaBbC AaBbCc AaBbCcI AaBbCc] ab. Replace A Select B Copy Paste BIU - abe x, x A - aly , A - Emphasis T Heading 1 T Heading 2 T Heading 3 1 Normal Strong Format Painter Clipboard Font Paragraph Styles Editing secona semester - 2020/ZI Injormanon 1есппогogy Department of IT Field of Study: General VERSITE Tuesday 06/04/2021 اسم الطالبارة Midterm Exam رقم الطالبارة Question Paper FIRST QUESTION: An embassy records details of interviews of visa applicants in the table below. Interviews are conducted by members of staff in some of the embassy rooms. In any given day, a member of staff tends to use the same room throughout that day. An applicant cannot have two interviews in the same day: + R: applicant No interview Date interview Time staff No…arrow_forwardCPE162_exer3_5 [Read-Only] [Compatibility Mode] - Word Table Tools Ace Jan C. Lape File Home Insert Design Layout References Mailings Review View Help Design Layout O Tell me what you want to do & Share X Cut P Find - - 11 - A A Aa - Arial AABBCCL AABBC AaBbCc[ AaBbCcl AaBbCcD AaBbC akc Replace A Select - EE Copy Paste U - aly , A- - abe x, x A Emphasis Heading 1 I Normal Strong Subtitle Title Format Painter Paragraph CPE162 Clipboard Font Styles Editing Course Number Course Title Computer Programming 2 Topics Covered: ARRAY To know what arrays are • Implement a program to apply array manipulation and apply how to declare arrays Declare, define, and initialize arrays • Write programs that access data in the array list Objectives: Description Create an array of 15 integers. Add all elements located at ODD index positions and sum also all numbers located at EVEN (Assume zero index is even) index positions in the linear array. The user will be the one to input each item in the array of 15…arrow_forwardA (n) is a line style applied to individual cells, and entire tables , or individual areas within a table a) border b)outline c) margin d) framearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:CengageCOMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE LNew Perspectives on HTML5, CSS3, and JavaScriptComputer ScienceISBN:9781305503922Author:Patrick M. CareyPublisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:9781305503922
Author:Patrick M. Carey
Publisher:Cengage Learning