Free Essay

Dmls

In:

Submitted By ymkrishna040
Words 2877
Pages 12
International Journal of Engineering and Physical Sciences 6 2012

Investigations on the Influence of Process Parameters on the Sliding Wear Behavior of Components Produced by Direct Metal Laser Sintering (DMLS)
C. D. Naiju, K. Annamalai, Siva Prasad Darla and Y. Murali Krishna
Abstract—This work presents the results of a study carried out to determine the sliding wear behavior and its effect on the process parameters of components manufactured by direct metal laser sintering (DMLS). A standard procedure and specimen had been used in the present study to find the wear behavior. Using Taguchi’s experimental technique, an orthogonal array of modified L8 had been developed. Sliding wear testing using pin-on-disk machine was carried out and analysis of variance (ANOVA) technique was used to investigate the effect of process parameters and to identify the main process parameter that influences the properties of wear behavior on the DMLS components. It has been found that part orientation, one of the selected process parameter had more influence on wear as compared to other selected process parameters. Keywords—ANOVA, DMLS, Taguchi, Wear. I. INTRODUCTION The major advantage of this process is it can use wide range of metal powders such as direct steel, bronze based powder etc. the Cu-based metal powders are also being used for purity and better surface finishing [2]. The major drawback for this process is the surface finish [3] and the wear [4] of the material. An experimental study on the sliding wear behavior of in situ Cu-TiB2 nano-composites fabricated by the reaction of pure titanium and copper-boron on a pin-on-disk wear tester under dry sliding conditions, rubbing against medium carbon steel disk at sliding speed ranging from 0.089 to 0.445 m/s and at loads between 20 N and 140 N. From the experiment it was found that the hardness, yield strength and wear resistance of the composited increased with the content (from 0.5 to 2.5 wt %) of TiB2 nano-particles in the copper matrix [5]. Laser parameters like laser beam power, spot size and experimental parameters like scanning speed and hatching distance have great influence on various properties of lasersintered bronze product. It is reported that density increases as surface roughness decreases with decrease in hatching distance [6]. It also states about the influence that material parameters like particle size distribution exert on the melting behavior. A reliability study on fatigue strength is reported for test results using components manufactured by DMLS [7]. This paper gives a brief report on the pin-on-disk wear testing and study carried out in order to reduce the sliding wear of DMLS components. These results will be valuable for the functional applications of components [8], for manufacturing of specimens etc. The process parameters such as sintering speed, hatch type, part orientation, infiltration and hatch spacing are considered in this experimental study. II. MATERIALS AND PROCESSING The components produced by DMLS were carried out on EOSINT M250 laser sintering machine which was developed by EOS Gmbh, Germany. The main advantage of using this technology is the part density and strength. The parts produced are 95% dense. There are no polymer binders that are used in this process. The components are produced directly from the metal powder and hence high accuracy can be expected along with minimal shrinkage. A CO2 laser is used for this sintering process with the power of 200 W and beam diameter of 0.4 mm. Bronze-nickel powder [9] is used in this process with a

D

UE to the increased concern for the process cost and cycle time, the technology is moving towards reduced product life cycles [1]. One way of reducing it is to develop prototypes and analyze them. Rapid prototyping is one of the techniques which are used in the recent days in order to fabricate the prototypes. The different RP processes which are widely used nowadays are stereolithography, selective laser sintering, fusion deposition modeling and direct metal laser sintering etc. Direct Metal Laser Sintering is an additive process for rapid tooling and manufacturing based on laser operations. This technique uses metallic powders in order to develop metallic parts by a process which involves progressive sintering of successive layers of metal powders conforming to the geometry of the successive slice of the CAD models to realize the components with shorter lead time.

