Dbms Technology

السلام عليكم ورحمة الله وبركاته..


اتمنى منكم ما تحذفوا الموضوع لانه انحذف من قبل

انا محتاجة احد يساعدني في حلول هذه الاسئلة

ولازم اسلمه هالاربعاء

انتظر مساعدتكم
:

Question #1

Building a Relational Database for a Small Business Salim’s Bike shop, located in Seeb, sells road, mountain, hybrid, leisure, and children’s bicycles. Currently, Salim’s purchases bikes from three suppliers, plans to add new suppliers in the near future. This rapidly growing business needs a database system to manage this information. Initially, the database should house information about suppliers and products. The database will contain two tables a supplier table and a product table. The reorder level refers to the number of items in inventory that triggers a decision to order more items to prevent a stock-out. (In other words, if the number of units of a particular product in inventory falls below the reordered level, the item should be reordered.) The user should be able to perform several queries and produce several managerial reports based on the data contained in the two tables.


A. Analyze the above scenario and provide some suggestions to ensure storage effectively.

B. Manage the decision problem using database triggers.
C. What would you do to ensure database performance, when users will produce several managerial reports

D. How can you secure the above database? Provide a policy for Salim’s Bike shop database

Question #2:

A. Evaluate and analyze the management and organizational requirements of a database environment

B. How does a database management system help businesses improve the organization of their information? Explain
your answer with the help of examples.

Note: Read assignment guidelines, late policy and submission policies in the MIS and previous assignment paper.