X C 17. A Use Case UC1 Includ x + רן Database design grouo A X Ghich of the layer is below GWhich of the following is X
Posted: Fri Apr 29, 2022 7:03 am
- 1 (225.97 KiB) Viewed 37 times
requirements and the business rules, write the relational schema
and draw the dependency diagram for the preceding (and very poor)
table structure. Label all transitive and/or partial dependencies.
b) Break up the dependency diagram you drew in task (a) to produce
dependency diagram that are in 3NF and write the relational schema.
(Hint: You might have to create a few new attributes. Also make
sure that the new dependency diagrams contain attributes that meet
proper design criteria; that is, make sure there are no multivalued
attributes, that the naming conventions are met, and so on.) c)
Using the results of task (b), draw the Crow’s Foot ERD. d) Create
a database using MySQL, with primary keys, foreign keys, and other
attributes mentioned for each entity of the ERD in task (c) using
proper constraints. e) Populate each of the tables created in task
(d) with some significant data (See Table 1 for sample data) f)
Create FOUR queries. (One SELECT, one Numeric function and two
JOIN)
X C 17. A Use Case UC1 Includ x + רן Database design grouo A X Ghich of the layer is below GWhich of the following is X Android MCQ (Multiplex C Get Homework Help With X X moodle.cihe.edu.au/pluginfile.php/28666/mod_resource/content/1/Database%20design%20group%20Assignment.pdf YouTube Mags Maus mh Mundemni Integrily... Grade Installation * Database design group Assignment.pdf 2/4 | - 100% + ) 6 ! This assessment is a group Project. The manager of a consulting firm has asked you to evaluate a database that contains the table structure shown in the Table 1 below: 目 Attribute Name Sample Value Sample value Sample Value CLIENT_NUM 298 289 289 CLIENT_NAME Marianne R. Brown James D. Smith James D. Smith CLIENT REGION Midwest Southeast Southeast CONTRACT DATE 10-Feb-2020 15-Feb-2020 12-Mar-2020 CONTRACT NUMBER 5841 5842 5843 CONTRACT_AMOUNT $2,985,00.00 $670,300.00 $1,250,000.00 CONSULT_CLASS 1 Database Administration Intemet Services Database Design CONSULT_CLASS_2 Web Applications Database Administration CONSULT CLASS 3 Network Installation CONSULT CLASS 4 CONSULTANT NUM 1 129 34 25 CONSULTANT_NAME_1 Rachel G. Carson Gerald K. Ricardo Angela M. Jamison CONSULTANT_REGION_1 Midwest Southeast Southeast CONSULTANT NUM 2 56 38 34 CONSULTANT_NAME_2 Karl M. Spenser Anne T. Dimarco Gerald K. Ricardo CONSULTANT REGION 2 Midwest Southeast Southeast CONSULTANT_NUM_3 22 45 CONSULTANT NAME 3 Julian H. Donatello Geraldo J. Rivera CONSULTANT_REGION_3 Midwest Southeast CONSULTANT_NUM_4 18 CONSULTANT_NAME_4 Donald Chen CONSULTANT REGION 4 West 3 Table 1: Sample CLIENT Records 1 Table 1 was created to enable the manager to match clients with consultants. The objective is to match a client within a given region with a consultation in that region and to make sure that the client's need for specific consulting services is properly matched to the consultant's expertise. For example, if the client needs help with database design and is located in the Southeast, the objective is to make a match with a consultant who is located in the Southeast and whose expertise is in database design. Although the consulting company manager tries 190 Mostly cloudy 00 21:29 26/04/2022 6