Dr. C.D. Naiju is Associate Professor in School of Mechanical and Building Sciences at VIT University, Vellore, 632014, India (Phone: 0416 220 2136; Fax: 0416 22430 92; e-mail: naijucd@ gmail.com). Dr. K. Annamalai is Professor in School of Mechanical and Building Sciences at VIT University, Vellore, 632014, India (Phone: 0416 220 2136; Fax: 0416 22430 92; e-mail: kannamalai@vit.ac.in). Siva Prasad Darla is Assistant Professor(SG) in School of Mechanical and Building Sciences at VIT University, Vellore, 632014, India (Phone: 0416 220 2136; Fax: 0416 22430 92; e-mail: sivaprasaddarla@vit.ac.in). Y. Murali Krishna is student of B.Tech Mechanical Engineering at VIT University, Vellore, India (e-mail: ymkrishna040@gmail.com).

250

International Journal of Engineering and Physical Sciences 6 2012

grain size of 50 µm. Powder composition is Cu (22-90%), Sn (2-10%), Ni (10-70%), P (0.3-6%). The laser beam melts the metal powder present on the bed and a single layer of the component is formed over the previously sintered layer. The wear plays a major role in the application of the component and hence process parameters with appropriate levels that gives desired values for wear resistance has to be found out. The process parameters which are considered in order to improve the wear resistance and quality characteristics are sintering speed, hatch spacing, hatch type, part orientation and infiltration. Bonding of metal powder at a temperature slightly above its melting point with the help of a laser source causes sintering process. Sintering speed is defined as the speed with which laser beam sinters. Movement of laser beam takes place in a specified path and with an accurate spacing called as hatch spacing. Scan spacing is generally preferred to be less than the diameter of the laser beam. The pattern in which laser beam moves is known as hatch type. There are two types of hatch patterns that are generally being used in DMLS. One of them are unsorted type, which means that the laser beam moves alternatively in X and Y directions respectively. The other pattern is of shifted type where the laser beam is shifted by half the scan spacing in both X and Y directions. For the first two layers, the pattern is of unsorted type and during the third and fourth layers, the beam shifts by half scan spacing and continues to move as like in the unsorted pattern. The hatch spacing and hatch pattern has a great impact on the heat transfer through powder layer. The orientation of the part either horizontal or vertical i.e. in either X direction or Z direction (0º and 90º) by which the beam moves is called part orientation. In order to increase the density of the component infiltration technique is used. This is normally carried out using epoxy resin. This is done to fill the porous area without affecting the surface finish. For a successful infiltration, the temperature in the infiltration chamber must be slightly above the melting point of the infiltrating liquid. Design of experiment is the design of any information which has a variation. This can act as an important tool to optimize process parameters where multiple factors are involved. Also, this reduces the product and process variation along with the optimization of the process. In this experiment Taguchi technique [10] was adopted in order to reduce the number of trials. Taguchi method is applied in the early stages of product development for the process to be more effective. This method also enables us to consider various process parameters without much experimentation. As DMLS is an expensive method, such an orthogonal array has to be selected which has minimum number of trials and hence modified L8 array is considered in this experimental study. In order to find out the effect of process parameters, different levels have to be formulated. Here, sintering speed has four levels varying from 250 mm/s to 550 mm/s with an increment of 100 mm/s. All the other parameters have two levels and vary accordingly. As mentioned earlier, unsorted and shifted are the two types of hatch patterns selected. Hatch

spacing selected was 0.2 and 0.4. Part orientation selected was of 00 and 900. Four of the eight specimens manufactured were infiltrated. The developed orthogonal array is shown in Table I.
TABLE I DEVELOPED MODIFIED L8 ORTHOGONAL TABLE Trial no. 1 2 3 4 5 6 7 8 Sintering Speed (mm/s) 250 250 350 350 450 450 550 550 Hatch Spacing (mm) 0.25 0.35 0.25 0.35 0.25 0.35 0.25 0.35 Hatch Type unsorted shifted unsorted shifted shifted unsorted shifted unsorted Part Orientation (0) 0 90 90 0 90 0 0 90

Infiltration yes no no yes no yes yes no

