What are three main steps associated with building the (ERD), list these three steps? The building blocks of the ERD are: Entities describe people, places, or things Attributes capture information about the entity Relationships associate data across entities
Explain how do you represent, 1-to-1 (1:1), and 1-to-many relationship (1:N) and many-to-many relationship (M:N) ?
One instance in an entity refers to one and only one instance in the related entity (1:1) One instance in an entity refers to one or more instances in the related entity (1:N) One or more instances in an entity refer to one or more instances in the related entity (M:N)
Discuss the major principles for User Interface Design?
Layout
Content awareness
Aesthetics
User experience
Consistency
Minimize user effort
مع شرح كل نقطه باسلوبك
ذا يلي حليت لحد اللحين
(كلها بالسلايد )
List the three design strategies, and give at least 2 advantages and 2 disadvantages of each.
1. Custom development in-house. When the system to be designed is unique, or when confidentiality and secrecy is very important, and when the organization needs full control and ownership over the system.
Advantages: A. Allow flexibility. B. Builds in-house technical skills and knowledge. C. Have control over the system.
Disadvantages: A. Often more cost and more time and risk of failure. B. May not have in-house technical skills and knowledge. C. May delay backlogs of other important systems that need to be built.
2. Purchase a Packaged Software. When the system to be designed is very common and there exist many good software packages that provide a good solution that can be customized. These software packages have been tested and proven and comply with industry standards and requirements.
Advantages: A. Cost and time saving. B. Tested, and proven and comply with industry standards and requirements.
Disadvantages: A. Packaged System needs integration with existing company systems. B. Often does not fit perfectly with business needs and may require some customization. C. May require workaround.
3. Outsource development to third party. Hiring an external vendor, a developer, or service provider to build the system. It is very important to manage the relationship with the vendor and have a contract and service agreement.
Advantages: A. The vendor will have the specialized and customized solution. B. Cost and Time will be less than in-house development.
Disadvantages: A. Losing confidential or secret information. B. Losing the opportunity to develop in-house technical skills and knowledge. C. Losing control over the system.
Suppose that your uncle is a real estate agent and he decided to have a web-site to list his available real estate properties. And use a laptop computer to show clients these properties. What hardware is needed to have a web-site and client to browse the properties on that web-site? How many (n-tired) computers are needed for this system? List at least one advantage for this new system?
اش المطلوب من هذا السوال بالتحديد
Suppose that your uncle is a real estate agent and he decided to have a web-site to list his available real estate properties. And use a laptop computer to show clients these properties. What hardware is needed to have a web-site and client to browse the properties on that web-site? How many (n-tired) computers are needed for this system? List at least one advantage for this new system?
اش المطلوب من هذا السوال بالتحديد
لو كان عمك وكيل عقارات وبيسوي موقع ع الانترنت عشان يعرض فيه العقارات المتاحه ع جهاز كمبيوتر ايش رح تختار جهاز هل البيسد سيرفر او كلاينت او سيرفر كلاينت وكمان هل رح يكون تو تيرد او اكثر اللي هيا الطبقات واذكر اقل شي فائدة وحده لنوع الجهاز اللي اخترته (client server- server-client )
لو كان عمك وكيل عقارات وبيسوي موقع ع الانترنت عشان يعرض فيه العقارات المتاحه ع جهاز كمبيوتر ايش رح تختار جهاز هل البيسد سيرفر او كلاينت او سيرفر كلاينت وكمان هل رح يكون تو تيرد او اكثر اللي هيا الطبقات واذكر اقل شي فائدة وحده لنوع الجهاز اللي اخترته (client server- server-client )
Case Study: describe using ERD diagram how the university can manage Building, Classroom, Course, students, and Instructors, each of which is a table that is drawn indicating Primary Key, and Foreign key. Then explains how the university can add a new course without conflicting with others courses’ time and classroom.
Notice: the relation between Course and Student is m-to-m because a Student may have more than one Course has more than one student.
Draw the ED-D using crows-feet notation. Show the entities and relationships between entities (Building, Classroom, Course, student, Instructor). Indicate the PK primary key, and FK foreign key in each table)
من يعرف ايش المطلوب من هالسوال هل اسم يوز كيس نفس اللي قبل الميد تيرم اخذناه؟؟
Case Study: describe using ERD diagram how the university can manage Building, Classroom, Course, students, and Instructors, each of which is a table that is drawn indicating Primary Key, and Foreign key. Then explains how the university can add a new course without conflicting with others courses’ time and classroom.
Notice: the relation between Course and Student is m-to-m because a Student may have more than one Course has more than one student.
Draw the ED-D using crows-feet notation. Show the entities and relationships between entities (Building, Classroom, Course, student, Instructor). Indicate the PK primary key, and FK foreign key in each table)
من يعرف ايش المطلوب من هالسوال هل اسم يوز كيس نفس اللي قبل الميد تيرم اخذناه؟؟
هذا السؤال من الشابتر السادس ماله علاقه باليوزكيس.
تاخذي كل من entities وتعمليلها attributes وتحددي البرايمري كي لكل إنتيتي
مثلاً عندنا entity اللي هي student
attribute تبعها راح تكون (student_ID , student_Name)
البرايمري كي PK هو Student_ID اخترناه لانو يميز الانتيتي, لكن اسم الطالب ممكن يكون فيه طالبين لهم نفس الاسم لكن id مايتكرر.
وتسوي نفس الشي مع بقية الentities. مثلا كمان المبنى تكون الاتربيوت تبعه اسم المبنى, رقمه
الكلاس روم اسمها وبأيت مبنى وكم تستوعب وكذا مع الكل وتحددي البرايمري كي.
الرسمه راح تسوي جدول لكل entities وتكتبي فيه الاتروبيت وتربطي الجداول بالفورين كي.
الفورين كي يكون برايمري كي في واحد من الجداول ويكون نفسه اتربيوت في جدول تاني.
Assignment 3
العرض العادي
