Databases Questions and Answers August 16, 2021

Given the following database schema E Employee (Ename, SSN, Age, salary, Supervisor SSN, Dno) D Department (Dname, Dnumber, Dlocation, Manager_SSN, Mgr StartingDate) P- Project (Pname, Pnumber, Plocation) W- Works_On (ESSN, Pno, Hours) De - Dependent (ESSN D name, DoB, Relationship) and the following set of foreign keys: Employee-Supervisor-SSN

Can you do part a to d detailed, please , explain every step 6. [24 marks] For the following declarations, determine the hexadecimal value stored in memory and the on-screen decimal equivalent, i.e. the value displayed with printf ("8. ", varfable). Binary-hexadecimal-decimal conversions may be done by calculator, but other steps such as 2's

1. Create a star schema for this data based on your analysis of the requirements and understanding of the domain. They must be reasonable and justifiable. Clearly show major measures, dimensions and their attributes. Use any software program to do the modeling. 2. Create a data mart based on the star schema using SQL Server Database Engine.

Expand the key 1010 0001 1111 0101 using Simplified AES. As a check, the last four bits of key for round 2 should be 0011 (that is k28k29k30k31). In Simplified AES, for function MC we showed an easier approach by showing what each column is transformed to, using only XOR of bits (shown in page 21 of lecture notes). We know that MC-1 is multiplying

,,,

e Computer Science question D Group As gnment 1 Descriptor Assgnment 2 Description CSC1 + Part 2 (10 points): Create a Java program that allows two players to play Rock, Paper, Scissors. Player 1 will enter an integer to determine whether they use rock, paper or scissors. Player 2 will also enter an integer to determine whether they use rock,

Problem 1 : Draw a flowchart to show how the product of two matricescan be obtained.Example :Input: A [ 1 , 3 , 8 , 4 ] , B = [ 2 , 3 , 5 , 4 ] Output: Z = [ 2 , 9 , 4 0 , 1 6 ]

help me please Problem Description: As per Islamic rulings, zakat (a tax) is levied on the wealth, after a year have been passed on this wealth. There are different rates for different possessions, for capital amount, it is 2.5% of total cash. Calculate zakat on 1000 SAR. Write an algorithm and draw a flowchart diagram for this

c ) Supposed that a project was estimated to be 3 0 0 KLOC. Calculate the effort and development time for each of the three models, organic, semidetached and embedded

Laura sets up an extranet for her company in order to _ _ _ _ _ _ . a . manage inventory by syncing database content b . enable employees to access the entire network from outside the building c . allow customers or suppliers to access part of its intranet d . establish a wiki for employee information

Match the word to the correct definition. Prompts Protocols ( layers ) Networks Packets Routing World Wide Web Internet IP Address Netiquette Answers Select match Select match l . Select match Select match Last saved 7 : 5 9 : 1 5 PM

In a three-message authentication protocol, Alice initiates contact with Bob. Bob is a stateless server, and thus it is inconvenient for him to remember the challenges sent to Alice. Assume that Alice and Bob share a key K Alice Bob and Bob also has a key K Bob only known to himself. The protocol works as follows, where R1 and R2 are random

,,,,,

What is the meaning on Section number 1 , 2 , and 8 in man page? ( Tables 1 . 3 Sections of the man pages in page 1 5 )

Write it in "C" .. Advance practice problems 1. Write a program to find K'th smallest and K'th largest element in unsorted array. Sample Test casel: Input: A0-4, 5, 60, 70, 33, 44 K-2 Output: 2d smallest number is 5 and 2d largest number is 60 Sample Test case2: Input: All-2, 46, 56, 68, 3, 34, 489, 457, 4545, 100 Output: 5th smallest number is 56

Identify the missing values in the simulated waveform below. (Assume that the D flip-flop outputs change only when the enable is 1 (whatever is on the input sends the same value to the output) and the initial value of a_c is set to 1 and the initial value of b_c is set to 0.) Note: XNOR DURUM TABLOSU = XNOR Truth Table Giri 1 = Input 1 Giri 2 =

You work for an enterprise that provides various cybersecurity services. You are assigned to examine an enterprise's network and suggest security measures modifications, if necessary. On examining the network, you find that the enterprise hosts most of its computing resources on a cloud platform and few resources on - premises, and both seem to

