In: Computer Science
PLEASE ANSWER ASAP
1- The major tool used to draw/construct a logical database design is the _______________.
2-
The ID field is planned to be the primary key field in the below diagram. No fields are required to be filled/entered.
ID |
Equipment Type |
Equipment Number |
Daily Rate |
phone no |
1 |
Back Hoe |
10400 |
$750.00 |
diesel powered |
1 |
Medium Crane |
335 |
$350.00 |
plus tax |
3 |
Back Hoe |
10020 |
$650.00 |
(631) 992-4567 |
(516) 429-0800 |
||||
3 |
Scaffolding |
|||
5 |
Foundation |
335 |
$0.00 |
11/17/1952 |
Give two reasons why the above flat file could not serve as valid database table.
A)
B)
3- Queries that can be written after the database has been designed, populated and in use, that were not originally created during the development of the DB, are called
a) ad hoc
b) SQL
c) transactional
d) user