Solving the problem of deleting the table
State the steps for “this message could not delete” from the particular tables?
Expert
This error is caused due to the delete query and when unique property is set to “no”.
Following given are the steps that must be followed in order to solve the problem.
1) Delete query must be opened and if it is not opening then press F4.
2) Clicking on the query properties underneath query designer will provide you the options.
3) In that options, you require to locate the unique records property and must set it to yes. These options are present in the query property sheet.
Write down the importance for using repository connectivity?
Provide the formula for the Pearson’s r.
You have two tables, STUDENT and COMPUTER which are in a one-to-one relationship. The foreign key is StudNumber in COMPUTER that references StudNumber as the primary key of STUDENT. Describe what must be done to convert the one--to-one STUDENT -COMPUT
You have been given a setup of tables with data and inquired to make a new database to store them. What are you looking for, when you observe the data values in the tables?
Briefly describe the employed of data cube?
Give brief introduction of the term ‘Service Broker components’?
Describe the three types of data sources which are used with ODBC?
What is Relational Algebra?
Illustrate briefly the term DBMS?
Define the term File Manager and Storage Manager in relational database management system.
18,76,764
1931230 Asked
3,689
Active Tutors
1450099
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!