III. TESTING PROCEDURE The 3D model of the required component is produced through Solid Works software. The file is then converted into ‘.stl’ format and fed into the machine which automatically converts the file into ‘.bdf’ format using RP Software. The bed surface is properly cleaned and homing is done. The process where the piston moves up and comes down in order for the new layer to be coated is called as homing. The temperature of the fabrication chamber is slightly below the melting point of the metal powder. This is to ensure that the laser beam does not require much energy in order to melt the powder. The process is done by moving the piston up and down and recoating with the powder. Eight different parts are produced for different parameters and they are taken to the EDM cutting machine [11] to remove the final test specimen from the base plate. Infiltration is done for four components where the epoxy resin is first applied on the components and then they are placed in the oven for 3 hours for the equal distribution of heat. Photograph of the wear testing DMLS sample is shown in Fig.1.

Fig. 1 DMLS Wear Testing Specimens

A wide variety of materials including metals, polymers, composites, ceramics, etc can be tested for friction and wear characteristics of dry or lubricated sliding contact using Pinon-Disc Tester. The test is performed by rotating a counterface test disc against a stationary test specimen pin. The normal load, rotational speed, and wear track diameter can be

251

International Journal of Engineering and Physical Sciences 6 2012

adjusted in accordance with ASTM G99 test standard. Wear testing was carried out in the pin on disc wear testing machine as per the standard. Fig. 2 shows the experimental setup of the wear testing machine to find out the wear value of the different DMLS components.

representation of the influencing factor on the wear testing results is shown in fig. 3.
TABLE III
ANOVA RESULTS

Process Parameter Sintering Speed(mm/s) Hatch Spacing(mm) Hatch Type Orientation Infiltration Error Total

Sum of Square 0.9237 0.0236 0.5891 3.9826 0.0236 0.3958 5.9383

F 4.67 0.12 2.98 0.13 0.12

P 0.163 0.763 0.227 0.046 0.763

% Contribution 15.55 0.397 9.92 67.06 0.397

Fig. 2 Experimental Setup for Wear Testing

The speed of the rotating disc was 300 revolutions per minute. The track diameter was 115 mm and the diameter of the rotating disc was 180 mm. The load applied was 3 kg and each component was subjected to wear for 5 minutes .The initial and the final weight of the components was taken. The loss in the weight was found out and tabulated which was further used for calculating the wear rate of the different component. The tabulated value of the wear is shown in Table II.
TABLE II WEAR CALCULATION OF DMLS SPECIMENS Initial Final Mass Weight Weight Removed Wear (mm3/m) (gm) (gm) (gm) 3.9238 3.9233 0.0005 1.08547 E-13 3.8797 3.8782 0.0015 3.25641 E-13 3.9326 3.9315 0.0011 2.38811 E-13 3.8457 3.845 0.0007 1.51965 E-13 3.6455 3.6446 0.0009 1.95384 E-13 3.3741 3.3728 0.0013 2.82221 E-13 3.5465 3.5455 0.001 2.17093 E-13 3.5864 3.5846 0.0018 3.90767 E-13

Fig. 3 Percentage Contribution of Factors on Wear

Specimen No. 1 2 3 4 5 6 7 8

Sliding wear value is lesser for components which are manufactured with 00 part orientation. This is because the specimen is loaded perpendicular to the built direction. Particle bonding from layer to layer will be lesser in specimens built with 900orientation where loading is parallel to the built direction. Also sintering speed has some influence as the laser moves with lesser speed, better sintering is achieved. V. CONCLUSIONS Experiments were carried out to find the influence of process parameter on the sliding wear of components manufactured by direct metal laser sintering using pin on disc wear testing machine. An orthogonal array of modified L8 with different process parameter combination was determined by Taguchi method to optimize the number of experiment. ANOVA analysis shows that part orientation have more influence on the sliding wear as compared to other process parameters. This is because load is applied parallel to the layer built. Results of sliding wear are very much useful to manufacture DMLS components for functional application where these are subjected to sliding wear. ACKNOWLEDGMENT The authors wish to acknowledge the support of Department of Science and Technology, Government of India for