I need help with these questions and also please provide the image or screenshot for every single answer, thank. Systems: Two systems, Kali & Metasploitable, are needed for this lab running in NAT Network" mode as Virtualbox VMs. You need to verify the ip address of both machines and test with ping. Wireshark: In this lab, you will use the tool

,,

The discrete time periodic signal x(n)={2,1,-4,2} has the Fourier coefficients given as Cx = {C-8,0-7,0-6,6 - 1,0-4,C-3,-5, C-1,60,61,-5, Find the missing coefficients and plot its magnitude spectrum for -8sks3

A logic gate is Select one: a . an electronic circuit b . a combination of digital systems c . a gate that accepts any data and give an output d . the basic element of a digital system

a ) Convert the following regular expression to NFA: ( a a b ) * * a ( b a ) * *

linux Why should you make a copy of /etc/rsyslog conf? Should a static or a dynamic IP address be used on the server? Why? 1 Explain the importance of reviewing logs

Design a reflex button system that finds out who presses first. The button press depends on a condition of Red and Green LED activation. These LEDs turn on for 1 second randomly. Contestant looses if he/she presses on wrong LED. This means each user has two buttons. One for Red the other for Green. The system should contain two buttons and

Question 4 [ 4 pts ] : Figure 4 shows a state graph where A denotes the node corresponding to the initial state, and E is the goal node. In the figure, h = x denotes the heuristic function value and c = x denotes the actual cost between nodes ( i . e . , arch cost ) . a . Please explain why ( or why not ) the heuristic function in Figure 4 is ( or

can someone help with this, I am getting stuck with it The goal of this exercise is to determine which variables make what kinds of difference while performing numerical computations: We will consider at least four variables: - number of iterations / size of subintervals (obviously, smaller ones improve the answer, but how many does it take?) -

,

int y = 10; int *x=&y; printf("%lu ", (unsigned long)x); printf("%d ", sizeof(int)); This program prints 9000 What are the values of the following expressions? [Choose] [Choose] *x + 1 [Choose] *(x + 1) [Choose ] [Choose] *((int*) 9000) [Choose]

The network diagram displays each task as a box, or q , link index node path

(d) we 0,13*w is any string except 11 and 111) (e) ((ab)"a"bk|n2 1, m 20, k s 13, i.e. the language that can be generated by the regular expression (ab) a*(bl)

Python Code: Homework 6 about Functions: Write a function that receives three parameters: name, weight, and height. The default value for name is James. The function calculates the BMI and returns it. BMI is: weight/(height 2 ). Weight should be in kg and height should be in meters. For instance, if the weight is 60kg and the height is 1.7m, then

Voice Over in iOS, how do you navigate to the next item? Swipe left to right Gurpe right to left Swpe down Gwipe un

Question 1 9 ( 2 points ) Viruses require an executable program in order to spread within the system True False

Vocabulary and Comprehension Without using a dictionary, define hermetic as it is used in paragraph 9 . Use clues in the text to help you. Points

Which of the following could be a reusable dataset? table of dates table of postal codes table of latitude and longitude all of these answers

7 8 . What is "heuristic search" used for? a ) Approximate solutions b ) Exact solutions c ) Linear programming d ) Network flow

Mano Computer of 8 bits Memory , : 1 6 x 8 bit AR , PC , DR , AC , INPR,OUTR : 4 Bit IR : 8 Bit Please Draw it on logisim And Control Subcirciut. Show all images Show all images Show all images done loading

Due: January 29 (11:59 PM) Instructions Come up with a minimum of 3 different data science project ideas that incorporate an analysis of the NOOA Storm Events Database Write a topic sentence for each idea (see Lecture 2 slides) Tips Use the mind-mapping technique Use Google to research Read the Final Project Specifications doc (BB) Resources:

The "computer as a symbol" involves using a computer to intercept data transmission True False

Convert the following textual description to an entity - relationship diagram in UML notation. Please spend time differentiating between entities, attributes, relationships and values of attributes. If you are identifying a strong entity - make sure you identify a primary key for it . You are not required to use superclass / subclass hierarchy for

There are 7 DMUs with a single input and single output case. Assume this is an output - oriented VRS problem. \ table [ [ DMU , A , B , C , D , E , F , G ] , [ Input , 1 , 3 , 4 , 6 , 8 , 9 , 1 0 ] , [ Output , 1 , 5 , 3 , 7 , 1 0 , 1 0 , 1 0 ] ] ( 1 ) Plot the VRS DEA frontier in the figure. narrus, ( 2 ) Point out the fully efficient DMUs. ( 3 )

