Consider the tables given below. Salesperson -Technology

Consider the tables given below. Salesperson -Technology
by

1 Answer

Answer :

(i) Primary, Foreign(ii) Salespersons cannot be set as the primary key in the table Orders because table Orders has already primary key and one table cannot have more than one primary key column.
by

Related questions

With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii) below: -Technology

Description : With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii) below: -Technology

Last Answer : (i) select TName, Passenger from Train T, Reservation R where T.TrainId=R.TrainId;(ii) select T.* from Train T, Reservation R where T.TrainId!=R.TrainId;(iii)TrainIdTNameSourceDestination3424Lucknow MailLucknowNew Delhi5400Century ExpressNew DelhiKanpur

Consider the following tables PATIENT and TEST and answer the questions that follow : -Technology

Description : Consider the following tables PATIENT and TEST and answer the questions that follow : -Technology

Last Answer : Primary key in PATIENT and TEST tables are PCODE and TESTID respectively. Because primary key of a relational table uniquely identifies each record.Foreign key in PATIENT table is TESTID whose value is derived from the primary key (TESTID) of another table (TEST).

In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. -Technology

Description : In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. -Technology

Last Answer : (i)Acc_No, Cust_Phone(ii)All the columns having capability to become Primary Key are known as Candidate Keys.(iii)Acc_No(iv)Trans_Id

In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. Write a query to display customer’s name who has -Technology

Description : In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. Write a query to display customer’s name who has -Technology

Last Answer : (i) Select cust_name from customer c,transaction t where c.Acc_No=t.Acc_No and Transaction_Type= 'Debit';(ii)Select cust_name, t.* from customer c, transaction t where c.Acc_No=t.Acc_No;(iii) ... total amount of all type of transactions, it will only display the total of credit transactions only.

Identify the columns out of the given three, which should not be present in each of the following tables: -Technology

Description : Identify the columns out of the given three, which should not be present in each of the following tables: -Technology

Last Answer : (i) DateofBirth(ii) Admno(iii) Phonenumber

How many rows and column will be there in the Cartesian product of the above given tables. Also mention the degree and cardinality -Technology

Description : How many rows and column will be there in the Cartesian product of the above given tables. Also mention the degree and cardinality -Technology

Last Answer : Cartesian Product:Number of Rows: 20Number of Columns: 9Degree: 9Cardinality: 20

Consider the following dataframe, and answer the questions given below: -Technology

Description : Consider the following dataframe, and answer the questions given below: -Technology

Last Answer : (i) print(df.mean(axis = 1, skipna = True)) print(df.mean(axis = 0, skipna = True))(ii) print(df.sum(axis = 1, skipna = True))(iii) print(df.median())

Consider the table ‘Teacher’ given below. -Technology

Description : Consider the table ‘Teacher’ given below. -Technology

Last Answer : (i) Select count(Department) from Teacher ;(ii) Select count (*) from Teacher ;

Consider the table STUDENT given below: RollNo Name Class DOB Gender City Marks 1 Anand XI 6/6/97 M Agra 430 -Technology

Description : Consider the table STUDENT given below: RollNo Name Class DOB Gender City Marks 1 Anand XI 6/6/97 M Agra 430 -Technology

Last Answer : (1)b. Both (iii) and (iv)(2) b.RollnoNameClassDOBGenderCityMarks6734MaakhiyNehaGeetPreetiXIXXIXII12/12/948/12/956/5/978/8/95FFFFDubaiMoscowAgraMumbai256324470492

Database is made up of all the following components except (a) tables (b) queries -Technology

Description : Database is made up of all the following components except (a) tables (b) queries -Technology

Last Answer : (d) A database is made up of tables, queries, and forms.

A database that contains tables linked by common fields is called a (a) Centralized database (b) Flat file database -Technology

Description : A database that contains tables linked by common fields is called a (a) Centralized database (b) Flat file database -Technology

Last Answer : (c) Relational database stores data in the form of tables which are linked by common fields.

