من فضلكم انااريدمساعدة في حل avechicle rental company wishes to create adatabase to monitor the renting of vechicles to clients .each vehicle has an id ,make and model the company has various branches and each branch has staff including a manager and several senior mechanics who are responsible for supervising the work of allocated groups of mechanics. a branch has an address consisting of :country,city and street .each branch has astock of vehicles for rent that may be rented by clients for various periods of time ,from a minimum of four hours to maximum of six months.each rental agreement between a client and the company is uniquely identified using a rental number .a client must take out insurance cover for each vechicle rental period. each avechicle is checked for faults after each rental process.each client has a name ,ssn,address ,and more than one a telephone. i need to draw in er or eer diagram and uml and logical schema and data base normalization then write ddl statment in sql-99

0

أخي الكريم

بعد قرائتي لموضوعك فهو لا ينتمي لقواعد البيانات بصلة ولكن الأنسب له كما تطلب تصميم قاعدة بيانات مستخدما ُEntity Relationship Diagram

يرجي العلم بأن الموضوع سيتم نقله لمنتدي تصميم قواعد البيانات

نأمل أن يتم فهمكم الجيد للحل بعد مساعدة الاخوة بالقسم المعني

تحياتي
أحمد