But you discover that users can still access the public web server in the DMZ . What should you do ? 1 point Add a rule to the firewall: 7 0 1 9 2 . 1 6 8 . 1 . 0 / 2 4 > 1 9 2 . 1 6 . 2 . 4 0 ANY ANY Deny Move rule 5 0 above rule 3 0 . Add a rule to the firewall: 7 0 1 9 2 . 1 6 8 . 1 . 0 / 2 4 > 1 9 2 . 1 6 8 . 2 . 4 0 TCP 4 4 3 Deny Move rule 5

MATLAB problem game of Craps Setup: one set of size nrolls outcome: roll results, in rollSet (1 x nrolls) Characterize the results: -Mean of the rolls: setMean -Bin counts: bincount (1 x 6) - Bin %: binpct (1 x6) Code to call function: % ------------------------------------------------------------------------- % Case 1: One die. One set of rolls.

Make a project called an online hotel reservation system and include these prototyping ( interface design, user interface ) And testing

11) Suppose you distribute a file of a size of F = 9 gbits to each of 6 peers. The server has an upload rate of u = 91 mbps and the 6 peers have upload rates of u1 = 13 Mbps, u2 = 26 Mbps, u3 = 29 Mbps, u4 = 18 Mbps, u5 = 12 Mbps, and u6 = 18 Mbps and their download rates are d1 = 11 Mbps, d2 = 19 Mbps, d3 = 21 Mbps, d4 = 31 Mbps, d5 = 17 Mbps,

Conceming relational databases, assume that r i ( x ) denotes a read operation for transaction i and w i ( x ) denotes a write operation for transaction i . What is the name of the concurrency - anomaly r 1 ( x ) r 2 ( x ) w 1 ( x ) w 2 ( x ) between two transactions? Lost updare Lare update Lost Writ Fsultr updixe

7 A computer system used to acquire, store, manipulate, analyze, retrieve, and distribute information related to an organization's human resources. a . Human resource planning b . High performing work system c . Human resourece information system

1) Write a research question using some of the variables below and write your empirical model in equation form. Please check the data before you start to understand which variables are constant and which are changing over time. You can benefit from the panel structure of the data to deal with the potential endogenity problems by including country

Below are the C and Java codes for the same programme. Compare the results of both with the reasons. #include #include int x = 5 ; int test ( int y ) { x = y; return 6 ; } int main ( ) { x = x + test ( 3 ) ; printf ( " % d " , x ) ; return 0 ; } import java.util. * ; import java.lang. * ; import java.io . * ; class Ideone { public static int x = 5

Question Text Question 5 Create a PL / SQL record named delivery _ duration that receives order id 1 0 0 9 and retrieves the customer number, surname, name and the full address. The full address is made up of the address, city, state and the zip code. The duration is calculated from the order date to the shipment date. Your output should resemble