A report allows you to represent data retrieved from one or more tables so that, it can be analysed and printed if required. -Technology

Description : A report allows you to represent data retrieved from one or more tables so that, it can be analysed and printed if required. -Technology

Last Answer : True When you want to print those records which are fetched from your database then, reports are more useful for this purpose.

In a MS_Access database, which component is not present? (a) Formula Bar (b) Tables -Technology

Description : In a MS_Access database, which component is not present? (a) Formula Bar (b) Tables -Technology

Last Answer : (a) MS-Access contains various components, i.e. Tables, Queries, Forms, Reports, Macros and Modules.

The different objects supported by MS_Access are tables, queries, ………… and reports. -Technology

Description : The different objects supported by MS_Access are tables, queries, ………… and reports. -Technology

Last Answer : The different objects supported by MS-Access are tables, queries, forms, and reports.

Which of the following is used to specify the beginning of a table’s row? (a) <table> -Technology

Description : Which of the following is used to specify the beginning of a table’s row? (a) -Technology

Last Answer : (b) tag indicates the beginning of a table’s row.

Which tag is used to add columns in the tables? (a) <colspan> (b) <td> -Technology

Description : Which tag is used to add columns in the tables? (a) (b) -Technology

Last Answer : (b) is used to add columns in the tables.

Which tags divide HTML tables in multiple section? -Technology

Description : Which tags divide HTML tables in multiple section? -Technology

Last Answer : , and

Define cell padding and cell spacing with respect to tables in HTML. -Technology

Description : Define cell padding and cell spacing with respect to tables in HTML. -Technology

Last Answer : CELLSPACING controls the space between table cells and CELLPADDING sets the amount of space between the contents of the cell and the cell wall.

Which of the following statements about the sales force in the 21st century is true? A. Sales managers will use a hands-off approach and let the professional salesperson be his or her own boss B. Transactional exchanges no longer occur C. Sales management must be smart and nimble and provide technology-centered solutions to support the sales effort D. Salespeople make little use of the Internet because they realize the importance of the personal touch E. All of the above statements about the sales force in the 21st century are true.

Description : Which of the following statements about the sales force in the 21st century is true? A. Sales managers will use a hands-off approach and let the professional salesperson be his or her own boss B ... touch E. All of the above statements about the sales force in the 21st century are true.

Last Answer : C. Sales management must be smart and nimble and provide technology-centered solutions to support the sales effort

Consider a given Series , M1: Write a program in Python Pandas to create the series. -Technology

Description : Consider a given Series , M1: Write a program in Python Pandas to create the series. -Technology

Last Answer : import pandas as pdm1=pd.Series([45,65,24,89],index=['term1','term2','t erm3','term4'])

Consider the following ER diagram: Image The minimum number of tables required to represent M, N, P, R1, R2 is (A) 2 (B) 3 (C) 4 (D) 5

Description : Consider the following ER diagram:  The minimum number of tables required to represent M, N, P, R1, R2 is (A) 2 (B) 3 (C) 4 (D) 5

Last Answer : (A) 2 

Identify input/output devices from the clues given below: (a) Transfers typed or handw -Technology

Description : Identify input/output devices from the clues given below: (a) Transfers typed or handw -Technology

Last Answer : (a) Scanner(b) Barcode reader(c) Optical Mark Recognition (OMR)(d) Magnetic Ink Character Recognition (MIGR)(e) Printer (f) Speaker

The director of a company uses a database to store data about job title. This is a part of the database given below: -Technology

Description : The director of a company uses a database to store data about job title. This is a part of the database given below: -Technology

Last Answer : 1. 62. 63. Secretary4. Finance department and their Payroll Numbers are A621 and M502.

Name the term defined by given below statement: “A group of computers connected to each other by a link.” -Technology

Description : Name the term defined by given below statement: “A group of computers connected to each other by a link.” -Technology

Last Answer : Computer network is defined as a group of computers connected to each other by a link.

Answer the following questions based on the database given below: Prod_Id Prod_Name Category -Technology

