Question

Business Analysis

Describe the scenario below and the Business Requirements

What assumptions have you made provide you have limited facts presented in the  scenario below?

What constraints are placed on the scenario below if any?

List the potential nouns in the scenario below

Cluster the nouns in entities / attributes

Scenario below :

Art Gallery Management Database Project: A local art gallery has approached your team to help them set up their database. To simplify things for this project, let’s assume the new database must only keep track of the following: A record of each artist – name, birthplace, age, style of art A record of each art piece – name of the piece, year it was made, type of art, price of art A record of customers – name, address, total dollars they have spent so far, and preference for style of art This art gallery is looking to your team to deliver a database where they can manage the data specified above.

Answer 1

1. Scenerio in the above problem is nothing but the local art gallery is unable to manage the huge records of artist,art piece and customer details.As it is difficult to manage the record without the database.It can be simplified with the help of the database.

Business Requirement is nothing but to design the database for a local art gallery.

2. The above business model requires to design the database for entities namely- Artist, Art piece and a Customer This entities have fewer attributes. Managing them with the help of application software in terms of updating,inserting and deleting the records in the database.This makes the design so limited and hassle-free.

3.Constraints are nothing but restriction, in the above business scenario there is no constraints for the three entities.Every entities holds the relationship of One-Many,One-One relationship.

4. Potential nouns in the above scenario are - Artist, Art piece and Customer.

5. Cluster of nouns

ENTITIES	ATTRIBUTES
Artist	Name,Birthplace,Age,Style of art
Art piece	Name,Year,Type of art,Price
Customers	Name,address,total dollars spent, Preference for style of art