يا شباب عملت تحليل لمشروع فيديو

ولكن اريد رأيكم فيه


ضرورري لانيي اريده في مشروع تخرج

http://www.4shared.com/file/21354104/72114a1b/bb_online.html

مجهود جبار .. ربنا يوفقك فى المشروع وجزاك الله عنا خير
أخوك
عبد الرحمن

اريد ان اعرف رأيكم

هل هذا التحليل شامل بمعنى انه هل يصلح عمل مشاريع اسنتادا على هذا التحليل

معنى في نفس النمط




ياشباب اريد رايكم واذا كان هناك اي نقص الرجاء توجيهي

Salam Al-Sofi,

I did not spend too much time analyzing your document but here are a few things, I spot as I was browsing the document.
1. It seems to me that your document has been copied from another report and you then changed some of its pieces to make it relevant to your project. For example, the screen diagram on page 2-8 is completely different from what your database design is describing. Where are the tables that capture the employee and application information?
2. In your database design diagram, you link the movie table with other tables using the movie id. However, you still duplicate the movie name, type and copy no columns to the other tables. You should not be doing that as the movie number is sufficient to retrieve any other movie information by linking both tables in your queries using the movie id.

3. I don't understand the purpose of both the subscription screen and table.
3.a Does your movie store provides an online subscription to movies so that customers can watch them from home? If that's the case, then you can have only one rent table and just add a rent type which tells whether this movie is physically rented or rented online.

3.b If the subscription is for renting a set number of movies for a monthly rate then you shouldn't be relating the subscription table to the movie table. You should have a third table that relates the customer, subscription and movie tables.

4. I don't see a data dictionary in your document. You should have a section that describes in words your tables, columns and the datatypes for each column and any other user information such as constraints, formats...etc.

I guess this is it for now. I hope you still have time to work on your project before you submit it and I wish you the best with your project.

Fee aman Allah,

Alaa Qasem

thank you brother Alaa Qasem for your notes and i am going to make changes

in the project and soon i will show you again with some improvment

i hope that you keep see my project and tell me my mistakes

الأخ / alsofi

اتفق مع رأى الأخ / علاء قاسم ....


ننتظر التحليل بعد التعديل

يا اخي اريد ان اسأل هل اضع data dictionary

في اي مكان في التحليل ام في مكان معين


وشكرا

Alsofi,

Usually, you put the data dictionary section after the database design, a.k.a ERD, diagrams. I will be waiting to see your changes.

Fee aman Allah,

Alaa Qasem

يا اخي لقد قمت بتعديل المشروع




وبالنسبه لتشابه الاعمدة عرفتها ولكن لم اقم بتعديلها واعتبرها انها معدلة


هذا هو الرابط

http://www.4shared.com/file/21539043/22a8beeb/_2__bb.html