Description : Answer the following questions based on the database given below: Prod_Id Prod_Name Category -Technology

Last Answer : 1. The primary key of the given table Product will be Prod _Id because no two products have the same Product_Id. So, it will be uniquely identified for each record in the table.2. The suitable data ... = 88. The data type OLE Object is suitable for adding the photograph of the product to the table.

Some features of a specific operating system are given below: 1. Free/Open source -Technology

Description : Some features of a specific operating system are given below: 1. Free/Open source -Technology

Last Answer : (i) Linux(ii) With Linux, you get four desktop screens known as workspace.

Write the HTML code to create the exact table which is given below: ADMNO SNAME NAME DOB -Technology

Description : Write the HTML code to create the exact table which is given below: ADMNO SNAME NAME DOB -Technology

Last Answer : The HTML code is ADMNO SNAMENAMEDOB1110MANJITRANJIT4-MAR-1998

Carefully study the Web page given below. Identify 10 tags (structural as well as formatting tags) that have been utilized -Technology

Description : Carefully study the Web page given below. Identify 10 tags (structural as well as formatting tags) that have been utilized -Technology

Last Answer : 1. to specify the title of the Web page.2. contains all the content that is to be displayed on the Web page and all the various formatting and structural tag.3. used to create an unordered ... anchor tag. Use the href attribute to provide the reference of the Web page that you want to hyperlink.

Carefully study the Web page given below. Identify 10 tags (structural as well as formatting tags) that have been utilized in creating this -Technology

Description : Carefully study the Web page given below. Identify 10 tags (structural as well as formatting tags) that have been utilized in creating this -Technology

Last Answer : 1. to specify title of the Web page.2. contains all the text content that is to be displayed on Web page and all the various formatting and structural tag.3. defines the most important and biggest ... provide caption to the table.9. used to create a table row.10. used to define data cells.

Draw the XML tree for code given below: -Technology

Description : Draw the XML tree for code given below: -Technology

Last Answer : The XML tree is

Draw the XML tree for the code given below: <MOVIES> <ENGLISH> -Technology

Description : Draw the XML tree for the code given below: -Technology

Last Answer : The XML tree is

Draw the XML tree for the code given below -Technology

Description : Draw the XML tree for the code given below -Technology

Last Answer : The XML tree is

Draw the XML tree for the code given below: -Technology

Description : Draw the XML tree for the code given below: -Technology

Last Answer : The XML tree is

Draw the XML tree for the code given below: -Technology

Description : Draw the XML tree for the code given below: -Technology

Last Answer : Draw the XML tree

Write the HTML code to generate the following web page with the given below specifications: -Technology

Description : Write the HTML code to generate the following web page with the given below specifications: -Technology

Last Answer : Income Tax Slabs 2017-18INCOME TAX SLABS 2017-18S.No.Income RangeTax%10-250000NIL2250001-50000010%3500001-100000020%4>100000030%Next Page

Dev, a website designer with “Creative Designers Pvt. Ltd.” has written the following code. Observe the code given below -Technology

Description : Dev, a website designer with “Creative Designers Pvt. Ltd.” has written the following code. Observe the code given below -Technology

Last Answer : (i) XML code(ii) Company(iii) name, dept(iv) eid, deptid

Write a code to plot the speed of a passenger train as shown in the figure given below: -Technology

Description : Write a code to plot the speed of a passenger train as shown in the figure given below: -Technology

Last Answer : import matplotlib.pyplot as pltimport numpy as npx = np.arange(1, 5)plt.plot(x, x*1.5, label='Normal')plt.plot(x, x*3.0, label='Fast')plt.plot(x, x/3.0, label='Slow')plt.legend()plt.show()

Write a python code to create a data frame with appropriate headings from the list given below : -Technology

Description : Write a python code to create a data frame with appropriate headings from the list given below : -Technology

Last Answer : import pandas as pd# initialize list of listsdata = [['S101', 'Amy', 70], ['S102', 'Bandhi', 69], ['S104','Cathy', 75], ['S105', 'Gundaho', 82]]# Create the pandas DataFramdf = pd.DataFrame(data, columns = ['ID', 'Name', 'Marks'])# printdataframe. print(df )

