2. There are mainly three main roles in the system conversion process: sponsor, change agent, and adopters. Please answer which role is often invited from outside the changing business units. A. Sponsor B. change agent C. adopters D. all of the above 3. Suppose there is a datafile table storing the information regarding the students in CSUEB, including the name, netID, birthday, address, phone number. There records will be stored for a long period, even after the students' graduation. What is the data type? a. master files b. look-up files c. transaction files d. audit files

2. There are mainly three main roles in the system conversion process: sponsor, change agent, and adopters. Please answer which role is often invited from outside the changing business units. A. Sponsor B. change agent C. adopters D. all of the above 3. Suppose there is a datafile table storing the information regarding the students in CSUEB, including the name, netID, birthday, address, phone number. There records will be stored for a long period, even after the students' graduation. What is the data type? a. master files b. look-up files c. transaction files d. audit files

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 3TD

See similar textbooks

Similar questions

Why do we need to have a point of view in the first place? What do you mean when you say that you have a point of view? There are times when information that has been defined as part of a View Definition does not really show up as a View Description. A view allows users to insert data into a database without having to create a table or row from scratch.
1. Determine the functional dependencies that exist in the following table and then convert this table to an equivalent collection of tables that are in third normal form. OFFICE (OFFICE NUM, OFFICE NAME, (ADDRESS, SQR_FT, BDRMS, FLOORS, MONTHLY RENT, OWNER_NUM)) 2. Determine the functional dependencies that exist in the following table and then convert this table to an equivalent collection of tables that are in third normal form. PROPERTY (PROPERTY ID, OFFICE NUM, ADDRESS, SQR_FT, BDRMS, FLOORS, MONTHLY RENT, OWNER NUM, LAST NAME, FIRST NAME)
The French Bakery is a new business project, the owner of the bakery needs a database to keep the essential data and transactions regarding his business. The following requirements of the bakery have been collected: There are different departments in the bakery business, each department has a name, department number, the number of employees, and manager. The database will keep the start date and the end date for each manager. The bakery needs to keep Employee’s name, ID number, Phone number, address, sex, position, and the salary. Each employee work for a specific department. Each employee has a supervisor. Some employees have more than one position. To keep contact with customers and provide customer services and marketing, the bakery requires customer’s name, address, Cnumber (which is unique for each customer), email, and the phone number. The bakery sells many products, each product has a name and a price, and the calories’ amount. The manager will be responsible of products. Also,…
The French Bakery is a new business project, the owner of the bakery needs a database to keep the essential data and transactions regarding his business. The following requirements of the bakery have been collected: There are different departments in the bakery business, each department has a name, department number, the number of employees, and manager. The database will keep the start date and the end date for each manager. The bakery needs to keep Employee’s name, ID number, Phone number, address, sex, position, and the salary. Each employee work for a specific department. Each employee has a supervisor. Some employees have more than one position. To keep contact with customers and provide customer services and marketing, the bakery requires customer’s name, address, Cnumber (which is unique for each customer), email, and the phone number. The bakery sells many products, each product has a name and a price, and the calories’ amount. The manager will be responsible of…
The French Bakery is a new business project, the owner of the bakery needs a database to keep the essential data and transactions regarding his business. The following requirements of the bakery have been collected: There are different departments in the bakery business, each department has a name, department number, the number of employees, and manager. The database will keep the start date and the end date for each manager. The bakery needs to keep Employee’s name, ID number, Phone number, address, sex, position, and the salary. Each employee work for a specific department. Each employee has a supervisor. Some employees have more than one position. To keep contact with customers and provide customer services and marketing, the bakery requires customer’s name, address, Cnumber (which is unique for each customer), email, and the phone number. The bakery sells many products, each product has a name and a price, and the calories’ amount. The manager will be responsible of…
Direct connections between external entities and the database are not permitted under any circumstances. It should be kept in mind as one of the data flow diagram design concepts to consider. What do you think the repercussions of this suggestion will be?
Problem Statement: You are the CTO of a startup based out of Arlington, VA that needs to setup a database to keep track of the details of the customers: last name, first name, customer ID, street address, customer star rating (a rating on a 1– 5 scale, with 5 being best, representing the type of customer) and phone number. It also needs to keep track ofsimilar information for suppliers as well (although instead of supplier first and last name, there will just be a suppliercompany name). The database should maintain the data on products that are offered. Information about whichproduct is offered by which supplier should also be maintained. Finally, which customers have purchased whichproducts should also be tracked (note that we are only interested in which customers bought which product, but notconcerned about the date or how many were bought). 1.1 Business Rules: Assumptions for the business model are as follows:•Only customers that have purchased one or more products will exist in…
You have been hired as a Database Developer and you have been given the option to use a trigger and a procedure. Discuss what triggers are and when it would be best to use them?
You are to design a Hospital database. So before creating the database, your task is to draw the ER diagram based on the following data collected and analyzed: A hospital will have a name, unique id, multiple helpline numbers (one for doctor's appointment, one for ambulance, one for bill information and one for other services' info) and locations. A hospital may have more than one location as it may have different branches and each of the locations will have a building no., street address, road no. and city name. A patient will have a name, unique ID, may have more than one phone number, age, height, weight and symptoms. A patient takes an appointment in a hospital and the appointment date is recorded. A patient may have an attendant. An attendant will have his/her name, contact numbers and relationship with the patient as a record in the database. Due to the covid situation, the hospital authorities will only allow 1 attendant with 1 patient.
StayWell also rents out properties on a weekly basis to students attending summer school in the Seattle area. Design a database to meet the following requirements, using the shorthand representation and a diagram of your choice. For each student renter, list his or her number, first name, middle initial, last name, address, city, state, postal code, telephone number, and e-mail address. For each property, list the office number, property address, city, state, postal code, square footage, number of bedrooms, number of floors, maximum number of persons that can sleep in the unit, and the base weekly rate. For each rental agreement, list the renter number, first name, middle initial, last name, address, city, state, postal code, telephone number, start date of the rental, end date of the rental, and the weekly rental amount. The rental period is one or more weeks.
Create a class diagram for the Sports Physical Therapy database, as shown in Figures 1-21 through 1-24 in Chapter 1. If you need to make any assumptions when preparing the diagram, document those assumptions.
Indicate the changes (using the shorthand representation) that you would need to make to the original TAL Distributors database design to support the following requirements. There is no relationship between customers and sales reps. When a customer places an order, any sales rep can process the order. On the order, you need to identify both the customer placing the order and the sales rep responsible for the order. Draw an E-R diagram for the new design.