Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you please check if these are correct? D) Sequential ) None of the above. 16. Select the best answer. Data modeling is essentialiy Drawing
Can you please check if these are correct?
D) Sequential ) None of the above. 16. Select the best answer. Data modeling is essentialiy Drawing entities and attributes of those entities B) Documenting businesa rules and polscies of an organization that go c) Storing large files of data D) Sharing large files of data E) None of the above data 17. A method to allow adjacent secondary from several tables is called: memory space to contain rows cluttering clustering. ) concatenating D) compiling. 18. A key decision in the physical design process is: ignoring the size of the database. B,selecting structures deciding on the monitor D) deciding the e-r diagrams 19. Designing physical files requires various ways of where and when data are used in maps B) descriptions D) hints 20. The smaliest unit of application data recognized by system software is a: A) field. data type. column 21. (20 Points) The relation PART_SUPPLIER (Part No, Description, Vendor Name Vendor Address, Unit Cost) below contains sample data for parts and for vendors who supply those parts. The composite primary key of this relation is Part No and Vendor_ Name. The meaning of each row in PART_SUPPLIER relation (see below) is that a particular vendor supplies a particular part at a certain unit cost In discussing these data with users, the database analyst found that part numbers (but not descriptions) uniquely identify parts, and that vendor names uniquely identify vendors. Moreover, a single vendor may supply multiple parts and a single part might be supplied by different vendors. Please answer each of the following questions: a. Draw a relational schema for this relation and show the functional dependencies. b. In what normal form is this relation? c. If this relaton is not in third normal form, normalize the relation so the the resulting relations are in third normal form. Underline the primary ke and show an arrow from the foreign key to its corresponding primary key PART SUPPLIER Unit Cost Part No Description 234 1234 Vendor Name Fast Chips Smart Chips Fast Chips Vendor Address Cupertino Phoenix Cupertino Austin Phoenix 10.00 3.00 4.00 ic Chi Logic Chip MemoY Quality Chips Memory Chip 5678 Smart Chips D) Sequential ) None of the above. 16. Select the best answer. Data modeling is essentialiy Drawing entities and attributes of those entities B) Documenting businesa rules and polscies of an organization that go c) Storing large files of data D) Sharing large files of data E) None of the above data 17. A method to allow adjacent secondary from several tables is called: memory space to contain rows cluttering clustering. ) concatenating D) compiling. 18. A key decision in the physical design process is: ignoring the size of the database. B,selecting structures deciding on the monitor D) deciding the e-r diagrams 19. Designing physical files requires various ways of where and when data are used in maps B) descriptions D) hints 20. The smaliest unit of application data recognized by system software is a: A) field. data type. column 21. (20 Points) The relation PART_SUPPLIER (Part No, Description, Vendor Name Vendor Address, Unit Cost) below contains sample data for parts and for vendors who supply those parts. The composite primary key of this relation is Part No and Vendor_ Name. The meaning of each row in PART_SUPPLIER relation (see below) is that a particular vendor supplies a particular part at a certain unit cost In discussing these data with users, the database analyst found that part numbers (but not descriptions) uniquely identify parts, and that vendor names uniquely identify vendors. Moreover, a single vendor may supply multiple parts and a single part might be supplied by different vendors. Please answer each of the following questions: a. Draw a relational schema for this relation and show the functional dependencies. b. In what normal form is this relation? c. If this relaton is not in third normal form, normalize the relation so the the resulting relations are in third normal form. Underline the primary ke and show an arrow from the foreign key to its corresponding primary key PART SUPPLIER Unit Cost Part No Description 234 1234 Vendor Name Fast Chips Smart Chips Fast Chips Vendor Address Cupertino Phoenix Cupertino Austin Phoenix 10.00 3.00 4.00 ic Chi Logic Chip MemoY Quality Chips Memory Chip 5678 Smart ChipsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started