0
What else can I help you with?
What is the difference between design view from datasheet view?
A data sheet view shows the data in the database. It allows you to enter and edit the data, but you cannot change the format of the database. Design view allows you to create or change the table, form or any other database object.
Which view allows more control over table structures in context of database?
design view
Discuss the difference between a view and a base relation?
Views:1. This is one type of relation which is not a part of the physical database.2. It has no direct or physical relation with the database.3. Views can be used to provide security mechanism.4. Modification through a view (e.g. insert, update, delete) generally not permitted Base Relation:1. A base relation is a relation that is not a derived relation.2. While it can manipulate the conceptual or physical relations stored in the data.3. It does not provide security.4. Modification may be done with a base relation. by Joseph sailo
What is Schema and instances?
In DBMS,Schema is the overall Design of the Database.Instance is the information stored in the Database at a particular moment.In programming,you declare a variable which corresponds to "Schema".But its values changes as and when required which corresponds to "Instance". Google about levels of Database Abstraction. Physical Schema describes database design at physical level while a logical schema describes the database design at the logical level.A database may also have several schemas at the view level, sometimes called subschemas, that describe different views of the database.
What is schema instance?
In DBMS,Schema is the overall Design of the Database.Instance is the information stored in the Database at a particular moment.In programming,you declare a variable which corresponds to "Schema".But its values changes as and when required which corresponds to "Instance". Google about levels of Database Abstraction. Physical Schema describes database design at physical level while a logical schema describes the database design at the logical level.A database may also have several schemas at the view level, sometimes called subschemas, that describe different views of the database.
What is design view used for?
Its used when actually building or editing the operational, visual or structural content of the database being used/built
When you create a blank database the table that Access creates for you contains one field named .?
If you create it in Design View, no field name is given. If you create it in Datasheet View it is called Field1.
What does potential bias mean?
understanding a biographer's perspective or point of view in relation to his her subject.
Difference between logical database and physical database?
A logical database refers to the conceptual schema or model of data relationships and structures, independent of how data is stored or accessed. On the other hand, a physical database involves the actual implementation of the database on a specific hardware system, detailing how data is stored and accessed. The logical database design focuses on the organization of data, while the physical database design focuses on optimizing performance and storage efficiency.
You can only delete a primary key in what veiw?
You can only delete a primary key in the Database Designer view in applications like Microsoft Access or SQL Server Management Studio. This is where you can modify the structure of your database tables, including adding, modifying, or removing primary keys.
To view a table in Design view?
in the Views group, click the Views arrow and click Design view
discus the main approaches for managing the design of database system that has mutliple user view?
For a large multiuser database you'll need to make it robust and fast. If it has a high I/O then a good hard drive array or SSD is best.
