Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / Business Data Management Assignment I FIGURE P1

Business Data Management Assignment I FIGURE P1

Computer Science

Business Data Management Assignment I

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

1. (5 pts) How many records does the file contain? How many fields are there per record?

 

2. (10 pts) 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. (10 pts) What data redundancies do you detect? How could those redundancies lead to

anomalies?

 

4. (10 pts) Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure P1.5.

 

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

 

 5. (10 pts) How would you reorganize the data – i.e., what new files should you create to help eliminate the data redundancies found in the file shown in Figure P1.5?

 

 

6. (15 pts) Give an example of each of the three types of relationships (1:1, 1:N, M:N).

 

Using Figure P2.4 as your guide, work Problems 7–8. The DealCo relational diagram shows the initial entities and attributes for the DealCo stores, located in two regions of the country.

Figure P2.4 The DealCo relational diagram

 

7. (10 pts) Identify each relationship type and write all of the business rules.

 

8. (10 pts) Create the basic Crow’s Foot ERD for DealCo. (You can hand in a hand-drawn

diagram for this, but please make sure you have your name noted on the page, if you do so.)

9. (20 pts) Write the business rules that are reflected in the ERD shown in Figure P2.15.

(Remember that the ERD is always read from the “1” to the “M” side, regardless of the

orientation of the ERD components.) Will there be any problems in representing real-world data through this model (i.e., are any of the assumptions problematic in the real-world)?

FIGURE P2.15 The Crow’s Foot ERD for Problem 9

Option 1

Low Cost Option
Download this past answer in few clicks

22.99 USD

PURCHASE SOLUTION

Already member?


Option 2

Custom new solution created by our subject matter experts

GET A QUOTE