linear system Part 2: Solve the following problems in MATLAB c) to create an m by m Fill in the function E =myElimA, elimination matrix E. Remember that an elimination matrix looks like an identity matrix with one extra entry of - in row r_entry and column r_pivot. 1. rentry, r-pivot, Fill in the function M = myMult (A, Remember that a multiplier

A / an _ _ _ _ _ _ _ _ _ _ _ _ _ _ is a join where the tuples in a cartesian product of two relations satisfying some predicate which uses any of the following comparison signs ( = ! = < > < = > = ) .

Using R studio, how do I export the following: - csv file - R text file with appropriate commenting - imports the . csv dataset file using the function read.csv ( ) , to yields statistics reported in the paper as output to the console, and generates all of the figures contained in the paper as . pdf files using the function pdf - Metadata as a .

must be done in c language and using linux mint A lot happened on this date. In 1949, the North Atlantic Treaty Organization (NATO) was formed. In 1968, Martin Luther King Jr. was assassinated in Memphis, Tennessee. In 1973, the world Trade Center, then the world's tallest building (110 floors), opened in New York. And most importantly, in 1975,

PuTTY in Windows is similar to which Linux tool? 1 point Virtualization RDP SSH CLI

How many wires are used in a 1 0 0 BaseTX UTP transmission? A Eight B Six C Four D Two

Exercise1:(34 points) 1. Generate 30 random numbers from the following range: (10 points ) 10, 12, 14, 16, 18, 20, 22, 24, 26, 28, 30, 32, 34, 36, 38, 40 For each of the numbers do the following: 2. Print the "displayvalue" For most numbers the "display value" is the number itself. However, all multiples of 10 should be represented as roman

How can i write this code in C++ in an easy way ??? the formate is like the dark picture #include #include using namespace std; string function (string str); int main() { return 0; string function(string str) { Problem 8: (5 pts): write a function that takes as an input parameter an integer (a large one!) The function should add the digits in the

,

Which of the following is the correct syntax to declare an ArrayList in Java? Pick ONE option ArrayList al = new ArrayList ( ) ; ArrayList al = new ArrayList [ ] ; ArrayList al ( ) = new ArrayList ( ) ; 2 2 ArrayList al [ ] = new ArrayList [ ] ; 2 3 Clear Selection Saved!

For Java Write a Program that Meets the Following Requirements Calls a method that creates an Array with 100 Random Generated Integers Calls a method that writes the elements of the array to a text file inside the Project Folder of the assignment. Relative File Addressing must be used. not absolute file addressing. This method should have

Q5.4 please provide answers regarding this question involving logistics and supply chain management Weighted-Criteria evaluation systems: A computer processor manufacturing company is using a weighted criteria evaluation system to certify suppliers. 5.4 The computer processor manufacturing company has developed a new component that it plans to

,

Download and extract the contents of this zip file of Python code into the assignment directory on your computer. Download and save this eclipse project archive file but do not extract it . Copy or move the file into the assignment directory on your computer. In eclipse, import the project archive using the following steps: Under the File menu

Which of the following is true about Website Reputation? Select all that apply. True False Two negative reviews and no positive reviews is enough to consider the website to have a negative reputation. True False True False True False Not all customer reviews are reliable or believable. Some reviews are fake.

1. F1 (X,Y,Z) = XY + X'Z F2(X,Y,Z) = (X+Y)*(X'+Z) What's the relation between F1 and F2 ? Group of answer choices Complement Dual Equivalent Not related 2. F1 (X,Y,Z) = XY + X'Z F2(X,Y,Z) = (X'+Y')(X+Z') What's the relation between F1 and F2 ? Hints: * De Morgan's Rule, or * Truth Table Group of answer choices Not related Complement Equivalent

Do this in python using While - loop 1) We are making a Secret numer game. The challange in this task is to ask a user to guess a number between 1 and 100. The code must repeat the input until you guess correctlt. The program must also give track of how many times the code has been repeated (how many guesses it took you until you guessed right)

Given the layout of the main memory as the following table and processes A(6M), B(11M), C(9M), D(2M) loaded one by another. partition no. available size starting physical address status 1 15 10 0 2 10 25 0 3 5 35 0 Which process cannot be loaded applying the next-fit? (10pts) What's the status of the partition table after loading ABCD applying the

Find the value of register R 1 " XX " in the given 8 0 5 1 assembly language program such that it creates a delay of 5 seconds. Assume that the crystal frequency is 3 3 M H z . Answer: 1 0 5

Question 1 Please Python language for solution You are to write a program that asks where a line crosses the X-axis and the Y-axis. You may assume that when the user correctly types in a number it is an integer but you should check that it is a valid input. The equation of the line is: a Bx + Ay = C. Note . A = where the line crosses the X-axis B

,

listenin elemanlar n kullan c dan alabiliriz. s ral do rusal ba l liste yap s kullanarak kodu yazabilir misiniz ve yazd n z kodlar detayl anlatabilir misiniz. L 1 ve L 2 eklinde iki s ral liste verildi inde , L 1 ve L 2 'nin t m d mlerini s ral d zende i eren nc bir liste reten bir Java program yaz n z . ( yani nc liste de s ralan r ) .

(a) Determine a minimum-cost staffing plan for PharmaPlus. (Let P be the number of full-time equivalent pharmacists. Let T be the number of full-time equivalent technicians.) Employees (pharmacists and technicians) required Enter inequalities using less than (), less than or equal (), or greater than or equal (). Service quality guideline Enter

