Free

M4A3 Project Milstone 2: Data Modeling Layout - Coursework Example

Comments (0) Cite this document
Summary
Most of them use softwares that generate a lot of data that needs to be stored then analyzed using computing means to derive patterns that will influence decision-making (Gudnason &…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER96.4% of users find it useful
M4A3 Project Milstone 2: Data Modeling Layout
Read TextPreview

Extract of sample "M4A3 Project Milstone 2: Data Modeling Layout"

Data Modeling Layout Insert Insert Introduction Architectural companies experience a lot of challenges when it comes to handling massive data. Most of them use softwares that generate a lot of data that needs to be stored then analyzed using computing means to derive patterns that will influence decision-making (Gudnason & Scherer, 2012). A case in hand is the need to exchange product model data currently implemented in the USA. It aims to disseminate product information at every level of its development. Consequently, these companies require a database to automate the process of coming up with the product. Such databases require high-quality hardware and technicalities to integrate considerable data from different organizations.
Data Modeling
Data modeling refers to how the logical structure of a database is. It is a core concept when obtaining abstraction in a database management system (Moris, February 4, 2014). Essentially, the manner in which entities are to one another and the entire processing and storage in the system entails data modeling (M A K & Pan, 2009). To build this model, we followed the three levels which include planning, designing and deploying.
The creation of a conceptual data model comes first following the interpretation of the business rules. In this stage, use of entity relationship diagram is employed in mapping the information about the enterprise (Owen et al., 2010). Further, it concerns with the events surrounding the steps involved. They are without consideration for concepts surrounding the databases. The stage informs on the storage of data and its usage.
Data Modeling Layout

Figure 3. Entity Relationship Diagram
From the figure 3 above, there is a one to many relationships from the customer to the project or from the client to costing.
Design Tool
In the actual world, there exist entities and entity sets that exist in a relationship (Whitehorn & Marklyn, 2007). The latter forms the basis for establishing entity relationship diagrams. The application of Entity relationship model is on developing a conceptual implementation of a database.
Figure 1. Shows the database design tool
Figure 2. Shows database implementation
Queries
The questions I will be using in this project include the following. First is the query to retrieve customers details upon need. The sample question is below.
SELECT customer.customer_id, customer.name, customer.address, customer.phone, customer.email, customer.residence FROM customer;
Secondly, I would use the query that displays all the projects available (Rockoff, 2010). The SQL view of the query is below.
SELECT projects.project_id, projects.name, projects.project_description, projects.project_location, projects.project_duration, projects.customer_id FROM projects;
Thirdly, I need a query to show me the costing of a particular project relating to a customer with a specific identification. The SQL View should look like this.
SELECT costing.costing_id, costing.costing_name, customer.name, projects.name, costing.project_cost
FROM (customer INNER JOIN costing ON customer.customer_id = costing.customer_id) INNER JOIN projects ON (projects.project_id = costing.project_id) AND (customer.customer_id = projects.customer_id);
I also need a query that displays the status of a particular project either as completed, ongoing or yet to start. The SQL View for the project is,
SELECT projects.project_status FROM projects;
Further, I could use the queries to retrieve information on projects that are ongoing alone.
The SQL view is,
SELECT projects.project_id, projects.name, projects.project_description, projects.project_location, projects.project_status, projects.project_duration, projects.customer_id
FROM projects WHERE (((projects.project_status) ="On going"));
From the information above, queries are important objects in retrieving information that meets particular criteria that are user defined. For instance, the company may want to view information on customers from a specific location. Also, they may need to check tasks in a given area that are on progress.
Conclusion
The challenges in architectural engineering firms are enormous especially when it comes to handling data. These companies use a variety of softwares that generate a lot of data that is useful to the organization concerned. Consequently, this calls for powerful mechanisms and excellent database systems to enable them to handle data and consolidate data from various institutions.
References
Gudnason, G., & Scherer, R. (2012). EWork and eBusiness in Architecture, engineering, and construction. Boca Raton: CRC Press.
M A K, & Pan, Y. (2009). Professional SQL Server 2008 Administration with Windows PowerShell. Indianapolis, IN: Wiley Pub.
Moris, C. C. (February 4, 2014). Database Systems: Design, Implementation & Management (11th Ed.). Cengage Learning.
Owen, R., Amor, R., Palmer, M., Dickinson, J., Tatum, C., & Kazi, A. et al. (2010). Challenges for Integrated Design and Delivery Solutions. Architectural Engineering and Design Management, 6(4), 232-240. doi:10.3763/aedm.2010.idds1
Rockoff, L. (2010). The language of SQL. Australia: Course Technology PTR/Cengage Learning.
Whitehorn, M., & Marklyn, B. (2007). Inside relational databases with examples in Access. [New York]: Springer. Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“M4A3 Project Milstone 2: Data Modeling Layout Coursework”, n.d.)
M4A3 Project Milstone 2: Data Modeling Layout Coursework. Retrieved from https://studentshare.org/information-technology/1684842-m4a3-project-milstone-2-data-modeling-layout
(M4A3 Project Milstone 2: Data Modeling Layout Coursework)
M4A3 Project Milstone 2: Data Modeling Layout Coursework. https://studentshare.org/information-technology/1684842-m4a3-project-milstone-2-data-modeling-layout.
“M4A3 Project Milstone 2: Data Modeling Layout Coursework”, n.d. https://studentshare.org/information-technology/1684842-m4a3-project-milstone-2-data-modeling-layout.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF M4A3 Project Milstone 2: Data Modeling Layout

