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

I would like to get help to resolve the following case

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

I would like to get help to resolve the following case

Last Chance Securities The IT director opened the department staff meeting today by saying, "I've got some good news and some bad news. The good news is that management approved the payroll system project this morning. The new system will reduce clerical time and errors, improve morale in the payroll department, and avoid possible fines and penalties for noncompliance. The bad news is that the system must be installed by January 1st in order to meet new federal reporting rules, all expenses from now on must be approved in advance, the system should have a modular design if possible, and the vice president of finance would like to announce the new system in a year-end report if it is ready by mid-December." Tasks 1. Why is it important to define the project scope? How would you define the scope of the payroll project in this case? 2. Review each constraint and identify its characteristics: present versus future, internal versus exter- nal, and mandatory versus desirable. 3. What…

2. Signed Integers Unsigned binary numbers work for natural numbers, but many calculations use negative numbers as well. To deal with this, a number of different methods have been used to represent signed numbers, but we will focus on two's complement, as it is the standard solution for representing signed integers. 2.1 Two's complement • Most significant bit has a negative value, all others are positive. So, the value of an n-digit -2 two's complement number can be written as: Σ2 2¹ di 2n-1 dn • Otherwise exactly the same as unsigned integers. i=0 - • A neat trick for flipping the sign of a two's complement number: flip all the bits (0 becomes 1, or 1 becomes 0) and then add 1 to the least significant bit. • Addition is exactly the same as with an unsigned number. 2.2 Exercises For questions 1-3, answer each one for the case of a two's complement number and an unsigned number, indicating if it cannot be answered with a specific representation. 1. (15 pts) What is the largest integer…