シ ≈ |تعرّف على المآدهـ シ ≈ | M359

**سحر القصيد** · 02:04 AM

M359
Relational databases: theory and practice

Credit points: 30
OU Level: 3

متطلبات المادة :

اجتياز M255 او MT262-B .

~

Summary:
تعرض هذه المادة وجهات النظر حول ما يسمى بقواعد البيانات العلائقية ومدى فعاليتها كهندسة لنظم قواعد البيانات . كما يذكر مقدمة حول نظم ادارة قواعد البيانات والتسهيلات التي تقدمها لتسهيل عملية تخزين واستيعاب عدد كبير من البيانات المشتركه في بيئة المستخدم .
ويتم سرد المواضيع التي تتعلق بنظرية قواعد البيانات العلائقية , كنمذجة البيانات وتطوير البنية لقواعد البيانات , من خلال دراسة التصميم والتحليل وايضا معرفة لغة الاستعلام SQL , و ذكر البرامج التي قد تتعامل مع نظم ادارة قواعد البيانات بالاضافة الى دور XML و JAVA .
التي تركز عليه هذه المادة باختصار , هو وضع قاعدة بيانات متكاملة تهدف الى توفر المتطلبات اللازمة لتلبية الاحتياجات المطلوبة .هذا يتم على مراحل مختلفة , وهو التحليل بجانب توقع الاحداث التي قد تحصل للعملية وتوفير وثيقة المتطلبات كم يتم دراسة ادوات تساعدك اكثر للتصميم و لعمل قاعدة بيانات قوية ومرنه ...

~

محتوى المادة :

المادة تحتوي على 5 بلوكات :

Block 1

Introduces the context of databases as part of an information system, which may be used by many people for different purposes and with different requirements. You will then examine the types of software that are necessary for accessing a database, and how each database has to be specially designed to satisfy the requirements of its users

~

Block 2
Introduces the mathematical theory underpinning relational technologies and shows ways that the theory is used in the database environment.

~

Block 3
Is concerned with relational database management systems, and, in particular, the use of the database language SQL, the recognised standard for defining and accessing a relational database.

~

Block 4
Is a detailed analysis of the steps involved in developing and implementing a database system. It examines, in depth, the tasks and techniques appropriate for each step in the development process and makes detailed comparisons between implementation alternatives and data representations.

~

Block 5
focuses on the on-going development and application of relational database technologies in the context of JAVA and XML.

~

~
كتب المادة :

Block 1
Databases in Context

The purpose of this block is to set the scene for, and give context to, the database theory and practice. The first three sections of the block place relational database theory and practice in historical context and highlights the importance of good data management practices to business, and consider aspects of database technologies. The final sections of the block introduce the foundations for the development process for relational databases taught in later blocks.

To study this block you will require access to Java applications supplied on the Course CD-ROM (order code M359/CDR01). You will also need the following database cards, Scenarios, University conceptual data model and Hospital conceptual data model (order code M359/DBCARDS).

Pages: 160

~

Block 2
Introducing Relational Theory

This block is concerned with the relational representation of data, that is, with representing data by relations (depicted as tables) and with representing the constraints on the data by the declarations and expressions of relational algebra. Relational representations often take the conceptual data model, discussed in Section 5 of Block 1, as a starting point and are themselves used as starting points for the implementation of relational databases.

You may find it useful to have the database cards (order code M359/DBCARDS) to hand as you study this block. In addition, you may also find the University and Hospital support files useful. These files can be found on the course CD-ROM (order code M359/CDR01)

Pages: 112

~

Block 3
The Database Language SQL

This block introduces SQL, the Structured Query Language - the standard language for data management tasks. First, it introduces you to SQL's facilities for retrieving data from a database using increasingly complex queries. Then it looks at how to use SQL to define and populate tables, define constraints on the data and modify the data held in the database. Finally, it looks at some programming structures that can be used to embed SQL in application processes.

Please note that although this block is intended to be self contained, you will find many of the concepts easier to understand if you have a good knowledge of the relational theory of Block 2. Also the practical skills that are developed in this block are used in Blocks 4 and 5. This is a very practical block and requires the use of the Interactive SQL interface to the Sybase DBMS that is supplied on the Software CD (order code M359/CDR01) and database cards University data summary and Hospital data summary (order code M359/DBCARDS).

Pages: 224

~

Block 4
Relational Databases:Theory and Practice

This block is concerned with the database lifecycle, which describes the stages a database goes through, from the time the need for a database is established until it is withdrawn from use. This block applies the practice developed in Block 3 to systematically develop, implement and maintain a database design that supports the information requirements of an enterprise. It presents a simple framework for database development and maintenance.

Pages: 320

~

Block 5
Further Database Features

This block is concerned with *** separate topics that relate to further features of databases that extend the view already presented.
One topic is about XML and databases, which examines what is special about XML and why it needs special treatment by database management systems.
The other topic is about application development, which examines what is involved when an application program requires access to a database.
The topic 'XML and databases' includes some practical activities at the end of section 2, which requires use of a web browser, and at the end of section 3, which also requires the course database software, SQL Anywhere, available on the course software (M359/CDR01).

Pages: 96

~

Database Cards Pack

The database cards are a set of laminated reference cards, each giving an outline of one or more aspects of the model databases used within the blocks. The main examples used are based on a fictional hospital and a fictional university. The cards show the full model for each example.

The titles of the database cards are;

M359 Scenarios
M359 Hospital conceptual model
M359 Hospital data summary
M359 University conceptual model
M359 University data summary
M359 Relational headings summary

Pages: 6

~

Software CD-ROM

This CD-ROM contains detailed text, database software, model databases and electronic resources needed to complete the computer activities referred to in Blocks 1, 3, 4 and 5. You will be required to install the software, the related example databases onto the hard drive of your computer. This installation process is described in the Software Guide included.

برامج قد تحتاجهـــا :

Adobe Reader

Java Downloads for All Operating Systems

WinRar

Macromedia Flash Player

|~كل الشكر وأطيب الدعوآت لـ زميلي من فرع الكويت"المبدع":azeez912 ،صآحب الفضل في توجيهي وإرشآدي لـ جمع هذه المعلومات،جعلها الله في موآزين حسنآته وجزآه عن الجميع خير الجزآء ~|

~تمنيآتنآ لكمـ بالتوفيقـ دوماً و أبداً ~

أختكمـ :

سحر القصيد