Assignment 6 - INFO 623

Cumulative ACK. What is meant by a cumulative acknowledgment, ACK(n)?

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

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.

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

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”?

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?…

What is meant by linker.

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

An example of a hierarchical data structure is what?

Create an Access Matrix for the given domain structure: D1: D2: D3: D4:

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.

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

Why is it sometimes better for a data model to exclude a certain data item from its representation?

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…

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.

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?

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))

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…

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

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?

State six general guidelines for naming data objects in a data model.

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…

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

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

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?

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

What is the point of leaving a data object out of a data model?

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

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 ?

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…

An example of a hierarchical data structure is tree why?