عندي بحث وابي حد يساعدني فيه

[الورد1]

مساء الورد
بدش في الموضوع بسرعه واللي يطالع فاهم الموضوع يراسلني او ع ايميلي الخاص




عندي بحث وابي حد يساعدني فيه ولكم جزيل الشكر

Question : 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.