Draw the gate-level logic diagram for a 4-10-1 MUX, a circuit in which one of four data input lines are connected to its single output, depending on the state of its 8. two control lines. You have been constructing a circuit and discover that you need one additional AND gate, but all you have is a chip with 2-to-1 MUXs. Show how to connect a

How does specifying a specific art style, like " 1 9 5 0 s pop art," influence the outcome of image generation in Midjourney? It guides the model to generate images that align with the characteristics of that art style. It restricts the model's ability to interpret the prompt. It increases the likelihood of generating abstract images unrelated to

A distributed denial of service ( DDoS ) attack can be performed using only a software component; no hardware component is necessary. Group of answer choices True False

Which of the following are "best practices" that should be followed every time you begin a new R notebook? Select all that apply. Question 1 9 options: Clearing the environment pane Clearing the console on the bottom Installing the libraries to be used Loading the libraries to be used

Write a C + + program that prompts the user to give an integer number and raise it in power of 2 . Here is a sample run, in bold and italic is the input from the user ( Hint: You can use pow ( ) from cmath library ) :Enter a number: 3 3 in power of 2 is 9

pls i want insert this qustion data structure pls i will thumb u good Which relational constraints would be violated if the following operation were applied to the COMPANY database snapshot illustrated bellow? Smith Susan James Sali Jone Adams Ford Miller 123 432 587 983 1/2/1979 3/6/1982 20/9/1980 1/12/1970 2100JD 1547JD 3650JD 890JD NULL 123 983

,

P lease solve the assignment using the written steps. I sent this assignment several times, but the ER schedule was not created Chapter 7: Data Modeling Using the Entity-Relationship (ER) Model CHAPTER 7: DATA MODELING USING THE ENTITY-RELATIONSHIP (ER) MODEL Answer the following questions. 1 - Consider the following set of requirements for a

your root user who want to do SYN scan by nmap in Linux environment and the IP Address is 1 9 2 . 1 6 8 . 1 . 1 what command you will use? sudo nmap - sS 1 9 2 . 1 6 8 . 1 . 1 nmap - sS 1 9 2 . 1 6 8 . 1 . 1 sudo nmap - sT 1 9 2 . 1 6 8 . 1 . 1 nmap - sT 1 9 2 . 1 6 8 . 1 . 1

I just need to create the main method but im not good at calling the methods to do this :generate a random list of 20 cubes (in an array), printing out the list before you sort it, and then printing out the list again after it is sorted using BubbleSort. For an identical list of 20 cubes (copied right after the generation of the array that was

A . List and discuss three ( 3 ) different applications for computers which can be used to aid in the design process. B . Outline how these are changing as computer related technologies are developing. C . Discuss the role of the human designer as computer technologies develop.

Question 1 5 ( 1 . 5 points ) When should writers use semicolons? to lead into bulleted and numbered lists to join snort phrases to separate primary items in a series that already contains commas to punctuate salutations in business letters

You are want to logically view data in rather than physically in a database. Which one of the following models will make you accomplish this? A . Non - relational model B . Relational model C . Logical model D . Physical model

QUESTION 1 Which of the following properties are inherited by the child process from the parent process? (Please read man fork before answering.; select one answer.) Process ID. Open file descriptors. Software timers. QUESTION 2 Which event can NOT initiate the transition of a process from the Running state to the Ready state? (Check one answer.)

Killing Lambda - moves In the construction of Section 1 4 . 7 , we change the start state to a final state if \ lambda is in L ( M ) , but do not change the final state set in any other way. Suppose that instead we changed the final state set to include all states with \ lambda - paths to an existing final state. Then the resulting ordinary NFA

From zyBooks CS 3 1 1 3 : Introduction to Operating Systems Chapter 2 . 2 , Which operating system service exchanges information between processes?

Create required classes, enums, etc. for the given requirements. Assume we need to represent employees, each employee has an id, name, phone number, designation, manager, department and team members working under him/her. The manager is also an employee and team members are also employee (definitely, multiple members in a team). There are only

Only question 1 (c) needed Question 1 a) Hannah is a junior web developer working at the TAR UC Communication and Information Centre (CITC). Hannah needs to work on a Lecture-Student Appointment Booking System using ASP.NET C# Language. (1) As a senior web developer, use any TWO (2) objects available in Visual Studio Integrated Development

What allows every department of a company to store and retrieve information in real time, allowing int Middleware Database Common data repository Application integration

