Question

ITCO231

Unit 3

Discussion

Assignment Details

You encounter databases on a daily basis as you interact with different types of systems. Now, you want to consider how an organization determines the following:

• The types of things (entities)
• Information about those things (attributes)
• How the things are connected (relationships)

What types of people, processes, support documents, or other resources do you think would be important when identifying entities, attributes, and relationships for a new database?

When considering this topic, think about how a database might be used and the reasons that people outside of the information technology (IT) team within an organization might be involved in the design input for a new database system.

Answer 1

The type things(entities) is a thing, person , place or object to which the data should be stored and captured in the form of property and it is an example of a real life object that for a person is an entity and this entity is further divided into the attributes like name of person , date of birth of person , address, phone number etc and these are thing where the data is stored in a particular and all these are internally related to each other with the help of the relationship like each employees has a dept no which act as a relationship of the employee to that department and it job title representing how the employee is to related to other.

the organization defines a simple requirement deocument where they gather details about the data needs to be stored ad how they will be related to each other and what sort of data is to be stored and how they should represent a real world scenario.The organization take input from the memeber outside the IT team to get the know the details of the imformation that needs to be stored and they will be used and related to each other using the relation and what type of hierarchy will be used. What kind of process are required by the organization for the better engagement of the database like determining a data can be used and what level of authentication is required to use the data.