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

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

1 Answer

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

Related questions

Consider the tables given below. Salesperson -Technology

Description : Consider the tables given below. Salesperson -Technology

Last 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.

Observe the following code carefully and answer the questions that follow: -Technology

Description : Observe the following code carefully and answer the questions that follow: -Technology

Last Answer : The output of the above code will be:The Dos and Don'ts of network securityAs per the output it is evident that the list elements specified as li have been displayed in Lower case due to :text-transform: ... Also, there is a space of 10 pixels between each letter due to : letter-spacing : 10 px ;

Carefully observe the following labeled screenshot and answer the questions that follow: -Technology

Description : Carefully observe the following labeled screenshot and answer the questions that follow: -Technology

Last Answer : (a) Form element labeled as 1 is a Textbox and Form element labeled as 2 is a Textarea.(b)Text areas are the fields that display multiple text lines at a time hence it has been used to ... of items.To highlight one item in a dropdown box , selected clause is used in theEg:SINGAPOREJAPAN MALAYSIA

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 following DataFrame df and answer questions. rollno name UT1 UT2 UT3 UT4 1 Prerna Singh 24 24 20 22 -Technology

Description : Consider the following DataFrame df and answer questions. rollno name UT1 UT2 UT3 UT4 1 Prerna Singh 24 24 20 22 -Technology

Last Answer : (i) (b)print(df.max())(ii) (a)df1=df[df[‘rollno’]==4]print(df1)(d)df1=df[df.rollno==4]print(df1)(iii)(a)both (i) and (ii)(iv)(d) both (i) and (ii)(v)(b)df [‘Grade’]=[’A’,’B’,’A’,’A’,’B’,’A’]

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

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.

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.

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

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

Look at the given table called ‘Item’ and answer the questions. ItemId ItemName ItemStock ItemDOP Quanity Purchased -Technology

Description : Look at the given table called ‘Item’ and answer the questions. ItemId ItemName ItemStock ItemDOP Quanity Purchased -Technology

Last Answer : 1. ItemID —> TextItemName —> TextItemStock —> NumberItemDOP —> DateQuantityPurchased —> Number2. ItemID and ItemName can act as primary key.

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.

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 

Can someone answer some questions on foreclosure purchases?(Details follow)

Description : Can someone answer some questions on foreclosure purchases?(Details follow)

Last Answer : answer:Buyers Agents do not participate in any way with a commission from the sale. You pay them an upfront fee, and they agree to represent you and only you. Any agent that receives a ... sites online dedicated to helping you understand foreclosure sales. This one might be helpful. also try this

Study the climatic data provided in the table below for a city A in India and answer the questions that follow : -Geography

Description : Study the climatic data provided in the table below for a city A in India and answer the questions that follow : -Geography

Last Answer : (i) Rain shadow region. (ii) (18°C) – (-8°C) = 26°C.

Study the climatic data provided in the table below for a city A in India and answer the questions that follow : -Geography

Description : Study the climatic data provided in the table below for a city A in India and answer the questions that follow : -Geography

Last Answer : Two main features of the climate experienced by station A : (i) 1. The range of temperature is as high as (39°C – 20°C) = 19°C. 2. The station receives rain from southwest monsoon. (ii) 1552 mm.

Study the data of distribution of temperature and rain for Station X and answer the questions that follow : -Geography

Description : Study the data of distribution of temperature and rain for Station X and answer the questions that follow : -Geography

Last Answer : 1. As temperature range is very high so station X is in the interior of the country. 2. Annual rainfall = 2 + 1+0+5 + 15 + 62+71 + 81 + 59+12+10+3 = 321cm 3. South-west monsoon

Study the climatic data given below and answer the questions that follow: 1. What is the annual range temperature of the station? -Geography

Description : Study the climatic data given below and answer the questions that follow: 1. What is the annual range temperature of the station? -Geography

Last Answer : 1. 36.2 °C – 12 °C = 24. 2 °C 2. 1.5 + 0.1 + 0.0 +1.4 + 1.1 + 21.0 + 25.3 + 27.2 + 24.0 + 9.4 + 1.5 + 0.4 = 112.9 cm 3. Temperature range is very high so we can conclude the station is away from the equable effect.