Systems, Process & Data Modeling

...? Systems, Process and Data Modeling Submitted to, Submitted By, of the Submitted on, [February 16th, 14.  Discuss use-case modeling, how is it performed, what and why is it used? Explain each clearly.  The last two decades of the twentieth century proved to be the advent of the Unified Modeling Language. The UML can be narrated as “a language for specifying, visualizing and constructing the artifacts of software systems, as well as for business modeling.” (UML Document Set, 2001). On lighter note, the UML is a graphical means of depicting the design models with respect to specific environments. Use Case Modeling is a...
13 Pages(3250 words)Research Paper

Project 2

...and darkness. “The Hollow Men” is about the modern society of hollow men because people are empty and dark without meaningful identities. They are empty because they are like Kurtz who are consumed with pursuit of power and wealth. The allusion to Kurtz in the epigraph says something about this pursuit: “Mistah Kurtz- he dead” (Eliot). The native who says this is lost after their master is gone, a master who nurtured them to believe that power and wealth are the only things important in the world. He is one of the hollow men with hollow gods. The repetition of “we” signifies the rise of the majority that has the same thinking: “We are the hollow men/We are the stuffed men…Headpiece filled with straw” (Eliot 1-2, 4). They...
5 Pages(1250 words)Essay

Project 2

...includes the logging operation that supplies the wood and paper to the whole world. Rapid urbanization and increased number of constructions can be regarded as the third most logical reason of deforestation. The other minor reasons include wildfires and overgrazing. The effects of deforestation can have various negative effects on the society. The most crucial one is the loss of habitat for innumerable species. Data says that around 70% of the earth’s animals and birds live in forests, which won’t be able to survive when deforestation would take place. Deforestation also causes climatic changes giving rise to soil erosion, decrease in rainfall and temperature swings. Also trees are known for absorbing greenhouse gases...
3 Pages(750 words)Essay

Modeling and Role Modeling

... Resources Arruda, E. (2005). Modeling and Role Modeling theory in nurse retention. Nursing Management. 36(4). 16-18. Bray, CO. (2005). Doctoral dissertation, research. Erickson, H., Tomlin, E., & Swian, MAP. (2005). Modeling and role modeling: a theory & paradigm for nursing. Cedar Park Texas: EST Company. Li, Y., SHi, J., Zheng, X. The theory of modeling and role modeling and systematic holistic research. Chinese Nursing Research. 2002. 16(4). 189-90. Sappington, J., Kelley, J., (1996). Modeling and role modeling theory: a case study of holistic care. Journal of Wholistic Nursing 14(2). 130-41.... Grand Nursing Theorist Report Helen Erickson Modeling/ Role Modeling...
4 Pages(1000 words)Essay

Data Warehouse Project Management

.... Hence to convince them and to prevent loss of support and finance from senior management, steps must be taken to improve the reports that could help in making better decisions. The users of each departments must also be satisfied by providing them with accurate reports. Data Warehouse Project Development Migration of the existing computer systems and data warehouses will require the use of a migration methodology which relies on an iterative approach to the architected environment. Figure: Classical versus Data Warehouse SDLC Part of the initial strategic consideration includes development and use of a company Data Model which...
20 Pages(5000 words)Essay

Health Information Management (HIM) Departmental Layout Project

...Calculating Record Storage Needs of Coppin Hospital HIM Departmental Layout Project Total filing inches available per shelf unit. Wholeunit=25 shelve*140 inches per shelf=3500 inches for whole 25 shelf unit Answer=3500 inches 2. Total inches of current and projected inches =90000+20000+3500=113500 inches Answer=113500 inches 3. Inches to be housed=90000+20000=110000 inches Filing inches per unit=3500 inches Number of filing units to be purchased= 110000/3500=31.4 So number of units to be purchased= 31 units Answer=31 units HIM 413, O&M II HIM Departmental Layout Project Instructions: 1. Explain space considerations, preparation, and...
3 Pages(750 words)Assignment

Decision Modeling (Management Decision Models) 2

...Decision Modeling (Management Decision Models) 2 Decision Modeling (Management Decision Models) 2 What Munger means by mental models According to Munger, mental models are framed as latticework that individuals must come up with in order to solve some of the challenges that come up regularly (Munger & Kaufman, 2008). People who try to remember things they learnt and apply them directly are doomed to fail. Munger suggests that people should try and base their challenges on the different experiences/disciplines, and apply them depending on what the situation demands (Labitan, 2008). Other key points...
1 Pages(250 words)Assignment

Primate Data Project

.... Method The two groups of animals were divided into separate groups then they were placed under observation. Each of these observations were then recorded on a table. What followed is the calculation of the percentage time for each activity. The time calculation involved the amount of time spent eating, eating or even moving around the place in which they were (Smith et al., 2010). Collection of the data also involved taking photographs of how they would behave towards each other’s company, the postures they would take from time to time and for how long they remained in those positions. The data collected would also involve the recording of what they fed on and what times they would feed and for how...
4 Pages(1000 words)Research Paper

Data Analysis Project

...Data Analysis Project Executive Summary This report takes into account the correlation and association of variables presented indicating a survey in which a sample size of 261 participants were provided with questionnaires in order to respond on questions relating to gender, choice of exercises, relationship between being a member and a non-member of an athletic team and how such individuals find the SU facilities satisfying or not. The study assumes three different methods of data analysis. For the correlations, 2-sample t-tests were run to identify the relationship between being a member, a male/female, owning a car, or smoking and the intensity of exercise as well as...
10 Pages(2500 words)Assignment

Data Project

...an annual average salary of $100000 to $ 120000. The distribution is bell-shaped and symmetric as shown by the red curve in the figure. Figure 2 The Figure 2 shows the outliers of the mean is 180390 as it falls away from the normal curve as shown in Figure one; this is determined by 1.5*IQR on the whisker plot. The mean annual salary in the US is $97486. Table 1 Descriptive Statistics: Mean Annual Wage Variable Mean StDev Variance Range Skewness Kurtosis Mean Annual Wage 97486 23362 545798091 123270 1.04 3.75 Table 1 shows that the arithmetic mean of annual wage is $97486 with a sample population size N =61, the measure of dispersion of the data SD =...
4 Pages(1000 words)Essay
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

Let us find you another Coursework on topic M4A3 Project Milstone 2: Data Modeling Layout for FREE!

Contact Us