IV. ANALYSIS OF RESULTS A. Sliding Wear Testing Results Statistical tool ANOVA was used to analyze the sliding wear results. Contribution of each selected factors on sliding wear of DMLS components were found out. The percentage contribution of influencing factors is shown in Table III. From the analysis it was found that part orientation influences more followed by sintering speed on the sliding wear of DMLS components. Other process parameter does not have much influence on the wear. Specimen 8 has maximum wear as it has large sintering and part orientation is 900. Specimen 1 has the least sliding wear due to low sintering speed and 00 part built orientation. The components manufactured with a combination of process parameters like lower values of sintering speed and part orientation as 00 gives lesser sliding wear. A graphical

252

International Journal of Engineering and Physical Sciences 6 2012

supporting the project with a research grant. We also thank Central Manufacturing Technology Institute (CMTI), Bangalore for their valuable support to carry out the tests. REFERENCES P.G. Maropoulos and D. Ceglarek, “Design verification and validation in product lifecycle,” CIRP Annals - Manufacturing Technology, vol. 59, no. 2, pp.740-759, 2010. H.H.Zhu, L.L.U, and J.Y.H. Fuh, “Development and characterization of direct metal laser sintering Cu-based metal powder,” Journal of Material Processing Technology, vol. 140, pp. 314-317, 2003. S.Rossi, F. Deflorian, and F.Venturini, “Improvement of surface finish and corrosion resistance of prototypes produced by DMLS,” Journal of Material Processing Technology, vol.148, pp. 301-309, 2002. A.Gaard, P. Krakhmalev, and J. Bergstrom, “Microstructural characterization and wear behavior of (Fe,Ni)–TiC MMC prepared by DMLS,” Journal of Alloys and Compounds, vol. 421, no.1-2, pp.166171, 2006. J.P.Tu, W. Rong, S.Y. Guo and Y.Z. Yang, “Dry sliding behaviour of in situ Cu-TiB2 nano-composites against the medium steel,” Journal of Wear Technology, vol. 255, pp. 832-835, 2003.

[1]

[2]

[3]

[4]

[5]

Y. Song, “Experimental study of the basic process mechanisms for direct laser sintering of low melting powder,” CIRP Annals, vol. 46, no. 1, pp. 127-130, 1997. [7] C.D.Naiju, M. Adithan, P. Radhakrishnan, “Evaluation of fatigue strength for the reliability of parts produced by direct metal laser sintering (DMLS),” International Journal of Rapid Manufacturing, vol.1, no.4, pp. 377-389, 2010. [8] C.D.Naiju, M. Adithan, P. Radhakrishnan, Y. Upendra Sravan, “Functional Testing of Direct Metal Laser Sintered (DMLS) Components for Automotive Application, “Advanced Materials Research,” vols. 383-390, pp. 6242-6246, 2012. [9] Dongdong. Gu, and Yifu. Shen, “Effects of dispersion technique and component ratio on densification and microstructure of multicomponent Cu-based metal powder in direct laser sintering,” Journal of Materials Processing Technology, vol.182, no.1-3, pp. 564-573, 2007. [10] N. Raghunath, and Pulak M. Pandey, “Improving accuracy through shrinkage modelling by using Taguchi method in selective laser sintering,” International Journal of Machine Tools and Manufacture, vol. 47, no.6, pp.985-995, 2007. [11] Jianfeng. Zhao, Yue. Li, Jianhun. Zhang, Chengye .Yu, and Youliang. Zhang, “Analysis of wear characteristics of an EDM electrode made by SLS,” Journal of Material Processing Technology, vol. 138, pp. 475478, 2003.

[6]

253

Similar Documents

Premium Essay

Pt1420 Unit 1 Question Paper

...1. How we can define the structure of the relation ,deleting relations and relating schemas ? a) DML(Data Manipulation Langauge) b) DDL(Data Definition Langauge) c) Probe d) Relational Schema Answer:b 2. Which one of the following delivers the capability to query material from the database and to insert tuples into, delete tuples from, and modify tuples in the database ? a) DML(Data Manipulation Langauge) b) DDL(Data Definition Langauge) c) Probe d) Relational Schema Answer:a 3. What command is used to create a table? a) DML b) DDL c) View d) Integrity constraint Answer:b 4. Which command is used to select the data’s from the table ? a) DML b) DDL c) View d) Integrity constraint Answer:a 5. The rudimentary data type char(n) is a _____ length character string and varchar(n) is _____ length character....

