![]() ![]() The individual members are Mickey Mouse, Minnie Mouse, Mighty Mouse, Door Mouse, Tom Mouse, King Rat, Man Mouse and Moose Mouse. Everyone with membership ID#100755 lives at 8932 Rodent Lane. In Figure 2.2, Minnie Mouse renewed the family membership with Science World. Memberships can be purchased for a one- or two-year period, and then renewed for another one- or two-year period. Members of Science World are individuals, group homes, businesses and corporations who have an active membership to Science World. For example, a membership system may contain an address table and an individual member table as shown in Figure 2.2. A combination of fields makes up a table. For example, each field in an employee table contains data about an individual employee.Ī database can contain many tables.A database is designed, built and populated with data for a specific purpose. ![]() A database is logical, coherent and internally consistent.It is a representation of some aspect of the real world or a collection of data elements (facts) representing real-world information.A database can be viewed as a repository of data that is defined once and then accessed by various users as shown in Figure 2.1. Q4.Adrienne Watt & Nelson Eng What Is a Database?Ī database is a shared collection of related data used to support the activities of a particular organization. Q3. What represents a ‘tuple’ in a relational database? Q2. In SQL, which command(s) is(are) used to change a table’s storage characteristics? ![]() Q1.In SQL, which of the following is not a data Manipulation Language Commands? Tables are organized into rows and columns, and each table must have a name. The CREATE TABLE statement is used to create a table in a database. Q2. Which of the following is not included in DML (Data Manipulation Language)Īnswer: CREATE. Data control is used for the controlling the access to the database. Q1. _commands in SQL allow controlling access to data within database.Īnswer: Data Control. Commands like COMMIT, ROLLBACK, SAVEPOINT and SET TRANSACTION are used.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |