Database professional

Resp 1

 

I am an administrator for a company that is requesting an information system that tracks our employees work hours, paid time off and none paid time off. I would like this to be done through the web. It must be accessible through secure browsers. The system should do error checking for total hours calculated. It must be able to add and drop employee profiles. I would like there to be non-functional requirements such as scalability, reliable availability, and security.

            For the input screen, I would like something esthetically pleasing that is simple to navigate. I would like there to be three sections; two drop downs that include, different job codes for the different contracts that pay the employee, then a drop down for the different kind of hours being charges such as PTO, Holiday, Bereavement, Regular Hours, and Jury Duty; and a last section that has each day of the week to input hours into. I would also like there to be an instruction tab to have instructions for the process of correctly put in the hours.

 

Resp 2

For this discussion, I have chosen to do an information system that allows the users to buy, sell and trade all cryptocurrencies utilizing one platform. The intended users of this information would be cryptocurrency enthusiast and individuals who like to keep track of the current crypto market. The stakeholders would be an individual company who would be in charge of creating this, as well as funders to the project.

            The vision for this is to be secure so it would have to be written with security in mind since cryptocurrency is a very hot topic in today’s day. Not only would users be able to make these trades and access their accounts through the web (Secure Webpage), they would also be able to access their profile to make instant trades, purchases and sales using any mobile device, whether that is iOS or Android-based devices.  

            It is important to note that more than one programming language would have to be used since it is multi-platform and security focused. An input screen would be something eye-pleasing but very informative, it would have a list of all of the cryptocurrencies that you own on the main screen, a menu mar outlined at the bottom with all of the options available as well as a list of current pricing for all the cryptocurrencies.

            Also, to note the way we will make money out of this product is to charge a fee for all transactions.

Resp 3

An up and growing patient management software company is looking for a solution that can capture client and statistical information quickly while at EMS conferences, and have the ability to search for the information quickly. For clients, it should catch agency name, contact first name & last name, phone number, email, City, and State. Statistical information includes; agency size, employee count, call volume, transport volume, Checkboxes for ALS, BLS, ePCR, or Paper. Also, the conference name, city, and state they were met at. Most conferences today have barcodes embedded in ID tags containing vital information about customers. The data would be stored in a database with SQL capabilities. Nonfunctional requirements include the ability to operate online or offline, have an intuitive structure and be easy to use. Must not allow duplication of data if the agency is already in the database.

The design includes a menu option allowing online/offline functionality and the ability to search. I envision three different tabs in the program: Tab 1: Conference Information, Tab 2: Client Information, Tab 3: Client Statistics. Each tab collected the required information and a submission button on Tab 3 sends and saves the information. Tab 4 allows you to scan information from a barcode if available.