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

The Horse table has the following columns: ID - integer, auto increment, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Delete the following rows: Horse with ID 5 All horses with breed Holsteiner or Paint All horses born before March 13, 2013 To confirm that the deletes are correct, add the SELECT * FROM HORSE; statement.

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

The Horse table has the following columns: ID - integer, auto increment, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Delete the following rows: Horse with ID 5 All horses with breed Holsteiner or Paint All horses born before March 13, 2013 To confirm that the deletes are correct, add the SELECT * FROM HORSE; statement.

Why is Linux popular? What would make someone choose a Linux OS over others? What makes a server? How is a server different from a workstation? What considerations do you have to keep in mind when choosing between physical, hybrid, or virtual server and what are the reasons to choose a virtual installation over the other options?

Objective you will: 1. Implement a Binary Search Tree (BST) from scratch, including the Big Five (Rule of Five) 2. Implement the TreeSort algorithm using a in-order traversal to store sorted elements in a vector. 3. Compare the performance of TreeSort with C++'s std::sort on large datasets. Part 1: Understanding TreeSort How TreeSort Works TreeSort is a comparison-based sorting algorithm that leverages a Binary Search Tree (BST): 1. Insert all elements into a BST (logically sorting them). 2. Traverse the BST in-order to extract elements in sorted order. 3. Store the sorted elements in a vector. Time Complexity Operation Average Case Worst Case (Unbalanced Tree)Insertion 0(1log n) 0 (n)Traversal (Pre-order) 0(n) 0 (n)Overall Complexity 0(n log n) 0(n^2) (degenerated tree) Note: To improve performance, you could use a…