-- phpMyAdmin SQL Dump -- version 4.9.1 -- https://www.phpmyadmin.net/ -- -- Host: 10.123.0.210:3307 -- Generation Time: Sep 09, 2020 at 06:55 PM -- Server version: 5.7.27 -- PHP Version: 7.0.33-0+deb9u9 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `micdim1_db2` -- -- -------------------------------------------------------- -- -- Table structure for table `conferenceRoom` -- CREATE TABLE `conferenceRoom` ( `roomID` int(11) NOT NULL, `capacity` int(11) DEFAULT NULL, `floorNum` int(11) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `conferenceRoom` -- INSERT INTO `conferenceRoom` (`roomID`, `capacity`, `floorNum`) VALUES (101, 20, 1), (102, 15, 1), (103, 15, 1), (104, 10, 1), (105, 10, 1), (201, 15, 2), (202, 15, 2), (203, 20, 2), (204, 10, 2), (205, 25, 2); -- -------------------------------------------------------- -- -- Table structure for table `reservation` -- CREATE TABLE `reservation` ( `reservationID` int(11) NOT NULL, `userID` int(11) DEFAULT NULL, `roomID` int(12) DEFAULT NULL, `reservationDate` date DEFAULT NULL, `resStart` datetime DEFAULT NULL, `resEnd` datetime DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `reservation` -- INSERT INTO `reservation` (`reservationID`, `userID`, `roomID`, `reservationDate`, `resStart`, `resEnd`) VALUES (1, 1002, 104, '2020-08-24', '2020-08-24 08:00:00', '2020-08-24 08:30:00'), (2, 1004, 101, '2020-08-25', '2020-08-25 09:20:00', '2020-08-25 13:40:00'), (3, 1004, 201, '2020-08-28', '2020-08-28 10:40:00', '2020-08-28 13:40:00'); -- -------------------------------------------------------- -- -- Table structure for table `user` -- CREATE TABLE `user` ( `userID` int(11) NOT NULL, `userName` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL, `pass` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `user` -- INSERT INTO `user` (`userID`, `userName`, `pass`) VALUES (1001, 'Nick', 'pass1'), (1002, 'Jack', 'pass2'), (1003, 'Sarah', 'pass3'), (1004, 'Mike', 'pass4'); -- -- Indexes for dumped tables -- -- -- Indexes for table `conferenceRoom` -- ALTER TABLE `conferenceRoom` ADD PRIMARY KEY (`roomID`); -- -- Indexes for table `reservation` -- ALTER TABLE `reservation` ADD PRIMARY KEY (`reservationID`), ADD KEY `userID` (`userID`), ADD KEY `roomID` (`roomID`); -- -- Indexes for table `user` -- ALTER TABLE `user` ADD PRIMARY KEY (`userID`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `conferenceRoom` -- ALTER TABLE `conferenceRoom` MODIFY `roomID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=206; -- -- AUTO_INCREMENT for table `user` -- ALTER TABLE `user` MODIFY `userID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1005; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Scenario:
You have recently been hired as a Chief Information Governance Officer (CIGO) at a large company (You may choose your industry). This is a newly created position and department within the organization that was founded on the need to coordinate all areas of the business and to provide governance of the information. You will need to hire for all positions within your new department.
The company has been in business for more than 50 years and in this time has collected vast amounts of data. Much of this data has been stored in hard copy format in filing cabinets at an offsite location but in recent times, collected business data is in electronic format stored in file shares. Customer data is being stored in a relational database, but the lack of administration has caused data integrity issues such as duplication. There are currently no policies in place to address the handling of data, business or customer. The company also desires to leverage the marketing power of social media, but has no knowledge of the types of policies or legal issues they would need to consider. You will also need to propose relevant metrics that should be collected to ensure that the information governance program is effective.
The CEO and Board of Directors have tasked you to develop a proposal (paper) that will give them the knowledge needed to make informed decisions on an enterprise-wide Information Governance program, addressing (at a minimum) all of these issues, for the company.
Requirements:
The paper should include at a minimum of the following sections:
a. Title page
b. Executive Summary (Abstract)
c. Body
i. Introduction (including industry discussion – 1-2 pages)
ii. Annotated Bibliography (2-3 pages)
iii. Literature review (2-3 pages)
iv. Program and technology recommendations, including:
1. Metrics
2. Data that matters to the executives in that industry, the roles for those executives, and some methods for getting this data into their hands.
3. Regulatory, security, and privacy compliance expectations for your company
4. Email and social media strategy
5. Cloud Computing strategy
d. Conclusion
e. References
2. You must include at least two figures or tables. These must be of your own creation. Do not copy from other sources.
3. Must cite at least 10 references and 5 must be from peer reviewed scholarly journals (accessible from the UC Library).
4. This paper should be in proper APA format and avoid plagiarism when paraphrasing content. It should be a minimum of 8 pages in length (double-spaced), excluding the title page and references.
Milestones:
· Week 3 – Introduction Section - A 1-2 page paper describing the industry chosen and potential resources to be used. 25 pts.
· Week 6 - Develop a full annotated bibliography (2-3 pages). 25 pts.
· Week 12 – Develop the literature review (2-3 pages). 25 pts.
Total: 125 pts

Get help from top-rated tutors in any subject.
Efficiently complete your homework and academic assignments by getting help from the experts at homeworkarchive.com