Database Systems

More about the book

This best-selling text introduces database theory in a concise yet comprehensive manner, offering a design methodology suitable for both technical and non-technical readers. It presents a step-by-step approach for relational Database Management Systems, illustrated with a realistic example across three phases: conceptual, logical, and physical database design. Key topics include the database environment, architectures, and the relational model, along with languages such as SQL for data manipulation and definition. The book covers database analysis and design, detailing the system lifecycle, case studies, entity relationship modeling, normalization, and advanced normalization techniques. It also outlines methodologies for conceptual, logical, and physical database design, as well as monitoring and tuning operational systems. Selected issues such as security, administration, legal and ethical considerations, transaction management, and query processing are discussed. Additionally, it explores distributed DBMS concepts, object-oriented DBMS design, and the integration of web technologies with databases. Business intelligence technologies, including data warehousing and data mining, are addressed, along with appendices featuring user requirements, alternative data modeling notations, and summaries of the design methodology. This resource is ideal for those interested in database management and design.