subject
Engineering, 18.02.2020 17:29 sarah121868

Write the SQL statement to create a five-field table to contain sample student information. The constraints that need to be satisfied by the attributes of this table are as follows:.a) the attribute First_Name is mandatory and can have up to 16 characters, b) the attribute Last_Name is mandatory and can have up to 16 characters, c) the attribute Date_Of_Birth is of type date is required, d) the StarID field identifies each student and is 8 characters longe) the GPA field is numeric that can be 2 digits with 1 decimal place. f) Be sure to select column names, types, and constraints that are appropriate based on the description above.

ansver
Answers: 2

Another question on Engineering

question
Engineering, 03.07.2019 15:10
Heat is added to a piston-cylinder device filled with 2 kg of air to raise its temperature 400 c from an initial temperature of t1 27 cand pressure of pi 1 mpa. the process is isobaric process. find a)-the final pressure p2 b)-the heat transfer to the air.
Answers: 1
question
Engineering, 04.07.2019 18:10
Coiled springs ought to be very strong and stiff. si3n4 is a strong, stiff material. would you select this material for a spring? explain.
Answers: 2
question
Engineering, 04.07.2019 18:10
Ajournal bearing has a journal diameter of 3.250 in with a unilateral tolerance of 20.003 in. the bushing bore has a diameter of 3.256 in and a unilateral tolerance of 0.004 in. the bushing is 2.8 in long and supports a 700-lbf load. the journal speed is 900 rev/min. find the minimum oil film thickness and the maximum film pressure for both sae 20 and sae 20w-30 lubricants, for the tightest assembly if the operating film temperature is 160°f. a computer code is appropriate for solving this problem.
Answers: 3
question
Engineering, 04.07.2019 18:10
Carbon dioxide gas expands isotherm a turbine from 1 mpa, 500 k at 200 kpa. assuming the ideal gas model and neglecting the kinetic and potential energies, determine the change in entropy, heat transfer and work for each kilogram of co2.
Answers: 2
You know the right answer?
Write the SQL statement to create a five-field table to contain sample student information. The cons...
Questions
question
Biology, 09.06.2020 04:57
question
Mathematics, 09.06.2020 04:57
Questions on the website: 13722360