Question

In: Computer Science

Part 1: Terminology In your own words, define/describe what each of these terms means in a...

Part 1: Terminology
In your own words, define/describe what each of these terms means in a database context. Do not attempt to copy specific sentences from the video word for word. Examples to support definitions and descriptions are welcome, but are insufficient on their own. You should establish that you understand the significance of each term.
1. Database Functionality:

a. Massive

b. Persistent

c. Safe

d. Multi-user

e. Convenient

f. Efficient

g. Reliable

  
2. database concepts:

a. data model


b. schema vs. data

3. purpose of languages associated with a database:

a. data definition language


b. data manipulation language


c. query language

4. database-related jobs:

a. DBMS implementer


b. designer


c. application developer


d. database administrator

Solutions

Expert Solution

Answer:

1) Database Functionality:

a) Massive -is a term that describes the large volume of data

b) Persistent- The opposite of dynamic—it doesn't change and is not accessed very frequently.Data that exist from one instance to another stored in actual format and stays there

c) Safe: - Ensure physical database security

d) Multi-User -  database are accessible from multiple computers simultaneously

e) Convenient - means easy to process or access the database

f) Efficient- performing or functioning in the best possible manner with the least waste of time and effort

g) Reliable-the database performs consistently without causing problems

2) Database Concept:

a) Data model: Data models define how the logical structure of a database is modeled. Data Models are fundamental entities to introduce abstraction in a DBMS. Data models define how data is connected to each other and how they are processed and stored inside the system.

b) Schema vs Data : A database schema is the skeleton structure that represents the logical view of the entire database. It defines how the data is organized and how the relations among them are associated. It formulates all the constraints that are to be applied on the data.

3) Purpose of languages associated with database:

a) Data Definition Language:A data definition language (DDL) is a computer language used to create and modify the structure of database objects in a database. These database objects include views, schemas, tables, indexes, etc. DDL commands are used for altering the database structure such as creating new tables or objects along with all their attributes (data type, table name, etc.).

b) Data Manipulation Language:A  data manipulation language (DML) is a family of computer languages including commands permitting users to manipulate data in a database. This manipulation involves inserting data into database tables, retrieving existing data, deleting data from existing tables and modifying existing data. DML is mostly incorporated in SQL databases.

c)Query Language: Query Language (QL) refers to any computer programming language that requests and retrieves data from database and information systems by sending queries. It works on user entered structured and formal programming command based queries to find and extract data from host databases.

4) Database related jobs

a) DBMS Implementer: A DBMS Implementer isnstall the DBMS.Tune the setup variables according to the hardware, software and usage conditions.Create the database and tables.Load the data.Set up the users and security and implement the backup regime.

b) Designer :The database designer isresponsible for defining the detailed database design, including tables, indexes, views, constraints, triggers, stored procedures, and other database -specific constructs needed to store, retrieve, and delete persistent objects

c) Application developer:An Application developer responsible for developing and modifying source code for software application .

d) Database administrator:The database administrator (DBA) is the person who manages, backs up and ensures the availability of the data produced and consumed by today's organizations via their IT systems


Related Solutions

In your own words, define the following terms and describe their differences. In addition, classify each...
In your own words, define the following terms and describe their differences. In addition, classify each account as A, L, SE, R, or E and state which financial statement(s) each account affects. (a) Interest revenue, interest receivable, interest payable, cash interest paid, and cash interest received. To whom does your company pay interest? From whom does your company receive interest? Note the different counterparties. (b) Rent expense, prepaid rent expense, rent payable, and cash paid for rent. (c) Supplies expense,...
1. Define each of the following terms in your own words: Target costing, value chain, and...
1. Define each of the following terms in your own words: Target costing, value chain, and Just-in-Time inventory system. 2. Explain the relationship among these terms and the relevance to them of accounting.
Define the following four terms in your own words, and describe how they relate to learning:...
Define the following four terms in your own words, and describe how they relate to learning: 1) Social Learning, 2) Self-efficacy, 3) Pygmalion Effect, and 4) Operant Conditioning. Minimun 100 words.
In your own words, define the following database terms and give an example of each: Table...
In your own words, define the following database terms and give an example of each: Table Record Field Primary Key Foreign Key
Step 1 Define terms. Explain the following terms in your own words in the discussion forum:...
Step 1 Define terms. Explain the following terms in your own words in the discussion forum: Positive correlation Negative correlation No correlation Step 2 Give real-world examples and post. Offer examples of the following: Two variables that you believe would share a positive correlation Two that you believe would be negatively correlated Two that would not be related at all
Question 1: In your own words define the terms and indicate whether they are a bond...
Question 1: In your own words define the terms and indicate whether they are a bond or interaction Term Definition Induced Dipole Ionic Hydrogen Bonding Polar Covalent Covalent Metallic Non-polar covalent Van der Waals Permanent Dipole Question 2: What is the ionic character of NaCl? What kind of bond is it and why?
Question 1: In your own words define the terms and indicate whether they are a bond...
Question 1: In your own words define the terms and indicate whether they are a bond or interaction Term Definition Induced Dipole Ionic Hydrogen Bonding Polar Covalent Covalent Metallic Non-polar covalent Van der Waals Permanent Dipole Question 2: What is the ionic character of NaCl? What kind of bond is it and why?
1) In your own words define “discretisation” and “degrees of freedom” in terms of the finite...
1) In your own words define “discretisation” and “degrees of freedom” in terms of the finite element method. a) Give the governing equation for a thermal analysis and briefly explain each term. Using this equation, describe the three basic modes of heat transfer and how they are included into an FE analysis. [Word limit: 200] b) What do the terms sensitivity, verification, and validation mean in regards to the accuracy of a finite element analysis and how are they utilised?
Define the following terms:(3 lines each) =>No Copy Paste.Websites to write in your own words. a....
Define the following terms:(3 lines each) =>No Copy Paste.Websites to write in your own words. a. Opportunity Cost b. Comparative Advantage c. Autarky d. Tariff e. Producer Surplus
1. Describe in your own words the structure of DNA. 2. Describe in your own words...
1. Describe in your own words the structure of DNA. 2. Describe in your own words how DNA makes copies of itself. (I.e. Describe DNA replication.). Protein synthesis involves two processes, transcription and translation. Describe in your own words how each process occurs. Transcription Translation
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT