Skip to main content

IT management


FIGURE P1.1 The File Structure for Problems 1-4

1.      How many records does the file contain? How many fields are there per record?

2.      What problem would you encounter if you wanted to produce a listing by city? How would you solve this problem by altering the file structure?


3.      If you wanted to produce a listing of the file contents by last name, area code, city, state, or zip code, how would you alter the file structure?


4.      What data redundancies do you detect? How could those redundancies lead to anomalies?

Figure P2.4 The DealCo relational diagram


4. Identify each relationship type and write all of the business rules.

5.      Create the basic Crow’s Foot ERD for DealCo.



FIGURE P3.17The Ch03_TransCo Database Tables

    17. For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None.


      18.  Do the tables exhibit entity integrity? Answer yes or no and then explain your answer.
19.  Do the tables exhibit referential integrity? Answer yes or no and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key.
20.  Identify the TRUCK table’s candidate key(s).

21.  For each table, identify a superkey and a secondary key.
22.  Create the ERD for this database.

23.  Create the relational diagram for this database.

Comments

Popular posts from this blog

Osmosis Data Sheet

Data Sheet: Activity - Osmosis Name Course Date Activity Data Code       Procedure I -Test Solution 1: Water Complete the tablesand questions below using your data and information found under the Background tab Data Table I Note: Difference in Final Volumes = Final Volume of Test Sol - Final Volume of Water Trial Starting Volume of Test Solution (L) Starting Volume of Water (L) Final Volume of Test Solution (L) Final Volume of Water (L) Difference in Final Volumes (L) 1 1.28 1.75 1.51 1.52 -0.01 2 1.28 2.00 1.64 1.64 0 Observations and Questions [1] Given that the final heights (and volumes) are the same for the water and test solution, what can you...

Pseudocode - painting a wall

My pseudocode from Module Two: Pseudocode – Painting a Wall MEASURE wall-length MEASURE wall width CALCULATE wall area DETERMINE amount of paint needed for wall-size PURCHASE desired paint and tools (brushes, rollers, pan, etc.) PREPARE work area and tools START painting wall END when painting is complete CLEAN work area and tools STORE tools and any leftover pa​‌‌‌‌‌‌‍‍‍‌‌‍‍‍‌‍‌‍‍​int
Simple Computer Science Questions Question 2 ANSWER Match the following a - 4 b - 10 c - 8 d - 6 e - 9 f - 1 g - 2 h - 7 i - 3 j - 5