3 View of Data(Cont) 3.2 Instances and schemas Similar to types and variables in programming languages Schema -the logical structure of the database e.g., the database consists of information about a set of customers and accounts and the relationship between them) Analogous to type information of a variable in a program Physical schema: database design at the physical level Logical schema: database design at the logical level Database System Concepts 1.9 @Silberschatz, Korth and SudarshanDatabase System Concepts 1.9 ©Silberschatz, Korth and Sudarshan 3 View of Data (Cont.) 3.2 Instances and Schemas Similar to types and variables in programming languages Schema – the logical structure of the database e.g., the database consists of information about a set of customers and accounts and the relationship between them) Analogous to type information of a variable in a program Physical schema: database design at the physical level Logical schema: database design at the logical level