Question 1 0 out of 4 points | | | The portion of the database that a user is authorized to see is called aAnswer | | | | | Selected Answer: | table | Correct Answer: | view | | | | | Question 2 4 out of 4 points | | | The person who designs, creates, and manages the database is theAnswer | | | | | Selected Answer: | DBA | Correct Answer: | DBA | | | | | Question 3 0 out of 4 points | | | Data consistency meansAnswer
Words: 780 - Pages: 4
Assignment 2: Logical Design, Part 1 Due Week 2 and worth 50 points You have been hired by ACME Global Consulting to procure requirements for a large database. In developing database management systems, E-R models are used to graphically depict complex relationships between entities. In this assignment, you are to convince a set of clients of the benefits of using an E-R model in developing a database. Write a two to three (2-3) page paper in which you: 1. List the advantages of a relational model
Words: 449 - Pages: 2
Week 3 1) Index- A file that relates key values to records that contain those key values. 2) Systables- The portion of the system catalog that contains table information. 3) primary key- A minimal collection of columns in a table on which all columns are functionally dependent and that is chosen as the main direct- access vehicle to individual rows. 4) foreign key- An column or collection of columns in a table whose value is required either to match the value of a primary key in a table or
Words: 349 - Pages: 2
INTRANET DEVELOPMENT Internal Communication Platform An intranet provides a secure centralised resource for key business information and procedures, and is a common platform for internal communication which can bind together many processes and data in the dealership or group. The Intranet used in our dealershipcomes with a number of modules that highly customisable, allowing it to be be adjusted and expanded so that it exactly fits the company's needs. Intranet modules include: * HR Documentation
Words: 2009 - Pages: 9
THE DATABASE APPROACH Using databases eliminates many problems that arose from previous methods of storing and accessing data. Databases are arranged so that one set of software programs - Database Management System – provides all users with access to all the data. This system minimizes the following problems: 1. Data Redundancy The same data are stored in many places. 2. Data Isolation Application cannot access data associated with other application. 3. Data Inconsistency
Words: 433 - Pages: 2
What is the most popular type of database? relational Using a file-oriented approach to data and information, data is maintained in many separate files. 3. File-oriented approaches create problems for organizations because of multiple master files which may contain redundant data. 4. Which statement is true regarding file systems? The proliferation of master files creates problems in the consistency of specific data stored in different files. 5. A set of interrelated,
Words: 3223 - Pages: 13
------------------------------------------------- 1. Explain the main difference between a file-oriented system and a database system. A file-oriented system utilizes data in a regular OS file based format where a database system uses a database engine that organizes data in a database in a table format utilizing rows for each record. 2. What is a DBMS? Briefly describe the components of a DBMS. DBMS stands for Database Management System. A DBMS is a collection of tools, features
Words: 1096 - Pages: 5
ACC 3300- Access Assignment Table: Customer, field name customer phone number. I placed a validation rule and a text rule where the area code of a customer’s telephone number can only contain 303 or 720. I did because I felt that the company was too small and did not have the resources to ship baskets outside Colorado. If the company should grow and expand and if revenue increases, the validation rule will no longer exist. Table: Custom Gift Basket Order/ Design, field name order date. One
Words: 356 - Pages: 2
Underlined attributes are the primary keys bolded attributes are foreign keys CUSTOMER (Cus_id, cus_last, cus_first, staddr, zipcode) EMPLOYEE (Emp_id, emp_first, emp_last, staddr, zipcode) VIDEO (Isbn, title, vid_length, rate_id, genre_type, release_date) GENRE (Genre_type, genre_description) ACTOR (Act_id, First, Last) ACT_IN (Isbn, Act_id) COPY1 (Cid,Isbn, Copy_no, rent_type) RENT_DURATION (Rent_No, rent_type, no_days, rent_charge) RENT_QUALITY (Rent_type, type_description) RATING
Words: 2278 - Pages: 10
Lab 9 Databases This lab applies to the following course objectives: * Create a database applying appropriate design and development techniques. Part 1: Using Database Management Systems 1. To access this lab log into CourseMate and open the NP2013 eBook 2. Click the > icon next to “Select Chapter” repeatedly until Chapter 11 appears in the orange heading 3. In the right panel window, Click the word “here” in the “Click here to open the eBook” 4. Click the ARROW icon
Words: 755 - Pages: 4