Study the climatic data given below and answer the questions that follow : -Geography

Description : Study the climatic data given below and answer the questions that follow : -Geography

Last Answer : (i) Annual range of temperature = 36.2 – 24.6 = 11.6°C. (ii) Total annual rainfall = 140.9 cm (iii) The station lies on the west coast of India because the amount of rainfall is high in the month of June and July.

Study the climatic data given below and answer the questions that follow : -Geography

Description : Study the climatic data given below and answer the questions that follow : -Geography

Last Answer : (i) Mean annual temperature – 28°C (ii) Total rainfall – 180.5 cm. (iii) Station has maritime type of climate because it has low range of temperature i.e., 6.6°C

Study the climatic data given below and answer the questions that follow : -Geography

Description : Study the climatic data given below and answer the questions that follow : -Geography

Last Answer : (i) Driest month is March. (ii) Annual rainfall is 129.2 cms. (iii) Annual range of temperature is 12.1°C.

Study the climatic data provided below and answer the questions that follow : -Geography

Description : Study the climatic data provided below and answer the questions that follow : -Geography

Last Answer : (i) The annual range of temperature of Station B is 5.6°C (30.0-24.4). (ii) The annual rainfall of Station A is 67.4 cm. (iii) B' is at the windward side of the Western Ghats as it is ... .4 and 16.7 cm of rainfall in the same months, which shows that it lies on the leeward side of the mountain.

Given below is the climatic data of a station. Study the table and answer the questions that follow : -Geography

Description : Given below is the climatic data of a station. Study the table and answer the questions that follow : -Geography

Last Answer : (i) Annual rainfall experienced by the station is 128.7 cm. (ii) Annual range of temperature is 12.1°C. (iii) November is the wettest month.

Study the climatic data provided below and answer the questions that follow -Geography

Description : Study the climatic data provided below and answer the questions that follow -Geography

Last Answer : (i) Annual range of temperature of station A is 5.6°C which is low because of the station is close to the sea. (ii) Station B has the lower organization because it is situated at greater altitude. (iii) Annual rainfall of station B is 31.8 cm.

Look at the picture carefully and answer the questions that follow : -SST 10th

Description : Look at the picture carefully and answer the questions that follow : -SST 10th

Last Answer : (i) The crop shown in the picture is sugarcane. (ii) The climatic conditions required for its growth : Sugarcane is a crop of tropical and sub-tropical climate. It grows well in hot ... and harvesting is favourable. (iii) Uttar Pradesh and Maharashtra are two major producing states of sugarcane.

Look at the given picture carefully and answer the questions that follow : -SST 10th

Description : Look at the given picture carefully and answer the questions that follow : -SST 10th

Last Answer : (i) The crop shown in the picture is paddy or rice, the main staple foodgrain for majority of the people in India. (ii) The climatic conditions required for cultivation of rice are as ... Coastal areas and deltaic regions with alluvial soil like Orissa, and parts of Andhra Pradesh and Tamil Nadu.

Study the following table carefully and answer the questions that follow : -SST 10th

Description : Study the following table carefully and answer the questions that follow : -SST 10th

Last Answer : (i) 1,40,581 kms (ii) 484 kms (iii) Narrow Gauge (0.762 and 0.610 metres). Broad Gauge (1.676 metres) difference = 0.914 metres between Broad Gauge and Narrow Gauge.

Study the table given below and answer questions that follow : -SST 10th

Description : Study the table given below and answer questions that follow : -SST 10th

Last Answer : (a) 1.04 million tonnes. (b) 31.56 m. tonnes. (c) Because of huge number of population in comparison to steel production.

Study the table given below and answer the questions that follow : -SST 10th

Description : Study the table given below and answer the questions that follow : -SST 10th

Last Answer : (i) Poor households share of formal credit in urban areas is low as compared to that of rich households due to the following reasons : (a) Poors generally lack in collateral guaranters ... the boor borrowers personally and therefore flexible in terms of repayment schedule, amount and interest etc.

