Q. No. 3 (4) a. (2) When building a database (DB), an organization must consider
ID: 3677195 • Letter: Q
Question
Q. No. 3 (4)
a. (2)
When building a database (DB), an organization must consider the following elements of BD design:
Content
Access
Logical structure
Physical organization.
What is your understanding of each of these elements? Express your understanding in three sentences for each element.
b. (2)
You are the information system consultant for a luxury car dealership. This company wants to identify likely customers in the geographic area in the vicinity of the dealership.
i. What key data items would be useful in estimating the number of potential customers?
ii. What are some possible sources for these data items?
iii. Would datamining be useful in estimating the number of potential customers? Why?
Explanation / Answer
3.(4)
a(2)
Content:Content is the data present in the database.The sole purpose ofbuilding a data base is to store the contents.Contents can be of varied types i.e we use data base to store differnt kinds of contents.Before designing a database,the organisation must know the type of content stored in the database.Based on the content database is cdesigned.
Access:Access means, ways of reading and writing data or contents to the database.As told previously,we have diffent kinds of contents in which some are very very crucial contents.So protection is necessary to these contents.We have various kinds of access to these contents like public or private,to protect the crucial contents.so various kinds of access to database matters.Private is the most strict form of access in database.
Logical structure:Logical structure speaks about where we store data in an database.Logical structure includes field,record,table etc.
field:It holds single piece of data and it is smallest unit in database.
Ex:Name field
record:It has various fields.Basically a set of data comprises a record.
Eg:set of student names and age from college A.This can have single student name and age too
Table:It has set of specified rows(M) and colums(N) where M and N has a value.We store information which belong to one particular category in a table.Basically records are organized in tables.
Eg:List of students enrolled with all their details in neat and nice manner
Physical organization:It speaks about how to store data in an database.In a higher level,it is the process of describing the database implementation on secondary storage like hard disks,flash drives etc.
b(2)
i)First we have to roughly estimate the income of people in the vicinity of the dealership.The more the people with good income,the better the sales.
ii)We have to get to know the GDP(Gross Domestic Product) of the area,which will tell about the wealth of the people,their business,as a whole economy.
iii)Data mining is useful.Because we can do the segregation of the different groups of people ,only by using datamining techniques.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.