Tài liệu miễn phí Cơ sở dữ liệu

Tin học văn phòng Đồ họa - Thiết kế - Flash Quản trị Web Cơ sở dữ liệu Quản trị mạng Kỹ thuật lập trình Hệ điều hành Phần cứng An ninh - Bảo mật Chứng chỉ quốc tế Thủ thuật máy tính Điện - Điện tử Kinh tế học Hoá học Xã hội học Môi trường

Tài liệu miễn phí Cơ sở dữ liệu

Download Tài liệu học tập miễn phí Cơ sở dữ liệu

Lecture Database management systems: Lesson 31

Lecture Database management systems: Lesson 31. The main topics covered in this chapter include: inner join, outer join, full outer join, semi join, self join, subqueries, wrap up DML, depends whether subquery returns single or multiple values, referential integrity constraint implemented,...

4/8/2023 3:40:02 AM +00:00

Lecture Database management systems: Lesson 30

Lecture Database management systems: Lesson 30. The main topics covered in this chapter include: order by example, display the students’ data in the ascending order of names, practice query, functions in SQL, categories of functions, aggregate functions, group by clause,...

4/8/2023 3:39:56 AM +00:00

Lecture Database management systems: Lesson 29

Lecture Database management systems: Lesson 29. The main topics covered in this chapter include: where format, inverses the predicate’s value, the between operator, checks the value in a range, checks in a list of values, order by clause, sorts the rows in a particular order,...

4/8/2023 3:39:50 AM +00:00

Lecture Database management systems: Lesson 28

Lecture Database management systems: Lesson 28. The main topics covered in this chapter include: operating systems, select statement, selecting rows from one or more tables, attribute alias, expression in select, select distinct, placing the checks on rows,...

4/8/2023 3:39:44 AM +00:00

Lecture Database management systems: Lesson 27

Lecture Database management systems: Lesson 27. The main topics covered in this chapter include: alter table statement, removing or changing attribute, removing rows and tables, data manipulation language, insert statement, truncate table class, alter table student,...

4/8/2023 3:39:37 AM +00:00

BG Database Management Systems - Lecture 26

Lecture Database management systems: Lesson 20. The main topics covered in this chapter include: data definition language, create command, create table command, format of create table, chevrons explained, create table with constraint,...

4/8/2023 3:39:31 AM +00:00

Lecture Database management systems: Lesson 25

Lecture Database management systems: Lesson 25. The main topics covered in this chapter include: rules of the format, writing general format, SQL commands types, data definition language (DDL), data manipulation language (DML), data control language (DCL),...

4/8/2023 3:39:25 AM +00:00

Lecture Database management systems: Lesson 24

Lecture Database management systems: Lesson 24. The main topics covered in this chapter include: vertical partitioning, data duplicated, clustering files, other related issues, summary of physical DB design, reduced training cost, application portability,...

4/8/2023 3:39:18 AM +00:00

Lecture Database management systems: Lesson 23

Lecture Database management systems: Lesson 23. The main topics covered in this chapter include: physical records and denormalization, denormalization situation, one to one relationship, many to many relationship, one to many relationships, denormalization leads to merging different relations,...

4/8/2023 3:39:12 AM +00:00

Lecture Database management systems: Lesson 22

Lecture Database management systems: Lesson 22. The main topics covered in this chapter include: data volume and usage analysis, composite usage map, designing fields, choosing data type, coding techniques, controlling data integrity,...

4/8/2023 3:39:06 AM +00:00

Lecture Database management systems: Lesson 21

Lecture Database management systems: Lesson 21. The main topics covered in this chapter include: normalization summary, normalization requirement, checking for BCNF, physical database design, transforms logical database design into technical specifications for storing and retrieving data,...

4/8/2023 3:38:59 AM +00:00

Lecture Database management systems: Lesson 20

Lecture Database management systems: Lesson 20. The main topics covered in this chapter include: second normal form, insertion anomaly, deletion anomaly, updation aomaly, third normal form, transitive dependency, boyce-codd normal form, higher normal forms,...

4/8/2023 3:38:53 AM +00:00

Lecture Database management systems: Lesson 19

Lecture Database management systems: Lesson 19. The main topics covered in this chapter include: functional dependency, inference rules, normal forms, first normal form, second normal form, full functional dependence, remember the treatment of multivalued attributes in the mapping process,...

