0
What else can I help you with?
Which type of the data model is being used presently?
There are three levels of data modeling. They are conceptual, logical, and physical."Conceptual" means a definition of the problem, "logical" means a design of a solution to the problem, and "physical" means the solution of the problem.
List six major steps that you would take in setting up a database for a particular?
1. Requirement Analysis 2. Conceptual Data Base Design 3. Logical Data Base Design 4. Schema Refinement 5. Physical Data Base Design 6. Security Design
What is the Difference between conceptual and technical design?
Conceptual Design• written in customer's language• explaining the observable external characteristics ofthe system• contains no technical jargon (If it does, define it.)• describes the functions of the system• is independent of implementation• is linked to the requirements documentsTechnical design• describes of major hardware components and theirfunctions• shows hierarchy (organization) and functions of thesoftware components• shows data structures and data flow• shows interfaces
What are the six phases of database design in computer science?
What are the six phases of database design? Discuss each phase.Database design phases are:1. Requirements collection and analysis.2. Conceptual design.3. Logical design (data model mapping).4. Physical design.
What makes the database effective?
The Conceptual Data Model
What are the Classification of data model?
Data models can be classified into three main categories: conceptual data model (high-level view of the data and its relationships), logical data model (detailed structure of the data and relationships), and physical data model (implementation of the database design on a specific database management system).
Compare the three level of ansi-sparc?
Conceptual database design is the process of constructing a model based on the enterprise. Logical database design is the process of constructing a specific data model. Physical database design is the process of producing of the database on the secondary storage.
What is global conceptual schema?
The enterprise view of the data is described by the global conceptual schema (GCS), which is global because it describes the logical structure of the data at all the sites.
Role of high-level data model in the database design process?
A high level data model serves the database designer by providing a conceptual framework in which to specify, in a systematic fashion, what the data requirements of the database users are, and how the database will be structured to fulfill these requirements.
Distinguish between logical data independence and physical data independence?
logical data : refer to the immunity of the external scheme towards changes in the conceptual scheme.physical data: refer to the immunity of the conceptual scheme towards changes in the internal scheme.
How are the internal external and conceptual schemas related to concept of logical and physical data independence?
The internal schema represents the physical storage structure of data, the external schema represents how different users view the data, and the conceptual schema defines the logical structure of the entire database. Logical data independence means that the conceptual schema can change without affecting the external schemas, while physical data independence means that changes in the physical storage structures do not affect the conceptual or external schemas.
Difference between schema sub schema and instance in DBMS in detail?
the overall logical data base description is referred to as a schema. it is sometimes also referred to as an overall modal of the data, a conceptual modal of the data, a conceptual schema
