Want this question answered?
the ---- of a database presents the views that the end user have
Data definition language (DDL) component enables database administrators (DBAs) to define the schema components, including tables, indexes, views, and constraints within a database. With DDL, users can create, modify, and delete the structure of the database to ensure data integrity and organization.
Used to view colums and rows
Views can be created in a database using the CREATE VIEW key wordEx:CREATE VIEW view_name ASSELECT column_name(s)FROM table_nameWHERE conditions
A Database has three views. The External Schema: What the end user sees. The Internal Schema: What the programmers of the program see. The Conceptual Schema: The basic plan of the database. Most of the time this is in paper form as a Conceptual Schema Diagram (CSD)
In a database management system, data can be viewed in three main ways: Conceptual view: Represents the overall framework or structure of the entire database. External view: Shows a subset of the database and is tailored to meet individual user requirements. Physical view: Describes how data is stored on the physical storage media.
In a database management system, you can use two different views to create a table by performing a union operation on the two views. This will combine the results of the two views into a single virtual table, allowing you to access the data from both views in one unified table.
A database View is a query which shows a portion of data in the database. It can be thought of as a virtual table. An example of a view would be one in which all attributes of an employee are returned as the result without salary details. Views are often used to provide "filtered" views of a database. A view can also hide the complexity of getting the correct data when a query is sent.
The schema (pronounced skee-ma) of a database system is its structure described in a formal language supported by the database management system (DBMS). In a relational database, the schema defines the tables, the fields, relationships, views, indexes, packages, procedures, functions, queues, triggers, types, sequences, materialized views, synonyms, database links, directories, Java, XML schema's and other elements.Schema's are generally stored in a data dictionary. Although a schema is defined in text database language, the term is often used to refer to a graphical depiction of the database structure.Hope this helps!Inclus - We provide indivdual and coporate trainingsEducate, Learn & Servewww.Inclus.net
A table is an object inside a database. A database has tables of data, views, indexes and programs. A database can have 10 or thousands of tables. More specifically, a table is a collection (rows) of data on a single related topic. For example, the Employees table would have employee data, each row being a different employee, but it would not have Inventory data. That would be in the Inventory table. A database is a collection of objects, primarily tables, but also indexes to help search the tables, views that filter, select and combine the data in the tables, and stored procedures (pre-defined programs that perform specific actions on the database).
the architecture of dbms contains three levels 1/ external level:different users views of the database,shows relevant data for a particular user. 2/conceptual level:global view pf the database;describes what data is stored and its relationships. 3/internal level:physical representation of the database on the computer, Describes how the data is stored in the database.
A repository is a collection of all data definition, data relationships and report formats, i,e; meta data of a database.