Study the diagram given below and answer the questions that follow : -SST 10th

Description : Study the diagram given below and answer the questions that follow : -SST 10th

Last Answer : (a) Moneylenders and cooperative societies. (b) Moneylenders (c) (i) Moneylenders do not ask for a collateral. (ii) Complicated paper work or documentation is not involved.

Study the given passage and answer the questions that follow : -SST 10th

Description : Study the given passage and answer the questions that follow : -SST 10th

Last Answer : (i) It was the right of the Indian people to enjoy the fruits of their own labour and toil. They had the right to all necessities of life and full opportunities of growth. ... rights, deprived them of freedom and exploited them in every way-economically, politically, culturally and spiritually.

Study the given passage carefully and answer the questions that follow. -SST 10th

Description : Study the given passage carefully and answer the questions that follow. -SST 10th

Last Answer : (i) Physical force inflicts pain on the enemy or adversary, it seeks to destroy the enemy. Soul force is based on love and non-violence. It does not seek to destroy. Truth is the substance on which ... cannot match Britain or Europe in force of arms. They do not worship the war-god or carry arms.

Study the passage given below and answer the questions that follow: -SST 10th

Description : Study the passage given below and answer the questions that follow: -SST 10th

Last Answer : This answer was deleted by our moderators...

Read the passage given below and answer the questions that follow : -SST 10th

Description : Read the passage given below and answer the questions that follow : -SST 10th

Last Answer : (2.1) This pledge was taken on Independence Day, 26 January; 1930. (2.2) The Rights which the Indians should have got are : (i) Right to freedom, which the British rule denied ... right to rule themselves. They imposed western culture at the cost of Indian culture and crushed their spirituality.

Compare the diagrams showing land use patterns of India and answer the questions that follow: -SST 10th

Description : Compare the diagrams showing land use patterns of India and answer the questions that follow: -SST 10th

Last Answer : (i) Increase in net sown area & forest. (ii) Due to afforestation.

Study the data given in the table carefully and answer the questions that follow: -SST 10th

Description : Study the data given in the table carefully and answer the questions that follow: -SST 10th

Last Answer : (i) Kerala: 91% (ii) Punjab: ` 26,000. Reason: Developed infrastructural facilities. (iii) Bihar. Reason: The state lacks health facilities.

Study the climatic data provided below and answer the questions that follow: -SST 10th

Description : Study the climatic data provided below and answer the questions that follow: -SST 10th

Last Answer : (i) 30°C – 24.4°C = 5.6°C. (ii) 67.4 cms. (iii) Station B as it gets more rainfall in the months of June, July, August.

Read the extract given below and answer the questions that follow: -SST 10th

Description : Read the extract given below and answer the questions that follow: -SST 10th

Last Answer : (i) The leaders given in picture 1 and picture 2 are Dada Bhai Naoroji and Gopal Krishna Gokhale respectively. (ii) Through his famous Drain Theory' Dada Bhai Naoroji explained as to how India' ... to British Officers, (d) Payments to the war office for the maintenance of British troops in India.

Study the picture given and answer the questions that follow: -SST 10th

Description : Study the picture given and answer the questions that follow: -SST 10th

Last Answer : (i) Adolf Hitler. (ii) Factors that-led to the rise of dictatorships in Germany and Italy are: (a) Dissatisfaction of the Peace Treaties. (b) Economic factors. (c) Inefficient and Corrupt Democratic Government. (d) Rise of Totalitarian Ideology.

Study the picture shown and answer the questions that follow: -SST 10th

Description : Study the picture shown and answer the questions that follow: -SST 10th

Last Answer : (i) The organization associated with the above emblem is the United Nations Organizations. (ii) The headquarter of this organization is located in New York city. The six principal ... The International Court of Justice, The Economic and Social Council Trusteeship Council and The Secretariat.

Study the picture shown and answer the questions that follow: -SST 10th

Description : Study the picture shown and answer the questions that follow: -SST 10th

Last Answer : (i) The organization associated with the given emblem is World Health Organization (WHO). (ii) It was established on 7th April, 1948 and its objective is the attainment of the highest possible level of health by all people.