1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Brilliant_brown [7]
4 years ago
5

SQL supports three types of tables: base tables, derived tables, and viewed tables. Using the Internet as a resource, research t

he four types of base tables, name them, provide a description of what they are, how they work, and why they are needed.
Engineering
1 answer:
MrRa [10]4 years ago
7 0

Answer and Explanation:

TYPES

[]User Table

User tables are the most important base tables, because they contain data that can be used later. They can be stored in hard drive and can also be deleted if you want.

[]Local temporary tables are the base tables that are stored in the "tempdb" folder. They are only available to the session where it was created. These base tables are self deleted once that session is over. They are denoted by #

[]Global temporary tables are base tables stored in "tempdb" folder also. But they are available not just to all sessions but also to all users. However, they are self removed when the temporary table has been completed at he last session. They are denoted by ##

[]Table variables are base tables used as alternatives to temporary tables used to store a set of records. The syntax of a table variable include: Insert into, select from, declare, etc.

DESCRIPTION

These tables are made of unique metadata that can be used anywhere in the SQL server.

These base tables are system based and are not for the general use, but are only used within the SQL Server Database Engine.

HOW THEY WORK

Base table is a structure that allows you to input and store records. Once the required table has been mapped as PROJECT Table, accessing the data using SQL statements becomes possible.

WHY ARE THEY NEEDED?

SQL base tables are used to uniquely search out individual row in the database. These base tables helps to ensure that two rows don't have the same value of primary key.

Practically, this means that by just knowing the primary key of a particular row, you can select every single row easily.

You might be interested in
What is the first step in the problem-solving process, as well as in the engineering design process?
DENIUS [597]

Answer:

C. Brainstorm

Explanation:

<em>Brainstorming refers to thinking and developing ideas and solutions to problems</em>. It involves a free-thinking approach and putting oneself in the context of the problem you are attempting to solve. You can use the empathy maps to combine ideas from interviewing other people on the same. This stage is followed by defining the problem, concept generation, developing a solution, constructing a testing a prototype, evaluating the solution and finally presenting the solution.

Answer choice A is incorrect because it is the last stage .

Answer choice B is incorrect because it is the second stage.

Answer choice D is incorrect because it is step 5 and 6.

5 0
4 years ago
Explain, with reasons, whether the LTIC systems described by the following differential equations are (i) stable or unstable in
taurus [48]

Answer:

Explanation:

The LTIC system is the Linear Time Invariant Theory, also known as LTI system theory, investigates the response of a linear and time-invariant system to an arbitrary input signal.

For the step by step Solution to the question you asked,  go through the attached documents.

8 0
3 years ago
Sarah is on a see saw with her friend. The pivot or fixed point where the bar is free to move is called the _____________?
Triss [41]
Answer: Fulcrum

Definition:
the point on which a lever rests or is supported and on which it pivots.

3 0
3 years ago
A 225 MPa conducted in which the mean stress was 50 MPa and the stress amplitude was (a) Compute the maximum and (b) Compute the
tamaranim1 [39]

Answer:

Explanation:

Given data in question

mean stress  = 50 MPa

amplitude stress  = 225 MPa

to find out

maximum stress, stress ratio, magnitude of the stress range.

solution

we will find first  maximum stress  and minimum stress

and stress will be sum of (maximum +minimum stress) / 2

so for stress 50 MPa and 225 MPa

\sigma _{m} =  \sigma _{maximum} + \sigma _{minimum}  / 2

50 =  \sigma _{maximum} + \sigma _{minimum}  / 2    ...........1

and

225 =  \sigma _{maximum} + \sigma _{minimum}  / 2      ...........2

from eqution 1 and 2 we get maximum and minimum stress

\sigma _{maximum} = 275 MPa        ............3

and \sigma _{minimum} = -175 MPa     ............4

In 2nd part we stress ratio is will compute by ratio of equation 3 and 4

we get ratio =  \sigma _{minimum} / \sigma _{maximum}

ratio = -175 / 227

ratio = -0.64

now in 3rd part magnitude will calculate by subtracting maximum stress - minimum stress i.e.

magnitude = \sigma _{maximum} - \sigma _{minimum}  

magnitude = 275 - (-175) = 450 MPa

3 0
3 years ago
The space shuttle fleet was designed with two booster stages. If the first stage provides a thrust of 686.68 Mega-newtons(MN) an
aksik [14]

Answer:

6.30 miles/hour

Explanation:

Newton's second law applies here. In simple terms:

F = ma

where F = Force (Thrust) in N

           a = acceleration (m/s²)

The acceleration can be given by rearranging the  formula to give:

a = \frac{F}{N}

  = \frac{(686.68*10^{6} )}{24811505120150.2656} \\= 0.0000277 m/s\\= 6.03 miles/hr

7 0
3 years ago
Other questions:
  • In the formula shown, k is a correction factor for nonideal mixing. In the worst case, k is usually estimated to be:_______. Cpp
    8·1 answer
  • 9. How is the Air Delivery temperature controlled during A/C operation?
    9·1 answer
  • Pure butanol is to be fed into a semibatch reactor containing pure ethyl acetate to produce butyl acetate and ethanol. The react
    9·1 answer
  • Let m be an integer in the set {0,1,2,3,4,5,6,7,8, 9}, and consider the following problem: determine m by asking 3-way questions
    12·1 answer
  • If outside of the flask is not dry when first determination is made and it is dried for second determination, what effect will t
    15·1 answer
  • Coderz robotics 101: challenge mission 3 part 3
    8·1 answer
  • Blood pressure is conventionally measured in the dimensions of millimeters in a column of mercury, and the readings are expresse
    5·1 answer
  • Which of the following is an interdisciplinary approach to architectural or interior design most like?
    11·2 answers
  • 10. Which one of the following items would you expect to find on a floor framing plan?
    6·2 answers
  • 1 A power transmission includes a belt drive, a chain drive and a gear drive. Which of the following is the best arrangement bet
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!