Database Management System and Decision Support

This assignment delves into Database Management Systems (DBMS) by outlining a project that utilizes Microsoft Access. Students will explore concepts like decision support systems (DSS), calculating markups for products, selecting appropriate freight types, and identifying suitable countries for importing goods. The assignment emphasizes practical application of DBMS principles in a business context.

Database Management System
Introduction

Database is a collection of linked data and data could collection of facts and
stats that can be processed to produce details. Mostly data represents
recordable facts. Data aids in developing information, which is based on
information. For example, if we have details about marks obtained simply by
all learning students, we are able to conclude about toppers in addition
average marks then. The database management system stores info in such a
real way it becomes easier to retrieve, alter, and produce information.
With this project we can use MICROSOFT Access. Some important
advantages of using MS Access are usually as follows:
Sample Databases
MS Access includes samples databases applications for users. These kinds of
applications help the users to comprehend about real-world tables, queries,
forms and reports.
Wizards
MS Access offers many wizards to create a data source easily. The user can
choose the required example from several types of database using the
wizard.
Keys to understand the structure
MS Access allows a person view all relationships inside the database
graphically. The Relationship Home windows is used to display these
databases relationships. It makes the process of indicating relationships
easier and quicker.
Microsoft Office integration
The specific databases created in MICROSOF COMPANY Access can exchange
info with Microsoft Office programs easily. For example, the data kept in
Access database can be exported to MS Excel
Easier Programming
MS Access provides the facility of easier growth. The user can use relatively
simple system code with macros to deal with the repeated tasks. MS Access
provides visible shortcuts and hints which will help the user to write program
code easily.
No Redundancy
MS Convenience allows the user to store, get, sort, print and evaluate
information stored in the data bank. Data might be manipulated without
having redundancy by defining organizations between sets of info.

Decision Support System
Decision Support System (DSS) are a specific class of computerized
information system that supports business and organizational decision-
making actions. A properly-designed DSS is definitely an interactive
software-based system made to help decision makers put together useful
information from organic data, documents, personal information, and/or
business models to distinguish and solve problems Program. Drawing.
Bitmap decisions. DSS belong to a setting with multidisciplinary foundations,
including database research, artificial intelligence, engineering, simulation
methods, human computer interaction and software telecommunication.
Advantages of Decision Support System
(1)Time savings. For all categories of option support systems, research has
proven and substantiated reduced option cycle time, increased worker
productivity and more timely information for decision making.
(2) Enhance effectiveness. One more category of advantage that has been
generally discussed and examined is generally improved decision making
effectiveness plus better decisions.
(3) Enhance interpersonal communication. DSS might improve
communication and assistance among decision makers. Inside appropriate
circumstances, communications- driven and group DSS have observed this
impact.
(4) Aggressive advantage. Vendors cite this specific advantage for
business intelligence strategies frequently, performance management
techniques, and web-based DSS. Though it is possible to gain a competing
advantage from computerized decision assistance, this is not a likely
outcome.
(5) Cost decrease. Some researches and especially scenario studies have
documented DSS price saving from labor personal savings in making
decisions and through lower infrastructure or technologies costs. This is not a
goal of making DSS always.
(6) Improve decision maker satisfaction. The particular novelty of using
computer systems has and may continue to error analysis of this outcome.

DSS might reduce frustrations connected with decision makers, create
awareness that better information continues to be used and/or creates
awareness that the individual is a "better" decision maker.
Which Mark-up Type would be most appropriate for the business?
Why?
Supplier Mark-up Type is the most appropriate for the business enterprise.
There are many factors that enter into calculating the markup by yourself
product or service. Two of the most important are the costs of production
and the market demand for the product. After taking people factors into
account, look at your own industry. Is there a standard marketplace markup
What would be the effect on the business’s profit when the plan to
provide a discount to be able to large orders was applied? Why?
Profit planning, boosting your business profit, is the improvement your
operating plan for the particular coming period simply. Your own plan is
summarized by way of an income statement that is your sales and revenue
objective and your budget for price.
Which Recommended Freight Type would be most appropriate for
the corporation? Why?
The support from the greatest freight forwarders Otto Octavius Transport are
recommended for the enterprise should you be into offering items or moving
products from one area to another. The particular support provided by an
excellent shipping forwarder will be of significant help to you, regardless of
whether remove word your business is Otto Octavius Transport is just one of
your relocating locations.
Which country is going to be most appropriate for the business in
order to import from at the moment? The key reason why?
Australia is the most appropriate for the business enterprise to import from
within the brief moment. Because of within the same region.
Conclusion:
Database software systems are usually categorized based on the database model that they assistance,
such as the network, relational or even object model. The design tends to determine the issue languages

that are available to access the specific database. One commonly used issue language for the relational
data bank is SQL, although SQL syntax and function may differ from one DBMS to another. A lot of the
internal engineering of a DBMS is independent of the data style, and is concerned with managing
components such as performance, concurrency, truthfulness, and recovery from gear failures. In these
areas you can get large differences between products.
Reference:
[1] R. Abbott and H. Garcia-Molina. Scheduling real-time transactions: a
performance evaluation. ACM Transactions on Database Systems, 17(3),
1992.
[2] S. Abiteboul. Querying semi-structured data. In Intl. Conf. on Database
Theory, 1997
[3] Embley, B.W.: Object Database Development - Concepts and Principles,
Addison-Wesley, 1998.
[4] Dieter Gollmann All: Lecture Notes in Computer Science Vol. 875 (pp.
359-374), Springer Verlag, 1994.
[5] Hansen, J.: Atomare Datatyper (in Danish), Master's. thesis, Department
of Computer Science, Aarhus University, Denmark, Dec. 1996.
[6] Kim, V. (Ed.): Modern Database Systems. The Object Model,
Interoperability, and Beyond, Addison-Wesley, 1995.
[7] Stonebraker, M., Moore, D.: Object-Relational DBMSs: The Next Great
wave, Morgan Kaufmann Publishers, Inc., 1996.
[8] Tansel, J, Clifford, J., Gadia, S., Jajodia, S., Segev, A., Snodgrass, R.:
Temporal Databases - Theory, Design, and Implementation, Database
Systems and Application Series, Benjamin/Cummings, 1993