Database Systems Design implementation and Managements(2) : database systems, database concepts, evolution of file system data processing, problems with file system data processing, data modelling and data models, degrees of data abstraction, design concepts, relational set operators, relationships within the relational database, entity relationship modeling, database design challenges, advance data modeling, extended entity relationship model, selecting primary keys, learning flexible database design, database tables and normalization, surrogate key considerations, data modeling checklist, advanced design and implementation, introduction to structured query language, data definition commands, data manipulation commands, select queries, additional data definition commands, relational set operators, sql join operators, subqueries and correlated queries, sql functions, oracle sequences, procedural sql, embedded sql, the systems development life cycle, the database life cycle, conceptual design, dbms software selection, advanced database concepts, concurrency control with time stamping methods, database performance tuning and query optimization, databases and the internet, data administration.