Reference no: EM132675974
Question 5
You are in charge of designing a Project Management database for a business organization.
The following entities are considered: Projects, Managers(managing the projects), Employees(working on the projects). Each project has its assigned manager, but managers and employees can be associated with several projects as needed. Propose a DB framework, without going into secondary details. How many tables you will need and how these tables will be related?
Question 6
Give an example of using each one the following datatypes: Short Text, Long Integer, Yes/No, Double.
Question 7
You are in charge of designing a DB for a social club, to record and manage member activities over a fixed time period (such as a year). Club management proposes the following DB structure: TABLE (MemberID, MemberInformation, Activity1, ActivitySchedule1, ActivityFees1, Activity2, ActivitySchedule2, ActivityFees2, Activity3, ActivitySchedule3, ActivityFees3, Activity4, ActivitySchedule4, ActivityFees4, TotalFees) Do you see problems with such a design? Can you propose a better design?
Question 8
Consider the following DB framework outline that links pilots to airplanes that they can be assigned to, depending on the actual needs of an airline company. (Needs are dictated by the routes served, the schedule to follow, the number of passengers for a route and scheduled flight, etc.). PILOT (EmployeeID, EmployeeInformation,...., PlaneID) PlaneID foreign key to PLANE PLANE (PlaneID, PlaneInformation, ....)
Is this DB framework correct? Explain.
|
New auditing roles in oracle
: Discussing the reasons for the two new auditing roles in Oracle 12c. Why did Oracle consider them necessary? What problems do they solve?
|
|
Operating expenses change commiserate with inflation
: Duncan Industries, a U.S. based firm, produces manufactured goods in Morocco to sell in the United States. On January 1, 2019, the exchange rate
|
|
New social networking application
: Verbania has requested some functionality for its new social networking application.
|
|
Measure of past value creation in a world
: How useful is a measure of past value creation in a world where the value of any ?rm has more to do with the future than the past?
|
|
Project management database for business organization
: You are in charge of designing a Project Management database for a business organization.
|
|
Think about scenario of starting your own business
: Think about the scenario of starting your own business. What business would your start-up be?
|
|
Focus on issues and concerns with patch management
: This research paper will focus on issues and concerns with Patch Management. With the advent of many types of software and systems,
|
|
Construct the variance covariance matrix
: A portfolio is formed as follows: Sell short $2,000 of security 1 and buy $3,000 of security 2, $2,000 of security 3, and $3,000 of security 4.
|
|
Create an entity-relationship diagram
: Create an ERD (entity-relationship diagram), which provides some quick information on the data that's provided in the database.
|