Write a small python codeto create a dataframewith headings(a and b) from the list given below : [[1,2],[3,4],[5,6],[7,8]] -Technology

Description : Write a small python codeto create a dataframewith headings(a and b) from the list given below : [[1,2],[3,4],[5,6],[7,8]] -Technology

Last Answer : import pandas as pddf = pd.DataFrame([[1, 2], [3, 4]], columns = ['a','b'])df2 = pd.DataFrame([[5, 6], [7, 8]], columns = ['a','b'])df = df.append(df2)

Write the code given below using ‘for’ loop instead of ‘while’ loop : -Technology

Description : Write the code given below using ‘for’ loop instead of ‘while’ loop : -Technology

Last Answer : The given code using ‘for’ loop instead of ‘while’ loop :int ifor (i = 1 ; i < = 5 ; i + +){if (1 * i = = 4)jTextFieldl. setText ( “ “ + i) ;}

A relation Vehicles is given below : V_no Type Company Price Qty AW125 Wagon Maruti 250000 25 J0083 Jeep Mahindra 4000000 15 -Technology

Description : A relation Vehicles is given below : V_no Type Company Price Qty AW125 Wagon Maruti 250000 25 J0083 Jeep Mahindra 4000000 15 -Technology

Last Answer : a. select Type, avg(Price) from Vehicle group by Type having Qty>20;b. select Company, count(distinct Type) from Vehicle group by Company;c. Select Type, sum(Price* Qty) from Vehicle group by Type;

Four square table-tops of the same dimensions are shown below. Only the designs of their supports are different from each other. If a person stands upright on the red mark on each of the table, which of the tables will topple?

Description : Four square table-tops of the same dimensions are shown below. Only the designs of their supports are different from each other. If a person stands upright on the red mark on each of the table, which of the tables will topple?  

Last Answer : B C D

If my car headlight is out, will an auto parts store salesperson put the bulb in for me, if I buy it there?

Description : If my car headlight is out, will an auto parts store salesperson put the bulb in for me, if I buy it there?

Last Answer : The Advance Auto store near me installed a headlight for me. They have also installed a battery and wiper blades.

Which salesperson would you expect to succeed out of these two types?

Description : Which salesperson would you expect to succeed out of these two types?

Last Answer : You nailed it with B person. people who sit on their duff are definetely not going anywhere. their salary proves this. B it is.

What’s the worst experience you’ve had with a salesperson?

Description : What’s the worst experience you’ve had with a salesperson?

Last Answer : I went to a store in a nicer town that is notorious for being snobby. This one store in particular is always rude to me but I like their clothes so I come In every now and then. I had ... the sales lady and the mother/daughter outside the room getting angry but I didn't care. Fuck those people.

What is a homonyms pair for Basement salesperson?

Description : What is a homonyms pair for Basement salesperson?

Last Answer : What is the answer ?

What statements best explains what it means to be your best salesperson?

Description : What statements best explains what it means to be your best salesperson?

Last Answer : What is the answer ?

How does a salesperson serve customers?

Description : How does a salesperson serve customers?

Last Answer : Need answer

Converting an opportunity to revenue by salesperson depends on ___________ 1. Sales manager 2. Pay scale 3. Skills and willingness of the sales person 4. Competitors5. None of these

Description : Converting an opportunity to revenue by salesperson depends on ___________ 1. Sales manager 2. Pay scale 3. Skills and willingness of the sales person 4. Competitors 5. None of these

Last Answer : Skills and willingness of the sales person

The type of sales person that usually required training in physical science or engineering is the 1. trade salesperson 2. missionary salesperson 3. technical salesperson 4. order take 5. order getting

Description : The type of sales person that usually required training in physical science or engineering is the 1. trade salesperson 2. missionary salesperson 3. technical salesperson 4. order take 5. order getting

Last Answer : technical salesperson