Words: 281 - Pages: 2

Premium Essay

Investigatory Proj.

...Chapter 2 - Database System Concepts and Architecture Data Models, Schemas and Instances A characteristic of the database approach is that it provides a level of data abstraction, by hiding details of data storage that are not needed by most users. A data model is a collection of concepts that can be used to describe the structure of a database. The model provides the necessary means to achieve the abstraction. The structure of a database is characterized by data types, relationships, and constraints that hold for the data. Models also include a set of operations for specifying retrievals and updates. Data models are changing to include concepts to specify the behaviour of the database application. This allows designers to specify a set of user defined operations that are allowed. Categories of Data Models Data models can be categorized in multiple ways. • High level/conceptual data models – provide concepts close to the way users perceive the data. • Physical data models – provide concepts that describe the details of how data is stored in the computer. These concepts are generally meant for the specialist, and not the end user. • Representational data models – provide concepts that may be understood by the end user but not far removed from the way data is organized. Conceptual data models use concepts such as entities, attributes and relationships. • Entity – represents a real world object or concept • Attribute - represents...

Words: 2961 - Pages: 12

Premium Essay

Database Environment

...Chapter 2 - Database System Concepts and Architecture Data Models, Schemas and Instances A characteristic of the database approach is that it provides a level of data abstraction, by hiding details of data storage that are not needed by most users. A data model is a collection of concepts that can be used to describe the structure of a database. The model provides the necessary means to achieve the abstraction. The structure of a database is characterized by data types, relationships, and constraints that hold for the data. Models also include a set of operations for specifying retrievals and updates. Data models are changing to include concepts to specify the behaviour of the database application. This allows designers to specify a set of user defined operations that are allowed. Categories of Data Models Data models can be categorized in multiple ways. • High level/conceptual data models – provide concepts close to the way users perceive the data. • Physical data models – provide concepts that describe the details of how data is stored in the computer. These concepts are generally meant for the specialist, and not the end user. • Representational data models – provide concepts that may be understood by the end user but not far removed from the way data is organized. Conceptual data models use concepts such as entities, attributes and relationships. • Entity – represents a real world object or concept • Attribute - represents...

Words: 2961 - Pages: 12

Premium Essay

Database 6th Ch1 and Ch2

...Chapter 1 Databases and Database Users Review Questions 1.1. Define the following terms: data, database, DBMS, database system, database catalog, program-data independence, user view, DBA, end user, canned transaction, deductive database system, persistent object, meta-data, and transaction-processing application. Answer: Data: Facts that can be recorded and that have implicit meaning Database: Collection of related data DBMS: Collection of programs that enables users to create and maintain a database (Software) Database system: database and DBMS software together Database catalog: structure of data files is stored Program-data independence: property that properties that DBMS access programs do not require such changes in most cases. The structure of data files is stored in the DBMS catalog separately from the access programs. User view: DBA: assisted by a staff that carries out these functions End user: the people whose jobs require access to the database for querying, updating, and generating reports; the database primarily exists for their use Canned transaction: that have been carefully programmed and tested Deductive database system: database systems provide capabilities for defining deduction rules for inferencing new information from the stored database facts Persistent object: Meta-data: The information stored in the catalog Transaction-processing application: 1.2. What four main types of actions involve databases? Briefly discuss each. Answer:...

Words: 1273 - Pages: 6

Free Essay

Database Hw2

...types, relationships, user operations, and constraints. External Schema -- External Schema describes the part of the database that a particular user group is interested in and hides the rest of the database from that user group. Data Independence – the capacity to change the schema at one level of a database system without having to change the schema at the next higher level. DDL – DDL or Data Definition Language is used to specify conceptual and internal schemas for the database and mappings. DML – DML or Data Manipulation Language as the name suggests is used for typical manipulations include retrieval, insertion, deletion, and modification of the data. SDL –The storage structures and access methods used by database system are specified by a set of definition in a special type of DDL called data storage-definition language. VDL – VDL or View Definition Language is used to specify user views and their mappings to the conceptual schema. Query Language -- a high-level DML used in a stand-alone...

