Assignment 6 - INFO 623
.docx
keyboard_arrow_up
School
Drexel University *
*We aren’t endorsed by this school
Course
710
Subject
Computer Science
Date
May 1, 2024
Type
docx
Pages
6
Uploaded by bbbtobi17 on coursehero.com
INFO 623 Social Network Analytics
Name : Oluwatobi (Tobi) Bakare
Class – Info 623 -001
Assignment 6 (extra credits)
Considering the social network in the following figure
a.
Construct the sociomatrix.
N1
N2
N3
N4
N5
N6
N7
N8
N1
-
1
1
1
0
0
0
0
N2
0
-
0
0
0
0
0
0
N3
0
0
-
0
0
0
0
0
N4
0
0
0
-
0
0
0
0
N5
0
1
1
1
-
0
0
0
N6
0
1
0
0
1
-
0
1
N7
0
0
0
0
1
0
-
1
N8
0
0
0
0
0
0
0
-
b.
You may not be able to identify perfectly structurally equivalent subsets. Compute the Euclidean distance of the actors in the social network. Use hierarchical clustering to
identify the subsets of actors (indicate your threshold).
c.
Partition the socio matrix by the identified subsets
N3
N4
N1
N5
N2
N6
N7
N8
N3
-
0
0
0
0
0
0
0
N4
0
-
0
0
0
0
0
0
N1
1
1
-
0
1
0
0
0
N5
1
1
0
-
1
0
0
0
N2
0
0
0
0
-
0
0
0
N6
0
0
0
0
1
-
0
1
N7
0
0
0
1
0
0
-
1
N8
0
0
0
0
0
0
0
-
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
Cumulative ACK. What is meant by a cumulative acknowledgment, ACK(n)?
arrow_forward
Consider a conceptual schema given below.
LONGER TSERVICE
SHORTER TSERVICE
total-days
total-hours
DRIVER
TSERVICE
dlnumber
enumber
first-name
last-name
phone[e..]
ID1
ID2
BUS
departure-city
destination-city
departure-time
arrival time
ID
ID
ID
Assigned-to -
- Assigned-to
date-when-assigned
ID
rego
make
1..*
snumber
Passes-through
0..1
date-when-discharged
STOP
stop-City
edap
larrival-time
Your task is to perform a step of logical database design, i.e. to transform a conceptual
schema given above into a collection of relational schemas.
For each relational schema clearly list the names of attributes, primary key, candidate keys
(if any), and foreign keys (if any). Assume, that a superset method must be used to
implement a generalization.
T0
arrow_forward
6
Data Mining
Language R
A database has four transactions, given below,
TID
Date
items_bought
T10
1/10/2021
{K, A, D, B}
T20
1/11/2021
{D, A, C, E, B}
T30
2/1/2021
{C, A, B, E}
T40
2/3/2021
{B, A, D}
Assuming a minimum level of support min_sup = 60% and a minimum level of confidence min_conf = 80%.
(a) Find all frequent itemsets (not just the ones with the maximum width/length) using the Apriori algorithm. Show your work—just showing the final answer is not acceptable. For each iteration show the candidate (Ci) and acceptable frequent itemsets (Li).
(b) List all of the strong association rules, along with their support and confidence values.
arrow_forward
Q2 Classification
A logistic classifier was fitted to data, and six fresh observations were used to assess the performance of this
classifier. Here are the fitted logistic probabilities and the observations (Y values).
##
Logistic predictions Fresh data values
## [1,]
0.90
0
## [2,]
0.27
0
## [3,]
0.37
0
## [4,]
0.57
1
## [5,]
0.93
1
## [6,]
0.20
0
arrow_forward
Question # 1. Classification (ID3 Algorithm)
CLO-3,4, PLO-2,3, C-1,3
10
A dataset showing the decisions made by an individual about whether to wait for a table at a restaurant is listed in Table 1.
Table1
Bar
Patron
Rain
Type
Will Wait
F
Some
F
French
T
F
Full
F
Thai
F
T
Some
F
Burger
T
F
Full
F
Thai
T
F
Full
F
French
F
T
Some
T
Italian
T
T
None
T
Burger
F
F
Some
T
Thai
T
T
Full
T
Burger
F
T
Full
F
Italian
F
F
None
F
Thai
F
T
Full
F
Burger
T
Give the answers of following questions:
Identify the target variable from the table and, compute the entropy for this data set.
Let’s suppose “Type” feature is a root node, define the number of branches relates to it as well as calculate the information gain of “Type”?
arrow_forward
Predictive modeling:
Task: Ambulance Demand
Data Generating Process: Using the service data: The data is collected by the " NYC Traffic data” to answer the questions:
Frequency of data collection {how often is the data collected? After every incident? Daily? Yearly?}
Agency / Organization collecting the data {who specifically is collecting the data? Please avoid using general references like “government” or “police}
Original Unit of Analysis {What is the original unit of analysis for the data as provided? Calls for service? Census tracts? Cities?}
Transformed Unit of Analysis{i.e. are you modifying the call data to support your model? Hint: if you are doing “demand” model you will be aggregating the data.}
Data Generation Description{here, I want you in your own words to describe how you think the data was generated. Think 2-3 sentences.}
Data Collector{Who collects the data? A dispatcher? A Census taker?}
Triggering Process{What triggers the data to be collected?…
arrow_forward
What is meant by linker.
arrow_forward
s/4491/lessons/4180/slides/31019
合
3.1.2: Entity Relationship Modelling
Prev
Next
Question
SAVED
Question
Training
P. Name
Visual Basic
Visual Basic
SOL
SOL
P Code
Instructor
Dennis
Dennis
Term
15-1
15-2
15-1
15-2
15-1
Duration (Hrs)
Hourly Rate
20
Room NO
P1
A1
P1
P2
P2
P3
30
A2
Jason
10
20
30
A4
Jason
Joneph
Joseph
Rys
A5
P3
P4
C..
Java
15-2
15-2
20
10
A3
A7
A9
6
Identify the most suitable primary key for the table
above and explain how this key uniquely defines all
other attributes.
Baragraph BIU > 8 E E
Submit
arrow_forward
An example of a hierarchical data structure is what?
arrow_forward
Create an Access Matrix for the given domain structure:
D1:
D2:
D3:
D4:
arrow_forward
Software Requirement Enginering
Use Case Modeling
QUESTION:
We will develop a browser-based training system to help people prepare for such a certification exam.
A user can request a quiz for the system. The system picks a set of questions from its
database, and compose them together to make a quiz. It rates the user’s answers, and gives hints if the user requests it. In addition to users, we also have tutors who provide questions and hints. And also exam-inators who must certify questions to make sure they are not too trivial and those they are
sensical.
Make a use case diagram to model this system. Work out some of your use cases. Since we
don’t have real stake holders here, you are free to fill in details you think is sensical for this example.
Write a brief use case of Make quiz?
Use case: Make quiz.
arrow_forward
10
The resulting list for each object consists of ordered pairs , which
define all domains with a nonempty set of access rights for that object. This statement is
TRUE with respect to which of the following methods of access matrix implementation.
Global Table
Access list for objects
Capability list for domains
lock-key scheme
arrow_forward
Why is it sometimes better for a data model to exclude a certain data item from its representation?
arrow_forward
Project Synopsis:
DATABASE MANAGEMENT:ABC Walk-in Clinic is located in a large metropolitan city in Canada. The clinic staff consists of ten doctors, six nurses, five office secretaries, two administrative assistants and one manager. First time Patients have to visit the clinic personally and fill a registration form that contains their personal and health related information. An office secretary would then enter that information in the computer based information system.
Patients may become a permanent patient (at any time) for one of the doctors at the clinic by filling up necessary forms (they are called enrolled patients) or they may choose to come walk-in for every visit. (They usually called walk-in patients) Enrolled Patients may book their appointments online or by calling, the office and one of the secretaries would then book their appointment with their doctor on a particular day/time. Any booked appointment may be cancelled up to 24 hours in advance after which the clinic…
arrow_forward
A library wants to build a simple online recommendation system for a summer reading programme. The system involves people reading and recommending books and authors. • Readers (people) have a screen name as well as a real name and contact information, including an unknown number of phone numbers they can be contacted at. • Books have a title, ISBN, genre and reading level. • An author has a name and nationality. They can write zero or more books. • Assume that Books are written by only one author. • The database records what books a reader has read. • Readers can “like” books. • Readers can “like” authors independent of the books the author has written. Create a hand-drawn, conceptual entity relationship diagram (like the last lab, except that you’re including attributes) describing this circumstance for a database designer.
arrow_forward
In Bangladesh Premier League (BPL) player selection system, each team ownerpossesses a numbered paddle that is used to indicate a base price for a player. The BPLmanaging committee then starts the proceeding by mentioning the base price, and checkswhen a paddle is raised to accept that price to buy that player. As a result, the acceptanceof the player’s base price changes which is broadcast to all the team owners in the formof a new bid.Which design pattern is applicable here and why? Which design pattern is applicablehere and why?
arrow_forward
Assume f(n) = 34/n) and g(n) = 45" and indicate the relationship between the two.
Compare. 1: Select the number corresponding to the relationship:
• f(n) E o(g(n))
• f(n) E O(g(n))
• f(n) E w(g(n))
arrow_forward
DTSC670: Foundations of Machine Learning Models
Assignment 2: COVID-19 Data Wrangling
Name:
CodeGrade
Please note that this assignment will be manually graded. You will have one attempt at submitting this assignment.
Since we are merely using CodeGrade for this assignment as a platform to manually grade assignments, CodeGrade will not execute your code for this assignment. Rather, it simply renders your Jupyter Notebook in the web browser. Therefore, any code blocks that generate output must be fully executed within the notebook prior to submission. Otherwise, we will not see the output of your code!
Details
The purpose of this assignment is to hone your data wrangling skills. Your task for this assignment is to perform the data preparation as instructed in the DTSC670_Assignment_2 pdf listed in Brightspace. After performing all the data preparation tasks outlined in the document, run the code in the "Prepare DataFrames for Grading" section.
You are supplied an Excel file called…
arrow_forward
A cormpany has a single table in a computer (e.g., a spreadsheet) in which is stored every information abow
each worker including the transactions he/she does in the company. This,table is
A A table database
B A spreadsheet
CA flat file database
•D
A joint database
arrow_forward
Internet keyword searches are different from database keyword searches. The two are quite different from one another. What are the primary similarities and differences between the two in terms of the way queries are phrased and the information that is returned, and what are the advantages of each?
arrow_forward
State six general guidelines for naming data objects in a data model.
arrow_forward
Predictive modeling:
Task: Ambulance Demand using data collected by the NYC Traffic Data
Data Generating Process: Using the service data: The data is collected by the "NYC FDNY Emergency Medical Services Ambulance calls data” to answer the questions:
Frequency of data collection {how often is the data collected? After every incident? Daily? Yearly?}
Agency / Organization collecting the data {who specifically is collecting the data? Please avoid using general references like “government” or “police}
Original Unit of Analysis {What is the original unit of analysis for the data as provided? Calls for service? Census tracts? Cities?}
Transformed Unit of Analysis{i.e. are you modifying the call data to support your model? Hint: if you are doing “demand” model you will be aggregating the data.}
Data Generation Description{here, I want you in your own words to describe how you think the data was generated. Think 2-3 sentences.}
Data Collector{Who collects the data? A…
arrow_forward
Put into second Normal form where A,B, and C are prime attributes
R (A, B, C, D, E, F, G, H, I, J)
FD1 B —> D, J
FD2 (A, B, C) —> E
FD3 F —> G, H
FD4 C—> I
FD5 A —> F
arrow_forward
Simple
Clinic-Information-System
The following incomplete diagram shows classes of a simple Clinic-Information-System (CIS)
managing patients and room-occupation in hospitals. It is recorded when a patient was
admitted to a clinic and in which room. Note that patients may be transferred to other rooms in
the clinic during their stay. The system shown here runs on a server that is available to several
different clinics. All clinic-specific data must therefore be inseparable assigned to the respective
clinic.
a) Drag and drop one of the following symbols to each end of all connectors:
◆ for composition
• ◊ for aggregation
●
if none of the above; don't forget!
b) Specify the multiplicity on both ends of each connector using the dragable items.
•
Simplified Clinic-Information-System
examination task for Algorithms and Data-Structures
enumerations
Gender
«enumeration
Allergen
arrow_forward
What is an Abstract Data Type (ADT) and what does it mean? What benefits do ADTs provide? What are some of the ways that the idea of heredity makes problem solving easier?
arrow_forward
Given the following EER model for an airline business:
Date of
Birth
(1.1)
(0.n)
Airport
Employee
Customer
Employs
ID
(1..1)
Number
(1.1)
3 Letter
Abbreviation
ID
Home
of
Name
Address
Name
AirMiles
Location
Pilot
Steward(ess)
Flight Planner
Belongs_to
(1.3)
(1.n)
Buys
Year of
prod-
uction
Number of
Is_assigned_to
Is_assigned_to
seats
(0.n)
ID
Departure
Type
ID
Departure
ko m
Destination
(0.n)
Destination
Price
is_valid_for
Is_served_by
(1..1)
(0. n)
(1.n)
(1..m)
Plane
Flight
Ticket
ID
arrow_forward
What is the point of leaving a data object out of a data model?
arrow_forward
13
Data Mining
Language: R
Given the two closed frequent itemsets and their support counts, C = {{a1,a2,...,a10}: 1; {a1,a2,...,a5}: 2}, what is the support count of {a2, a8}?
0
1
2
3
SELECT ONE
arrow_forward
1 من 1
LAuiiples on Normalization
FD1
FD2
S id s_name S_addres S_major C id C_title I_name I_location Grade
FD4
FD3
Put this relation into 3NF
The solution
?
arrow_forward
A company has various rules for how payments to suppliers are to be authorized.Some payments are in response to an approved purchase order. For approved purchase orders under $5,000, the accountingclerk can immediately issue a check againstthat purchase order and sign the check. Forapproved purchase orders between $5,000and $10,000, the accounting clerk can immediately issue a check but must additionallyobtain a second signature. Payments for approved purchase orders over $10,000 alwaysrequire the approval of the accounting manager to issue the check as well as the signature of two accounting clerks. Payments thatare not covered by a purchase order that areunder $5,000 must be approved by the accounting manager and a departmental manager who will absorb the cost of the paymentinto that department’s budget. Such checkscan be signed by a single accounting clerk.Payments that are not covered by a purchaseorder that are between $5,000 and $10,000must be approved by the accounting…
arrow_forward
An example of a hierarchical data structure is tree why?
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Systems Architecture
Computer Science
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Related Questions
- Cumulative ACK. What is meant by a cumulative acknowledgment, ACK(n)?arrow_forwardConsider a conceptual schema given below. LONGER TSERVICE SHORTER TSERVICE total-days total-hours DRIVER TSERVICE dlnumber enumber first-name last-name phone[e..] ID1 ID2 BUS departure-city destination-city departure-time arrival time ID ID ID Assigned-to - - Assigned-to date-when-assigned ID rego make 1..* snumber Passes-through 0..1 date-when-discharged STOP stop-City edap larrival-time Your task is to perform a step of logical database design, i.e. to transform a conceptual schema given above into a collection of relational schemas. For each relational schema clearly list the names of attributes, primary key, candidate keys (if any), and foreign keys (if any). Assume, that a superset method must be used to implement a generalization. T0arrow_forward6 Data Mining Language R A database has four transactions, given below, TID Date items_bought T10 1/10/2021 {K, A, D, B} T20 1/11/2021 {D, A, C, E, B} T30 2/1/2021 {C, A, B, E} T40 2/3/2021 {B, A, D} Assuming a minimum level of support min_sup = 60% and a minimum level of confidence min_conf = 80%. (a) Find all frequent itemsets (not just the ones with the maximum width/length) using the Apriori algorithm. Show your work—just showing the final answer is not acceptable. For each iteration show the candidate (Ci) and acceptable frequent itemsets (Li). (b) List all of the strong association rules, along with their support and confidence values.arrow_forward
- Q2 Classification A logistic classifier was fitted to data, and six fresh observations were used to assess the performance of this classifier. Here are the fitted logistic probabilities and the observations (Y values). ## Logistic predictions Fresh data values ## [1,] 0.90 0 ## [2,] 0.27 0 ## [3,] 0.37 0 ## [4,] 0.57 1 ## [5,] 0.93 1 ## [6,] 0.20 0arrow_forwardQuestion # 1. Classification (ID3 Algorithm) CLO-3,4, PLO-2,3, C-1,3 10 A dataset showing the decisions made by an individual about whether to wait for a table at a restaurant is listed in Table 1. Table1 Bar Patron Rain Type Will Wait F Some F French T F Full F Thai F T Some F Burger T F Full F Thai T F Full F French F T Some T Italian T T None T Burger F F Some T Thai T T Full T Burger F T Full F Italian F F None F Thai F T Full F Burger T Give the answers of following questions: Identify the target variable from the table and, compute the entropy for this data set. Let’s suppose “Type” feature is a root node, define the number of branches relates to it as well as calculate the information gain of “Type”?arrow_forwardPredictive modeling: Task: Ambulance Demand Data Generating Process: Using the service data: The data is collected by the " NYC Traffic data” to answer the questions: Frequency of data collection {how often is the data collected? After every incident? Daily? Yearly?} Agency / Organization collecting the data {who specifically is collecting the data? Please avoid using general references like “government” or “police} Original Unit of Analysis {What is the original unit of analysis for the data as provided? Calls for service? Census tracts? Cities?} Transformed Unit of Analysis{i.e. are you modifying the call data to support your model? Hint: if you are doing “demand” model you will be aggregating the data.} Data Generation Description{here, I want you in your own words to describe how you think the data was generated. Think 2-3 sentences.} Data Collector{Who collects the data? A dispatcher? A Census taker?} Triggering Process{What triggers the data to be collected?…arrow_forward
- What is meant by linker.arrow_forwards/4491/lessons/4180/slides/31019 合 3.1.2: Entity Relationship Modelling Prev Next Question SAVED Question Training P. Name Visual Basic Visual Basic SOL SOL P Code Instructor Dennis Dennis Term 15-1 15-2 15-1 15-2 15-1 Duration (Hrs) Hourly Rate 20 Room NO P1 A1 P1 P2 P2 P3 30 A2 Jason 10 20 30 A4 Jason Joneph Joseph Rys A5 P3 P4 C.. Java 15-2 15-2 20 10 A3 A7 A9 6 Identify the most suitable primary key for the table above and explain how this key uniquely defines all other attributes. Baragraph BIU > 8 E E Submitarrow_forwardAn example of a hierarchical data structure is what?arrow_forward
- Create an Access Matrix for the given domain structure: D1: D2: D3: D4:arrow_forwardSoftware Requirement Enginering Use Case Modeling QUESTION: We will develop a browser-based training system to help people prepare for such a certification exam. A user can request a quiz for the system. The system picks a set of questions from its database, and compose them together to make a quiz. It rates the user’s answers, and gives hints if the user requests it. In addition to users, we also have tutors who provide questions and hints. And also exam-inators who must certify questions to make sure they are not too trivial and those they are sensical. Make a use case diagram to model this system. Work out some of your use cases. Since we don’t have real stake holders here, you are free to fill in details you think is sensical for this example. Write a brief use case of Make quiz? Use case: Make quiz.arrow_forward10 The resulting list for each object consists of ordered pairs , which define all domains with a nonempty set of access rights for that object. This statement is TRUE with respect to which of the following methods of access matrix implementation. Global Table Access list for objects Capability list for domains lock-key schemearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Systems ArchitectureComputer ScienceISBN:9781305080195Author:Stephen D. BurdPublisher:Cengage LearningPrinciples of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Systems Architecture
Computer Science
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning