'Create table book' diaporamas de présentation

Relational Databases

698 views • 55 slides

DT211 Stage 2

DT211 Stage 2. Databases Lab 1. Get to know SQL Server. SQL server has 2 parts: A client, running on your machine, in the lab. You access the database from here, using SQL. You can store your SQL files locally or on your home drive. A server, running on a remote machine.

270 views • 18 slides

Database Design SQL (1)

Database Design SQL (1). John Wordsworth Department of Computer Science The University of Reading J.B.Wordsworth@rdg.ac.uk Room 129, Ext 6544. Lecture objectives. Outline the history of SQL. Distinguish data definition, data manipulation, and data control languages.

175 views • 17 slides

Study group exercises In attendance:

Study group exercises In attendance:. 1. Suppose you have a relation P ( A, B, C, D, E, F ), with functional dependencies ( FDs ) A ? B , BCD ? E , E ? F Suppose there are at most 2 different possible values for each of attributes A, C, and D.

263 views • 8 slides