Words: 778 - Pages: 4

Premium Essay

Nt1330 Unit 3 Assignment 1

...2.3 Answer: Major difference is the frequency of they get change. Database schema changes very rare when a new object has been added or deleted or any master detail /lookup relation has been setup between objects. However, database set gets updated very frequently on update on every DML on the record of any objects in system. 1. The skeleton of the database, their association with the different objects will be defined by Database Schema. Basically, it is the overall design describing the database to give the logical view of the objects present in application and the relationship among them. 2. At a particular time, database state defines the content of the database. 2.5 Answer: As the name suggest, physical data is independent of logical data. Anything...

Words: 646 - Pages: 3

Premium Essay

Db Iv - Oracle 11g V2 - Final Examination -Chapters 10 and 11 Student Version-Completed

...Multiple Choice Identify the choice that best completes the statement or answers the question. __A__ 1. All of the following would cause a trigger to fire, except ____. a. | BEFORE | c. | DELETE | b. | INSERT | d. | UPDATE | __A__ 2. Which of the following indicates that the trigger is fired only once, regardless of the number of rows affected by the DML statement? a. | Statement level | c. | DML level | b. | Event level | d. | Row level | __B__ 3. Which of the following statements is correct? a. | If multiple triggers exist on a table, the order in which the triggers will be fired can be set. | b. | A BEFORE statement level trigger will fire before a BEFORE row level trigger. | c. | If you have two statement level triggers, the order in which they are fired is dependent on the order in which they were written. | d. | Only one trigger can be constructed per table. | __D__ 4. Row level options are only applicable for ____ events. a. | CREATE | c. | DECLARE | b. | INSERT | d. | UPDATE and DELETE | __A__ 5. The default timing of a trigger is ____. a. | statement level | c. | row level | b. | system level | d. | header level | __A__ 6. Which of the following events will cause the trigger to fire? AFTER UPDATE OF orderplaced ON bb_basket a. | INSERT | c. | DELETE | b. | UPDATE | d. | AFTER | __D__ 7. CURSOR basketitem_curIS SELECT idproduct, quantity, option1 FROM bb_basketitem WHERE idbasket = :NEW.idbasket; ...

Words: 1769 - Pages: 8

Premium Essay

Steve Jobs

...written answers in groups and may ask you to present your group’s collective responses to the class. Due to some particular circumstances, if you are not able to attend a tutorial session, make sure to: a) let your tutor know asap the reason(s) you missed the class by email; b) submit your answers to the tutorial questions by its due date electronically using Moodle. Before attempting the following tutorial activities, you need to learn this week’s lecture slides. To gain more understanding of the topics covered in this week review Chapters: Chapters: 8.5, 7.2.7, 3.2.2 and 3.3 of your textbook. ASSESSABLE TASKS OF THE WEEK Objectives: * Review DDL and DML statements * Investigate views, indexes, data integrity and data security Activities: 1. Discuss the difference between DDL and DML. DDL Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples: * CREATE – to create objects in the database * ALTER –...

Words: 889 - Pages: 4

Premium Essay

Sql Fundamentals

...SQL Fundamentals The Structured Query Language (SQL) comprises one of the fundamental building blocks of modern database architecture. SQL defines the methods used to create and manipulate relational databases on all major platforms. At first glance, the language may seem intimidating and complex but it's really not all that bad. In a series of articles over the next few weeks we'll explore the inner workings of SQL together. By the time we're through, you'll have the fundamental knowledge you need to go out there and start working with databases! This week, our first article in the SQL series provides an introduction to the basic concepts behind SQL and we'll take a brief look at some of the main commands used to create and modify databases. Throughout this article, please keep our goal in mind: we're trying to get the "big picture" of SQL -- not a mastery of the individual commands. We'll provide a few examples for illustrative purposes and explain the theory behind them, but don't feel frustrated if you can't write your own SQL commands after reading this article. We'll cover each of the major commands in detail in future weekly installments. If you'd like a reminder in your e-mail inbox each week when the next article is posted, please take a moment and subscribe to our newsletter. By the way, the correct pronunciation of SQL is a contentious issue within the database community. In their SQL standard, the American National Standards Institute declared that the official...

