Creation of an information system : To create an information system an initial study and following phases are need to be made by the designer because they will create an impact to the design of the database . The information is collected in order to establish details about the entities, relationships among the entities generated. Business rules that are shaped up through relationships, connectivity and cardinalities are being obtained and collected through designer. Question that can be asked in order to create an information system: The below are some of the sample questions that can impact the design of the database: Is it required to develop the database for all departments at once or whether it is required to design and implement the database for one particular department? What will the design approach required that could affect the process of designing? What type of development is required, one module at a time or integrated system approaches (Example: Billing, production, shipping and inventory)? What type of tracking system is required that is in terms of tracking the nuts and bolts through lot number, by shift, by production, by type or by department? What type of tracking system is required for the suppliers of each batch that is in terms raw materials used in the production of the nuts and bolts? Is it required to track the customer information regarding the receive summary of nuts and bolts based on batches? What type of reporting system is required that is what type of reporting requirements are required and who requires the distribution report details needs to be specified? Effect of the questions that are asked: The answers to the above question affect the database design in conceptual and in logical way along with the implementation, testing made with the subsequent operations.

Question

Suppose that you have been asked to create an information system for a manufac-turing plant that produces nuts and bolts of many shapes, sizes, and functions. What questions would you ask, and how would the answers affect the database design? a. What do you envision the SDLC to be? b. What do you envision the DBLC to be?

Answer 1

Question

Chapter 9, Problem 2P

a)

Program Plan Intro

Creation of an information system:

To create an information system an initial study and following phases are need to be made by the designer because they will create an impact to the design of the database.

The information is collected in order to establish details about the entities, relationships among the entities generated.

Business rules that are shaped up through relationships, connectivity and cardinalities are being obtained and collected through designer.

Question that can be asked in order to create an information system:

The below are some of the sample questions that can impact the design of the database:

Is it required to develop the database for all departments at once or whether it is required to design and implement the database for one particular department?

What will the design approach required that could affect the process of designing?

What type of development is required, one module at a time or integrated system approaches (Example: Billing, production, shipping and inventory)?

What type of tracking system is required that is in terms of tracking the nuts and bolts through lot number, by shift, by production, by type or by department?

What type of tracking system is required for the suppliers of each batch that is in terms raw materials used in the production of the nuts and bolts?

Is it required to track the customer information regarding the receive summary of nuts and bolts based on batches?

What type of reporting system is required that is what type of reporting requirements are required and who requires the distribution report details needs to be specified?
Effect of the questions that are asked:

The answers to the above question affect the database design in conceptual and in logical way along with the implementation, testing made with the subsequent operations.

b)

Program Plan Intro

Creation of an information system:

To create an information system an initial study and following phases are need to be made by the designer because they will create an impact to the design of the database.

The information is collected in order to establish details about the entities, relationships among the entities generated.

Business rules that are shaped up through relationships, connectivity and cardinalities are being obtained and collected through designer.

Question that can be asked in order to create an information system:

The below are some of the sample questions that can impact the design of the database:

Is it required to develop the database for all departments at once or whether it is required to design and implement the database for one particular department?

What will the design approach required that could affect the process of designing?

What type of development is required, one module at a time or integrated system approaches (Example: Billing, production, shipping and inventory)?

What type of tracking system is required that is in terms of tracking the nuts and bolts through lot number, by shift, by production, by type or by department?

What type of tracking system is required for the suppliers of each batch that is in terms raw materials used in the production of the nuts and bolts?

Is it required to track the customer information regarding the receive summary of nuts and bolts based on batches?

What type of reporting system is required that is what type of reporting requirements are required and who requires the distribution report details needs to be specified?
Effect of the questions that are asked:

The answers to the above question affect the database design in conceptual and in logical way along with the implementation, testing made with the subsequent operations.

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Students have asked these similar questions

Suppose that you have been asked to create an information system for a manufac-turing plant that produces nuts and bolts of many shapes, sizes, and functions. What questions would you ask, and how would the answers affect the database design? a. What do you envision the SDLC to be? b. What do you envision the DBLC to be?

Draw an ER diagram of the following: You are going to set up a database company that builds a product for art galleries. The core of this product is a database that captures all the information that galleries need to maintain. Galleries keep information about artists, their names (which are unique), birthplaces, age, and style of art. For each piece of artwork, we need to record its unique title, the year it was made, its type of art (e.g., painting, lithograph, sculpture, photograph), and its price. An artist may paint many pieces of artwork and a piece of artwork is done by one artist. Pieces of artwork are also classified into groups of various kinds (for example, portraits, works by Picasso, or works of the 19th century). A given piece may belong to more than one group. Each group is identified by a name that describes the group. Finally, galleries keep information about customers. For each customer, galleries keep that person’s unique name, address, total amount of dollars spent…

Suppose you are asked to design a club database system based on the following information. Each student has a unique student id, a name, and an email; each club has a unique club id, a name, a contact telephone number, and has exactly one student as its president. Each student can serve as a president in at most one of the clubs, although he/she can be the members of several clubs. Clubs organize activities and students can participate in any of them. Each activity is described by a unique activity id, a place, a date, a time and those clubs that organize it. If an activity is organized by more than one club, different clubs might contribute different activity fees.QuestionDraw an E-R diagram for the system according to the above description.