4/8/2023 3:38:47 AM +00:00

Lecture Database management systems: Lesson 18

Lecture Database management systems: Lesson 18. The main topics covered in this chapter include: types of join, theta join, equijoin, natural join, left outer join, right outer join, outer join, semijoin,...

4/8/2023 3:38:40 AM +00:00

Lecture Database management systems: Lesson 17

Lecture Database management systems: Lesson 17. The main topics covered in this chapter include: five basic operators, unary operators, binary operators, selects tuples that satisfy a given predicate, Greek symbol sigma, process a selection, degree of the resulting relation,...

4/8/2023 3:38:34 AM +00:00

Lecture Database management systems: Lesson 16

Lecture Database management systems: Lesson 16. The main topics covered in this chapter include: mapping relationships, binary relationships, minimum cardinality, many to many relationship, binary one to one, unary relationships, super/subtype relationship, data manipulation languages,...

4/8/2023 3:38:27 AM +00:00

Lecture Database management systems: Lesson 15

Lecture Database management systems: Lesson 15. The main topics covered in this chapter include: database and math relations, degree and cardinality, relations keys, foreign key, integrity constraints, referential integrity constraint, significance of constraints, designing logical database,...

4/8/2023 3:38:21 AM +00:00

Lecture Database management systems: Lesson 14

Lecture Database management systems: Lesson 14. The main topics covered in this chapter include: logical database design, introduction to relational data model, strong mathematical foundation, relational data model, mathematical relations, database relations,...

4/8/2023 3:38:14 AM +00:00

Lecture Database management systems: Lesson 12

Lecture Database management systems: Lesson 12. The main topics covered in this chapter include: application of E-R data model, we study an example scenario and apply the design phases we have studied so far, data flow diagram and E-R database design, data flow diagram,...

4/8/2023 3:38:08 AM +00:00

Lecture Database management systems: Lesson 11

Lecture Database management systems: Lesson 11. The main topics covered in this chapter include: gen/spec relationship results inheritance between supertype and subtypes, super-sub type example, specifying constraints, subtype discriminator, disjoint discriminator, overlap discriminator,...

4/8/2023 3:38:01 AM +00:00

Lecture Database management systems: Lesson 10

Lecture Database management systems: Lesson 10. The main topics covered in this chapter include: minimum cardinality, other notations, roles in relationships, existence dependency, identifier dependency, referential dependency, EE-R data model

4/8/2023 3:37:54 AM +00:00

Lecture Database management systems: Lesson 9

Lecture Database management systems: Lesson 9. The main topics covered in this chapter include: relationships, naming relationships, symbol for relationships, relationships types, binary relationship, attributes of the relationships, ternary relationships, unary relationship,...

4/8/2023 3:37:45 AM +00:00

Lecture Database management systems: Lesson 8

Lecture Database management systems: Lesson 8. The main topics covered in this chapter include: key and its different types, relationships in E-R data model, types of relationships, key attributes, simple or composite key, primary key, secondary keys,...

4/8/2023 3:37:38 AM +00:00

Lecture Database management systems: Lesson 7

Lecture Database management systems: Lesson 7. The main topics covered in this chapter include: entity-relationship data model, entity type, types of entity types, weak entity types, strong entity type, naming entity types, regular entity type, types of attributes, symbols for attributes,...

4/8/2023 3:37:32 AM +00:00

Lecture Database management systems: Lesson 6

Lecture Database management systems: Lesson 6. The main topics covered in this chapter include: detailed diagrams, major sub-processes, data dictionary, cross reference matrix, database design phase, database design represents logical structure of the database, database modeling,...

4/8/2023 3:37:26 AM +00:00

Lecture Database management systems: Lesson 5

Lecture Database management systems: Lesson 5. The main topics covered in this chapter include: database application development process, database design, database development process, design stages, analyze existing system, data flow diagrams, preliminary study of system,...

4/8/2023 3:37:17 AM +00:00

Lecture Database management systems: Lesson 4

Lecture Database management systems: Lesson 4. The main topics covered in this chapter include: continue 3-L architecture, data independence, different aspect of DBMS, inter-schema mappings, external/conceptual mapping, logical data independence, physical data independence,...

4/8/2023 3:37:11 AM +00:00