Question
Given then following Attribute Usage Matrix and Application access frequency, construct the Attribute Affinity matrix: Assume that A1 is the primary key attribute .(8 Marks)
Given then following Attribute Usage Matrix and Application access frequency, construct the Attribute Affinity matrix: Assume that A1 is the primary key attribute.(8 Marks)
|
| A1 | A2 | A3 | A4 | A5 |
| Q1 | 1 | 1 | 0 | 0 | 1 |
| Q2 | 0 | 0 | 1 | 1 | 1 |
| Q3 | 1 | 0 | 1 | 0 | 1 |
| Q4 | 1 | 0 | 1 | 0 | 1 |
| Q5 | 1 | 0 | 1 | 1 | 0 |
|
| S1 | S2 | S3 |
| Q1 | 20 | 10 | 0 |
| Q2 | 0 | 5 | 10 |
| Q3 | 35 | 0 | 2 |
| Q4 | 10 | 2 | 0 |
| Q5 | 15 | 0 | 0 |
Step 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
Advances In Databases And Information Systems Uropean Conference Adbis 2020 Lyon France August 25 27 2020 Proceedings Lncs 12245
Authors: Jerome Darmont ,Boris Novikov ,Robert Wrembel
1st Edition
3030548317, 978-3030548315
