CIS 515 Assignment 3

The intent of this paper is to design and propose a database management system solution to Grandfield College for tracking software installed. I have analyzed the organizational issues and needs and developed conceptual, logical, and physical designs of DBMS solution. In order to implement the solution, substantial research had been done on best practices in design, available products, and the legal and ethical standards to which we must adhere during design. This paper includes Business rules, Conceptual, Logical, and Physical database designs, Recommendations on best DBMS required for Grandfield College, Data model, Legal

IBM Global Services, the technology services and consulting division of International Business Machines (IBM), is the world’s largest provider of systems integration and technology consulting. It offers services in areas such as application development, data storage, infrastructure management, networking, and technical support (Datamonitor Plc., 2007, p.4). IBM Global Services is also among the world leaders in providing business consulting and outsourcing services. IBM Global Services’ headquarter locates in Armonk, New York. The company has more than 190,000 employees around the world.

P7 - Report on three examples of current affairs that affect public services and citizens

1. The cartoon is of a Mongolian man's head, with eight tentacles spreading out. Each tentacle contains unwanted things that the illustrator thinks the Mongolians will take with them into Australia, should there be an influx of immigrants. The head if the man is drawn in a menacing manner, with an unfriendly scowl and two buck teeth that have a gap the size of another tooth between them. The multiple alleged vices of the Mongolians include: cheap labour, pak ah-pu (a gambling game), immorality, small-pox and typhoid, opium, bribery, fan-tan (another gambling game) and customs robbery. The fact that the man is depicted as an octopus implies that the Mongolians are thought of as slimy, unclean and therefore subordinate and perhaps the fact that the Asians would get a 'hold' on Australia.

Organizations today use information in more than ways than one can count. Information is so important today because it is used by organizations and businesses to keep everyday business processes and day-to-day operations running smooth and without glitches. As I have looked at many business and organizational sources both in person and on the internet, I have found that a large majority of these have the information flow start at the top in the executive area. This is what I like to call the trickle-down effect. Information is set to flow among the business and organization and starts at the top and goes all the way to the bottom. During that time, information can be changed to allow only that

Above: Above grade level students will be expected to complete 8-10 rounds of the three-digit addition problems during the provided activity time. The teacher will ask above grade level students key questions (What other strategy could you use to check your answer?) Above grade level students will be asked to complete two rounds of the activity adding three, three-digit numbers (roll the three dice three times). The students will be asked to draw or write one strategy they used to solve the three, three-digit addition problems. If students complete the activity early, they can be a “teacher’s helper” and provide ESOL and below grade level students with assistance that is closer the their zone of proximal development. (The student has to obtain a high level of understanding to be able to teach the material.)

The reason why this is the way to go is that relational databases are limited in the number of relationships that can be dug down and analyzed. Using a dimensional model will allow the use of multi-dimensional cubes to be able to pull 3 or more dimensions back into a pivot table. An example would be Sales by customer service rep by assigned sales territory. This provides a deeper detail of data than you would be able to get out of a relational database. For each department of the university, I propose a Data mart for each one. The reason why this is the case is so that every department can manipulate their own data as they see fit with their own resources because it is on a different server than another data mart typically. The look and feel of the Data Mart is up to that department and does not bother the other departments Data Marts. Individual data marts can also increase response time because there are not as many people hitting them all at one time. If a new department were to pop up, data mart creation is very easy to do. Each record will be unique based on the primary or composite keys of the table, and those keys could be surrogate keys such as using AutoNumber like in Microsoft Access. Depending on the analysis of the data, it may be determined that the ID numbers between student and teacher are unique and this can be the way to link items together throughout the database. The

Spellman University had requested that I develop a database for their college. The purpose of the database will be to track the students and the courses. There also will be a place in the system to track the instructors teaching each course. There are many things to be considered in composing this database. This paper will outline the entities, attributes for each entity, the type of relationship, constraints, some business rules, and the conceptual and physical models.

Ask probing questions and employ active listening skills to find out what their true needs are.

Some of the benefits of storing documents in hard copy format are that you can track amendments to the original documents, you can read the document without the reliance on electricity, you can physically see the signature on the document and files cannot be accidently deleted or corrupted. Documents can be recalled and deleted/amended easily

Furthermore, the organization uses a collaboration tool, Microsoft SharePoint, integrated with Office 365 in a cloud environment (Microsoft [MS], n.d) to host an intranet to provide employees with a platform where they can find company information, scheduled and upcoming events, a social networking component to keep all parties connected, and a search function to enable topic searches. This is also the platform for the student extranet that provide a single secure webportal to students which hosts all relevant information, announcements and social networking features to enhance and support the student experience while at CCU (Turbin, Volonino, & Woods, 2015). Furthermore, SharePoint also provides email services through a webbased Outlook which is the main communication medium between business and educational staff and individual students.

The current challenges in analysis of student data is that it is gathered by various organizations and departments located in different geographical positions. In future, institutions of higher learning will integrate the all these information collection and storage points. For instance, the data on student grades, the latest course logins and attendance will be correlated to produce a more in-depth analysis of the student’s progress. Also, the system will be intelligent in that it will be able to learn from the previously collected data and offer suggestions. According to an interview of the Chief Operating Officer (CEO) heading the online Arizona State University portal, advanced use

Currently, the college is in the stage of developing solutions. Of the different search methods available, the College is utilizing the trap search and the active search. Outside vendors have been brought in to demonstrate the services their products can provide. The focus of these products varies, but all share a feature that provides students with improved degree planners and student monitoring software. The similarities are outnumbered by their differences, however, which does include cost.

Designers require to compromise between optimizing query performance and maximizing query flexibility. Columnar databases use less disk space and are more efficient in their I/O demands than records-based data warehouses but force their own compromise between optimizing for new record insertion versus data selection and retrieval. The current paper gives an idea about advantages and disadvantages of Row and Column Oriented Database concepts. The row by row approach keeps information about an entity together. In the student example above, it will store all information about the first student and then all information about the second student and so on. The column by column approach keeps all attribute information together: all of the student name will be stored consecutively and then all of the student email, etc Both approaches are well designed and typically a choice is made based on performance expectation if the expected workload is based on entity (e.g., find a student, add a student etc) then row by row approach is preferable because all information regarding a particular student is stored together but if the expected workload tends to read per query only few attributed from many records (e.g., a query that finds most common email address domain), then column by column storage is preferable since irrelevant attributes for a particular query do not have to be access. The row by row approach is writing

The main aim is to research on the internship tracking system as perfectly as possible. This system should store the information in order to complete that entire internship process. This research paper consists of system architecture and gives a good description on the system with the support of ER diagram.