Words: 1859 - Pages: 8

Premium Essay

Test

...1. Explain DML, DDL, DCL and TCL statements with examples? Answer: DDL Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples: * CREATE - to create objects in the database * ALTER - alters the structure of the database * DROP - delete objects from the database * TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed * COMMENT - add comments to the data dictionary * RENAME - rename an object DML Data Manipulation Language (DML) statements are used for managing data within schema objects. Some examples: * SELECT - retrieve data from the a database * INSERT - insert data into a table * UPDATE - updates existing data within a table * DELETE - deletes all records from a table, the space for the records remain * MERGE - UPSERT operation (insert or update) * CALL - call a PL/SQL or Java subprogram * EXPLAIN PLAN - explain access path to data * LOCK TABLE - control concurrency DCL DCL is abbreviation of Data Control Language. It is used to create roles, permissions, and referential integrity as well it is used to control access to database by securing it. * GRANT - gives user's access privileges to database * REVOKE - withdraw access privileges given with the GRANT command TCL Transaction Control (TCL) statements are used to manage the changes made by DML statements. It allows...

Words: 2240 - Pages: 9

Premium Essay

Review Questions: Chapter 1

...Review Questions: Chapter 1 1.1. Define the following terms: data, database, DBMS, database system, database catalog, program-data independence, user view, DBA, end user, canned transaction, deductive database system, persistent object, meta-data, and transaction-processing application. • Data – known facts that can be recorded and that have implicit meaning. • Database – a collection of related data with an implicit meaning. • DBMS – a collection of programs that enables users to create and maintain a database • Database system – not only contains the database itself bit also a complete definition or description of the database structure and constrains. • Database catalog – the information about the database structure is stored in the Database Catalog which contains the structure of each file, the type and storage format of each data item, and various constrains of the data. • Program-Data Independence – DBMS access programs do not require changes in all programs due to the change in the structure of a file because the structure of data files is stored in the DBMS catalog separately from the access programs. • User View – a database typically has many users, and each of whom may require a different perspective or view of the database. A view may be a subset of the database or it may contain virtual data the is derived from the database files but is not explicitly stored. • DBA – a database administrator (short form DBA) is a person...

Words: 2493 - Pages: 10

Premium Essay

Database

...' • View of Data • Data Models Chapter 1: Introduction $  $  • Purpose of Database Systems • Data Definition Language • Data Manipulation Language • Transaction Management & ' & • Storage Management • Database Administrator • Database Users • Overall System Structure 1.1 Silberschatz, Korth and Sudarshan c 1997 Database Systems Concepts Database Management System (DBMS) • Collection of interrelated data • Set of programs to access the data • DBMS contains information about a particular enterprise • DBMS provides an environment that it both convenient and efficient to use Database Systems Concepts 1.2 Silberschatz, Korth and Sudarshan c 1997 ' & ' & Purpose of Database Systems $  $  Database management systems were developed to handle the following difficulties of typical file-processing systems supported by conventional operating systems. • Data redundancy and inconsistency • Difficulty in accessing data • Data isolation – multiple files and formats • Integrity problems • Atomicity of updates • Concurrent access by multiple users • Security problems Database Systems Concepts 1.3 Silberschatz, Korth and Sudarshan c 1997 View of Data An architecture for a database system view level view 1 view 2 … view n logical level physical level Database Systems Concepts 1.4 Silberschatz, Korth and Sudarshan c 1997 ' & ' & Levels of Abstraction $  $  • Physical level: describes how a record (e.g., customer) is stored. • Logical level: describes data stored...

Words: 1023 - Pages: 5

Premium Essay

Data Base Concepts

