Functions and Features Data Modeling - Assignment

Added on - 21 Oct 2020

  • 12

    pages

  • 1313

    words

  • 14

    views

  • 0

    downloads

Showing pages 1 to 4 of 12 pages
Project-7
Table of Contents1. Discuss about the functions and features.................................................................................32. Describe:...................................................................................................................................43. Explain “Chasm Trap”.............................................................................................................54. Explain a “Fan Trap”................................................................................................................65. Discuss about the 1NF, 2NF and 3NF.....................................................................................6
1. Discuss about the functions and featuresData modeling approach:Data modeling approach is a process of documenting a complex system software designand understand their overall functionality by using the diagram. It has to be represent in the bestway to understand the flow of information. For Example- Entity relationship diagram is the bestexample to shows the relationships between the entities and their attributes in the databasesystem. A data modeler uses this model to view the same data and ensure that all the entities andrelationship, process and information flow must be identified.Keys:Key help to identify the any row of tables, and allows establishing relational between oneor more database tables.Primary key -It is a unique identifier.It does not contain the same value.Composite key-It has multiple attributes to the unique identify rows in DBMS table.Composite is any part of compound key can foreign.Primary Index-It provides the predictable and fast access to maintain the functionality of system.It is also defined as an ordered in data files which may generate form the filed wherecandidate key and unique value in every records.Time stamp:Time stamp is an important for keep maintain the records of information beingexchanged or created. Public key infrastructure is applied the concept on time stamps when TSAcombine with the hash and other information includes the authoritative time, At results generateddigitally with timstamp private key.
Types:User defined type:A user define type is derived the existing data type that can help to use the UDT forextend the built in type which already available. There are different type of user defined typesuch asReference typeIt is scalar type that commonly share the representation with one of built in data types. Italso shared for all types in hierarchy manner.Structure type-A structure type is based on the user defined data type that has formed a structure in the databasesystem. It can use the tables, columns, views etc.features:High performanceIndirect and direct useableUser defined functionsUser defined function is provided by the user of program and environment, in the contextwhere they usually assumption is that when the functions are built into the program andenvironment. In relational database management system, A user defined functions provide themechanism for extending the functionality of database server. SQL standard is mainlydistinguish between the table and scalar functions.For Example- Function with argument return no values.function without argument.Data types and their function.Character – this data type is accepts the strings which including Unicode.Boolean – it supports the storage of different values in the form of true and false. There isno parameter require for declaring.Integer- It consists of numeric values which store between2^ -31 and 2^31.
desklib-logo
You’re reading a preview
card-image

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Download This Document