...Phase 2 Individual Project By Troy Verdeyen Part I I developing a statistical database that following 2 sets of data that list football teams and quarterbacks and there are 7 teams and 5 quarterbacks: | D | Q | Jets | Giants | Cowboys | 49’ers | Patriots | Rams | Chiefs | Joe Namath | Played for | | | | | Played for | | Eli Manning | | Played for | | | | | | Troy Aikman | | | Played for | | | | | Joe Montana | | | | Played for | | | Played for | Tom Brady | | | | | Played for | | | D = {Jets, Giants, Cowboys, 49’ers, Patriots, Rams, Chiefs} Q = {Tom Brady, Joe Namath, Troy Aikman, Joe Montana, Eli Manning} I looked up the players and teams and found out this information. Joe Namath played for the Jets and the Rams and Joe Montana played for the 49ers and the Chiefs. The others like Troy Aikman played only the Cowboys and Eli Manning only the Giants and Tom Brady only the Patriots. I found all this on the http://www.pro-football-reference.com web site and I copied there stats at the end of this paper The domain of D set are: (Jets, Namath),(Giants, Manning),(Cowboy, Aikman (49ers, Montana), (Patriots, Brady). In this order this is a function, because each member of the domain is not in any other domain. The order pair of Q and D that are not functions because they played on two of the teams are (Namath, Jets) and (Montana, Chiefs) and because there would be multiple range elements possible if it was a function. Part II ...
Words: 812 - Pages: 4
...activity that is aimed at developing and managing trusting and long term relationships with larger customers. In relationship marketing, customer profile, buying patterns, and history of contacts are maintained in a sales database. Kellogg's is using a strategy called "Direct Mail Drive" to communicate with over 1.5 million customers. They are working with agency Leo Burnett using integrated strategies to build up a relationship and database of customers. Relationship Marketing Relationship marketing is an activity that is aimed at developing and managing trusting and long term relationships with larger customers. In relationship marketing, customer profile, buying patterns, and history of contacts are maintained in a sales database. Kellogg's is using a strategy called "Direct Mail Drive" to communicate with over 1.5 million customers. They are working with agency Leo Burnett using integrated strategies to build up a relationship and database of customers. Relationship Marketing Relationship marketing is an activity that is aimed at developing and managing trusting and long term relationships with larger customers. In relationship marketing, customer profile, buying patterns, and history of contacts are maintained in a sales database. Kellogg's is using a strategy called "Direct Mail Drive" to communicate with over 1.5 million customers. They are working with agency Leo Burnett using integrated strategies to build up a relationship and database of customers. Relationship...
Words: 676 - Pages: 3
...Server Training (16 Courses) Training on how to build and manage SQL Server databases. Our SQL Server Training Courses provide the skills needed to build a solid foundation for SQL Server development. Introduction An overview of DBMS technology * How data is accessed, organized and stored * The database development process * Query and application development tools * CASE tools for database analysis and design * Tables, attributes and relationships * Primary and foreign keys * Relational integrity constraints * Manipulating data: selection, projection, join, union, intersection, difference * An integrated, active data dictionary * The query optimizer * Developing the logical data model * Mapping the data model to the relational model * Specifying integrity constraints * Defining the data in the data dictionary * Capturing entities, attributes and identifiers * Describing relationships: one-to-one, one-to-many, many-to-many * Optional and mandatory relationships * Resolving many-to-many relationships for implementation * Generating the SQL to build the database * Reverse engineering to capture the design of an existing database * SQL Programming Language Introduction 1 Days * Write SQL code based on ANSI/ISO standards to build Microsoft SQL Server or Oracle database structures * Update database content with SQL and transaction handling * Retrieve data with filter conditions and from...
Words: 1010 - Pages: 5
...what information is available. This may help you develop a research plan. Fourth Step: Investigating a topic Try to find out: • What books are available in your library? • What books are available in other libraries? • Which subscription databases seem to have relevant and appropriate articles? Fourth Step: Investigating a topic Locating Books in the OCC Catalog • Start by accessing the OCC Library homepage: http://www.ocean.edu/library/welcome.html • Click the “Find Books and Movies” link Fourth Step: Investigating a topic Locating Books in the OCC Catalog This will take you to the OCC Catalog. You can search here for books, Ebooks, media items (like videos and CDs), as well as print periodicals Fourth Step: Investigating a topic Locating Articles in the OCC Databases If you are ON campus: • Access the OCC Library homepage • Click the “Find Articles” link Fourth Step: Investigating a topic Locating Articles in the OCC Databases If you are OFF campus: • Log in to Ocean Cruiser • Click the “Announcements” icon • Then select “Access Library Databases From Off-Campus” Fourth Step: Investigating a topic How Do I Choose a Database? Fourth Step: Investigating a topic How Do I Choose a Database? No two...
Words: 1203 - Pages: 5
...person developing a relational database use keys in their relational database model? Keys as they suggest by their name are part of the relational database and play important roles in the structure of the table used by database. Therefore, it is impossible for a person developing a relational database to work without keys. The ability to link tables with keys that allows for the reasonable demonstration of information that relational database provides. Keys ensure each record is uniquely identified by one or more grouping of fields within the table. They help database to implement integrity and help the relationship between tables. There are different types of keys used in the relational database and each key have specified functions in the database structure. They includes; primary keys, foreign keys, super keys and candidate keys or alternate keys Super key These are combination of all fields within a table that uniquely identifies each record within that table Candidate keys This is a single field that involves combination of fields that uniquely identifies each record in the table. The least combination of fields differentiates a candidate key from super key. Every table in the relation database must have at least one candidate key but can also have many keys. For instant the use of id to uniquely identifies each student in the student table. This would be a candidate key. Primary keys This is a key of reference for the table and is used all through the database to help...
Words: 454 - Pages: 2
...Using Internet: 35% Developed China:28% Developed Users China: 37% India: 6% Developing Other developing c ountries: 66% Total population: 6.5 billion Developing Not using Internet: 65% India: 10% Other developing c ountries: 53% Total population: 7 billion Note: * Estimate Source: ITU World Telecommunication/ICT Indicators database • The world is home to 7 billion people, one third of which are using the Internet. 45% of the world’s Internet users are below the age of 25. • Over the last five years, developing countries have increased their share of the world’s total number of Internet users from 44% in 2006, to 62% in 2011. Today, Internet users in China represent almost 25% of the world’s total Internet users and 37% of the developing countries’ Internet users. 4.5 Internet users by age and by development level, 2011* 4.0 • Younger people tend to be more online than older people, in both developed and developing countries. 3.5 Billions of people 3.0 2.5 Not using Internet Using Internet 66 % 64% 2.0 70% 77% 1.5 1.0 29% 0.5 0.0 23% 71% 34% 36% 30% 23% Under 25 Over 25 77% Under 25 Over 25 Developed Under 25 Developing Note: * Estimate Source: ITU World Telecommunication/ICT Indicators database Over 25 World • In developing countries, 30% of those under the age of 25 use the Internet, compared to 23% of those 25 years...
Words: 1352 - Pages: 6
...• Question 1 2 out of 2 points When developing a database system, the database is constructed during the implementation phase. Selected Answer: True • Question 2 2 out of 2 points The Microsoft Access 2013 form editor is a(n): Selected Answer: banded form editor. • Question 3 2 out of 2 points Which of the following is not a source for user requirements during the requirements analysis stage of developing a database system? Selected Answer: All of these are sources for user requirements. • Question 4 2 out of 2 points Microsoft Access 2013 is only used to prototype databases where Microsoft Access itself will be the final DBMS. Selected Answer: False • Question 5 2 out of 2 points Given only the following excerpt of an E-R model: Which of the following is known to be true? Selected Answer: A single instance of ENTITY B may be related to many instances of ENTITY A. • Question 6 2 out of 2 points Subtype entities may be either exclusive or inclusive. Selected Answer: True • Question 7 2 out of 2 points Which of the following is not a basic element of the E-R Model? Selected Answer: Use cases • Question 8 2 out of 2 points Maximum cardinality indicates whether or not an instance of one entity class must be related to at least one instance of another entity class. Selected Answer: False • Question 9 2 out of 2 points In crow's foot style...
Words: 1478 - Pages: 6
...Extensive experience in using Github to keep track of changes in the code base. * Worked on Stored Procedures, Triggers, Functions, Views and Database Design. * Experienced in web application development using Java for back end development. * Solid experience working on Dependency Injections in Spring using XML. * Have worked on front end designing using JSP, as well as CSS, Ajax, EL and JSTL. * Ability on front end validation using HTML 5 and JavaScript. * Technical experience on AOP framework Spring, ORM framework Hibernate, MVC framework Struts and SpringMVC, and JavaScript framework Angular JS. * Solid knowledge of AOP and EJB. * Have been included in all aspect of Software Development Life. * Worked on unit testing using JUnit framework. * Experienced in working on WSDL based SOAP webservice using Apache CXF, and RESTful webservice using Jersey. * Knowledge of validation through struts-validation and Java annotation based validation. * Strong ability of utilizing Spring integration with Struts 1.3.1 and Hibernate 3.6. * Developed multiple distributed, transactional, portable applications using EJB architecture. * Practical knowledge of DB Servers including Weblogic12c, Tomat 7, Oracle10g, MySQL, Active Server Page, TFS, Access, and SharePoint. * Solid understanding of database performance tuning and code optimization. * Fluent Mandarin and English. Education Bachelor of Science University of Miami, Coral Gables...
Words: 1252 - Pages: 6
...Develop Production Database for Plant Operations Division Scott Peterson Columbia College Author Note This paper was prepared for Business Information Systems 393, taught by Ricky Martin Due 10 May 2012 Veracity Communications was formed, in 2002, by a small company called Off Campus Telecommunications. Veracity Communications was a provider offering phone, internet and cable services. One such company they contracted their services through was IProvo. IProvo was a public-private partnership located in Provo. The City of Provo constructed a fiber optic infrastructure that connected homes and business throughout the city as well as municipal, schools, etc. Provo city owned and maintained the fiber optic lines and equipment while privately owned companies, such as NuVont, Mstar and Veracity Communications, offered phone, internet and cable through IProvo’s network. Construction on IProvo’s infrastructure began in 2004 and was completed in December 2006. In August 2008 Provo city sold IProvo to a local company called Broadweave Networks. One year later Broadweave merged with Veracity Communications which became Veracity Networks. They are a locally owned company that provides telecommunications to both small and large businesses and residential homes alike. It is interesting that they chose the name “Veracity” for their business name since veracity is defined as “conformity to truth or fact” and “correctness or accuracy, as of the senses or of a scientific instrument...
Words: 1385 - Pages: 6
...Class Name Title Week of Assignment Dr. Chart completion and Reflection Paper Find and review: Usefulness of each database Important new sources, scholars, or ideas Value of searches in inspiring new ideas/ surprises Answered By, Introduction The chart below was utilized for the initial library search for resources in professional or research interest. There are; three peer-reviewed journal articles, one book chapter, and one scholarly source. Following the chart, is a brief reflection paper on the library search and results. |Article Citation |Database |Keywords |Search Limiters |Skills in this Database | |Peer reviewed article: |Roadrunner Search, Discovery |Cultural Change, |Military Logistics, |Fair: Easy to use, need to | | |Database |Data Rights, |Defense Logistics Agency, |practice on my search limiters. | |Better Buying Power or Better Off Not: | |Heuristic Economic Model, |Quality Assurance | | |By: Hasik, James. Defense Acquisition Research | ...
Words: 985 - Pages: 4
...Research Paper Introduction Database-management system (DBMS) is a collection of interrelated data and a set of programs to access those data. The collection of data, usually referred to as the database, contains information relevant to an enterprise. The primary goal of a DBMS is to provide a way to store and retrieve database information that is both convenient and efficient. Database systems are designed to manage large bodies of information. Management of data involves both defining structures for storage of information and providing mechanisms for the manipulation of information. In addition, the database system must ensure the safety of the information stored, despite system crashes or attempts at unauthorized access. If data are to be shared among several users, the system must avoid possible anomalous results. Because information is so important in most organizations, computer scientists have developed a large body of concepts and techniques for managing data. These concepts and technique form the focus of this book. This chapter briefly introduces the principles of database systems. Literature Survey 1. Redundancies and inconsistencies can be reduced 2. Better service to the Users 3. Flexibility of the system is improved 4. Cost of developing and maintaining systems is lower 5. Standards can be enforced 6. Security can be improved 7. Integrity can be improved 8. Enterprise requirements can be identified 9. Data...
Words: 1323 - Pages: 6
...SQL Server 2- OFOQ ERP System (Time Management) 3- Project SQL Server From the first day of my coop, my supervisor gave me an SQL database and a Microsoft SQL course CD to practice SQL. It took me a week to refresh and to get back on the right path. Moreover, he also gave me a documentation that has all of the information about the joins between the tables, so I can fully understand how to generate meaningful reports to the management. The next two weeks were about maintaining the database and how to perform a periodical database backup as figure 1 illustrates. Figure [ 1 ] SQL Backup Job OFOQ Human Resource System (Time Management) The company have two ways to record the employee’s attendance. First, by using the gates that are near the elevators. Second, by using the finger scanner. Both ways have two distinct servers to record the attendance. I was fortunate enough to take charge of extracting the log files of attendance from both servers and then upload them to the HR system as a daily task Figure2. Sometimes, the employees forget to login in or logout and the system does not know how to fix this conflict, because for every login there have to be a logout. I am able to resolve this conflict because they trained me to use the system for more than two weeks. Figure 2OFOQ HR System Time Management Project The Database Administrator (DBA) proposed the idea of my project, which is about a mobile portal for the company’s archiving system that will allow the...
Words: 987 - Pages: 4
...Work-Related Project Analysis Part 2 BSA/376 October 15, 2012 Andrew Nash, MBA Introduction to Elements of System Design Managing a live project past the planning stage is a stressful and complex process. It takes a very special person to do this kind of job and even though it is stressful, that special person thrives in this kind of work and are very good at managing it. For a successful project management, there are four areas that must be controlled and they are: 1. Assigning tasks to team members after organizing each individual into a team. 2. Closely monitoring and controlling the progress of the project. 3. Communication monitoring for the project. 4. Keeping track of all the open activities in the lifetime of the project. Systems design is the structuring the components and organizing the process of the system so that the new system can be programmed. The components are composed of the network, software, application architecture, system interfaces, user interfaces, the system appthat were built during the analysis. The outputs are the models or diagrams that describes the architecture of the system and detailed logic within the various components of the programming. Traditional Approach to Design The traditional approach to systems design is the data flow diagram which is enhanced by the addition of system boundary in which the designer sketches the system boundary to show the overall system. A structured design includes a system flowchart which show...
Words: 736 - Pages: 3
...MBA635 – ELP ASSIGNMENT – WEEK 01 Avinash Shankar Coleman University Database Integration – A framework The Physical Database Design depicts the actual structure of a set of relational tables specific to the platform and Database Management Systems (DBMS) on which the database is implemented. It is used to transition a logical data design into a physical database design that can be used to generate Data Definition Language (DDL). It also takes the current Systems environment into consideration, as well as some non-functional requirements. Basically the Physical Database Design is the implementation of the logical data design with any changes needed for physical considerations, such as capacity and performance. A physical database design is performed in three stages (LePendu, P., & Dou, D., 2011, p. 217 to 244): 1. Logical database design, which includes gathering of business requirements, developing a logical data model, and designing how to load the data 2. Conversion of the logical data design into a Physical Database Design includes table definitions, primary and foreign key relationships, and basic indexing 3. Post deployment Physical Database Design (often performed by a database administrator) includes improving performance, reducing I/O, and streamlining administration tasks. Data Integration Layer The data integration layer should be modeled in 3rd normal form or near 3rd normal form and is considered to be similar to an operational data design...
Words: 582 - Pages: 3
...Telephone: +355 69 3919969 (mobile) e-mail: adiymeri@hotmail.com Summary • Very good knowledge on IT systems, global system analysis, developing, testing and managing of software in several programming languages. Software Engineering, Software Analyst, Database designer and Administrator in ORACLE, SQL Server DBMS, PostgreSQL, etc., Software Designer, Software Developer, Network and System Administrator. • Experience managing national level large scale IT projects. • Experience in software development, through the full cycle, for requirements analysis, detailed specifications, project planning, resource management, implementation, testing and beyond. • Fluency in English, Italian, Albanian with intermediate knowledge of French and German Experience Database Designing Consultancy 03/2010-present Immovable Property System (IPS) Land Administration and Management Project (LAMP) Immovable Property Registration Office (IPRO) • Develop and maintain the database, database applications, database interface functions (data entry forms and reports) and products. • Create, maintain, install, modify and test modules for the database and user interface of the IPS. • Prepare comprehensive written user manual/guideline to use, maintain and update the database produced. A first draft of the user manuals should be ready at the end of the Construction Phase with the final version at the end of the Transition Phase. •...
Words: 776 - Pages: 4