...Jonathan Hindman PT2520 Chapter 4 10/18/13 Cardinality: Cardinality refers to the number of allowed instances of a relationship. In the usual cardinality of one to many, for instance, each record on the one side can have zero to any number of records on the many side. Cardinality can be more specific however. Each patron at a library can have only 20 items checked out at once. This has a cardinality of 0 to 20. Composite keys: In database design, a compound key is a key that consists of 2 or more attributes that uniquely identify an entity occurrence. Each attribute that makes up the compound key is a simple key in its own right. Crow’s feet notation: A type of notation for entity relationships in entity relation diagrams that depicts the many side of a relationship with a three-pronged end called a “crows foot.” This type of notation provides more information about the cardinality of a relationship than the arrow notation for relationships. Domain entities: Those database entities that relate directly to the business problem under consideration. Entity relation diagrams: A diagram that shows entities, their attributes, and the relationships among them. Linking entity: An entity used to resolve a many-to-many relationship into two one-to-many relationships. Logical entity: The design of a database without regard to the physical implementation of the database. Lookup entity: An entity used to store lookup values such as state names or zip codes. Maximum cardinality:...

Words: 1477 - Pages: 6

Premium Essay

Accounting Control

...ACCT 402 Check Figures from Publisher – 15th Edition (assigned problems in bold) Chapter 4. Job Costing 4-16 Job costing a c e g h k l n o p q r s u Process costing b d f i j m t 4-17 1. B 180% A 190% 2. A $127,000 N $124,000 3. N underallocated $145,000 4-18 1. B $50 A $47 2a. L $188,926 M $221,720 2b. L $186,166 M $218,600 4-19 1. $24 per mh 2. $4,080,000 3. overallocated $30,000 4-20 1. M $36 A 180% 2. $99,000 3. M $120,000 under; A $(260,000) over 4-21 1. 260% 2. 400% 3. TC $32,400; BP $36,000 4-22 1. 2Q $74; 3Q $99 2. 2Q $84; 3Q $84. 3. 2Q $109.20; 3Q $109.20 4-23 1. $22 per dlh 2. dr. WIP Control $4,664,000 (this would be the amount for the year) 3. cr. COGS $14,000 4-24 (Note: skip part 1) 2. (11) dr. MOH Allocated $2,080; cr. MOH Control $1,950; cr. COGS $130 4-25 8. dr. MOH Allocated $215,800; cr. MOH Control $202,900; cr. COGS $12,900 4-26 Skip part 1. 3. dr. MOH Allocated $93; dr. CGS $1; cr. MOH Control $94 4. $115 GM 4-27 1. M1 $561,000 M2 $419,000 2. $510 3. dr. FG Control $561,000 cr. WIP Control $561,000 4. $419,000 dr. balance 4-28 1. (a) $53; $48 (b) $53; $45 (c) $60; $45 3. (a) $18,685 (b) $18,130 (c) $19,425 4-29 1a. D: $25 I: $14 1b. D: $25 I: $15 1c. D: $26 I: $15 3a. $3,081 2b. $3,160 2c. $3,239 4-30 1. 50% 2. underallocated $3,000 ...

Words: 8482 - Pages: 34

Free Essay

Database

...I bought a book from crossword; he packed the book and added two bookmarks into my pack. A thought came to my mind. Why do I need a bookmark? I can easily memorize the page number and the next time resume from the same page when I resume reading, or read them all over to reach to the point where I stopped reading. But not all have a blessed memory; moreover, there are better things to remember, my grandpa would rather bookmark and rely on it to help him resume reading. It’s a kind of simple index, isn’t it? This article focuses on how MS SQL Server uses indexes to read and write data. Data is arranged by SQL Server in the form of extents and pages. Each extent is of size 64 KB, having 8 pages of 8KB sizes. An extent may have data from multiple or same table, but each page holds data from a single table only. Logically, data is stored in record sets in the table. We have fields (columns) identifying the type of data contained in each of the record sets. A table is nothing but a collection of record sets; by default, rows are stored in the form of heaps unless a clustered index has been defined on the table, in which case, record sets are sorted and stored on the clustered index. The heaps structure is a simple arrangement where the inserted record is stored in the next available space on the table page. Heaps seem a great option when the motive is simply storing data, but when data retrieval steps in, this option back fires. An index acts as a fire fighter in this scenario. Indexes...

Words: 433 - Pages: 2