If you delete a shortcut from your desktop, have you also deleted the original file? A . No , because a shortcut is a setting used to adjust the display, sounds, power battery, and storage. B . No , because a shortcut is just an organizing icon for apps and files. C . No , because a shortcut does not place the actual file, folder, or app on the

Business policies and rules govern all of the following EXCEPT: Group of answer choices A ) managing employees. B ) creating data. C ) updating data. D ) removing data.

F(A,B,C,D) =m(1,3,4,6,9,11,12,13,14) Using the Karnaugh map frame below for some function F F(A,B,C,D)=m(1,3,4,6,9,11,12,13,14) |Using the Karnaugh map frame below for some function F Implicant - this is a product term of the function. It is referred to as P. when P=1 the function F is 1 Prime Implicant - this is an implicant that is not enclosed

Please use Microsoft Visual Studio to write a code in C for the following problem: Write a scanf statement for each of the following: A. Read a hexadecimal value into variable hex_num. B. Read characters into array s until the letter p is encountered. C. Read a time of the form hh:mm:ss, storing the parts of the time in the integer variables hour,

Replace every instance of " - - Fill this in - - " with correct code that will enable the program to ask for a number of feet, calculate the meters equivalent, and then output a message: Sample Output: Enter number of miles: 1 5 0 . 0 Enter speed in MPH: 7 0 . 0 You should cover that distance in 2 . 1 4 hours. NOTE: Your program should display 2

Write a C program that can traverse a tree of subdirectories and search for a file with a given name. myfind accepts the following parameters: $ myfind filename startpath where filename is a substring that is matched against each filename in each directory that myfindinspects. If a file name matches filename or if the substring filename occurs

Why might a test framework that automatically detects and runs all test methods be advantageous over manually adding each test method to a ` runTests ` method? Group of answer choices It allows developers to write tests in multiple programming languages. It reduces the overall codebase size by eliminating unnecessary test methods. It ensures the

1. Suppose the program counter (PC) is set to 0x2000 0000. Is it possible to use the jump (j) MIPS assembly instruction to set the PC to the address as 0x40000000? Is it possible to use branch- on-equal (beq) MIPS assembly instruction to set PC to this same address

( d ) ( 1 0 Pts ) [ Task - 4 ] Write a function calledngramslistthat takes a string and a numbern and return the n - grams of the this string as a listSample input / Output: print ( ngramslist ( computer , 2 ) ) [ co , om , mp , pu , ut , te , er ]

The Learning Journal is a tool for self-reflection on the learning process. In addition to completing directed tasks, you should use the Learning Journal to document your activities, record problems you may have encountered and to draft answers for Discussion Forums and Assignments. The Learning Journal should be updated regularly (on a weekly

Lambda - NFA s from Regular Expressions Let N be the \ lambda - NFA made by our construction from the regular expression ( a + b * ) a * . Then N has exactly seven states and exactly eight \ lambda - moves. true or false

The first part of this assignment is to explore the use of threads in an application that computes PI. Create an appropriate Makefile to support the creation of the PI application (you can do this by modifying the Project1 Makefile). Compile and run this program a few times to understand the basic operation and to verify that it does approximate

matlab 1 (x + e ) sin y + 5 4. Use mesh and surf to draw function z = The value 1 + x + y 2 range of x and y is: x=(-23,21 ), y=[-2 1,21). (1) use the meshgrid function to generate sampling points. (2)In the mesh graphic: add graphic title 'mesh drawing'; control the scale range of the coordinate axis( x=(-7,7], y=[-7,7], z=(-450,400]). - (3)In

Hello, I have question from chapter 7 Case problem 2 in book "Microsoft Visual C# 2017: An Introduction to Object-Oriented Programming" by Joyce Farrell. Question goes like below; In previous chapters, you continued to modify the MarshallsRevenue program. Now, modify the program so that the major functions appear in the following individual

First: Choose one of the following systems to solve this assignment: System Restaurant Management System Main Functions For Restaurant Personnel Show restaurant tables Show table status (available, occupied, and dirty) Change table status Enter customer order Modify order details Cancel order Make payment Airline Reservation System For Customers

,

1 2 3 prints panale Mr Cooper states he want to try to quit smoking. He's tried before but hasn't been able to quit for very long. How would you provide education on smoking cessation for this patient?