Assignment 1: Business rules and Data Models
CIS 111: Introduction to Relational Database Management Systems
Purpose of Database
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.
Entities and Attributes of Database There will be three main entities in the system; the students, the instructors and the courses. The
…show more content…
The students would have to either prolong their time for the course or the institution would have to find more students to fill the second class.
There will be many different constraints in the database. An example of a constraint is one if the students' GPA will have to be between 0.00 and 4.00. Another example would be that each class can only have one instructor. There would be a constraint on the social security number ensuring that there are only nine numbers and in the format is xxx-xx-xxxx, and each individual number would be between 0 and 9. There would be a constraint for the telephone numbers as well. Each individual number would be between 0 and 9 in the format of (xxx)-xxx-xxxx.
Conceptual vs. Physical Model
The conceptual model will have all of the attributes from the students as well as the instructors. It will also have the all of the constraints. This model will have software and hardware independency. At this level any changes to the database management system will not affect this model. The physical model will take all the information that comes from the conceptual model and describe it so that it can be saved and stored. This model will need to know the physical storage device and access method so that it can reach the information stored in the devices. The physical model, not like the conceptual, will be both software and hardware
ACCT505 Part B Capital Budgeting problem Clark Paints Data: Cost of new equipment $200,000 Expected life of equipment in years 5 yrs Disposal value in 5 years $40,000 Life production - number of cans 5,500,000 Annual production or purchase needs $1,100,000 Initial training costs Number of workers needed 3 Annual hours to be worked per employee 2000 hrs Earnings per hour for employees $12 Annual health benefits per employee $2,500
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
1) Write the following as an algebraic expression using x as the variable: Twelve less than six times a number
Companies find opportunities in product innovation by providing new products and services to customers. This keeps current customers interested in doing business with the company and has the potential to attract new customers. Sometimes this is done by creating new products, greatly changing an existing product or by just changing the way the current product is presented. Another form of product innovation is branding. By creating a more positive brand image a company can keep the interest of consumers.
The manager will need to ensure that they have the correct level of rapport with their employee. Too familiar in nature may be misconstrued as forward and harassing in the wrong context. However no personal rapport whatsoever may provide the receiver of the information with the impression that the sender of the information is just not interested. A fine line must be weighed up for each individual. When a good rapport has been achieved, then the person will uncritically accept suggestion or advice which they are given.
Read the textbook. Do research on databases. All answers should be analytical, using IGEA and MLA. Please use own words/original thought, not regurgitation of facts. This is the expectation all year.
What is the probability of rolling a four in the gambling dice game of craps (given two six sided dice)? 3/36 or 8.33%. What is the probability that a player can roll a four 3 times in a row (assume that rolling the dice each time does not affect the outcome of the next roll)? 3/36 x 3/36 x 3/36 = 27/46656 = 3/5184
Refer as needed to the material in Chapters 12 and 13 of the textbook. Keep the following tips in mind as you research data, as well as organize, analyze, interpret, and illustrate these data:
During the first session it is important to ensure that the practitioner can provide the client with
Analyze the fundamental differences between the working capital structures and components for each chosen company, and speculate upon the main reasons why such differences exist.
A prestigious university has recently implemented a consolidation strategy that will require it to centralize their student records. In order to move forward, the local university will need to develop a data model that will retain student records and perform various data extract transform and load (ETL) processes. As the database consultant it will be necessary to assist with the development of a design strategy for student records. The following has been determined after meeting with various university subject matter experts:
Marcovitch, S. G., Gold, A., Washington, J., Wasson, C., Krekewich, K., & Handley-Derry, M. (1997).
IMF Announces Sale of 10 Metric Tons of Gold to the Bangladesh Bank. (2010). Retrieved from
Where students and secretaries are the user types. Mainly the secretary places a main role in opening the quotas for the companies and then she will give the announcements to students about the deadline. Moreover, all events will be logged keeping in mind the prevention of data loss and keep the system safe. Additionally the system must be effectively backed up. The system can be implementing with utilizing data structures, for example, files, however by utilizing database for managing data; it will be substantially more sensible and effective. It is clear that the preferences of relational database idea have demonstrated, so we chose to plan our system by utilizing a relational database. As opposed to implement our own database, utilizing a well known database server application is more