Free Essay

Unit 2 Research Asignment 2

In: Business and Management

Submitted By johndoughboy
Words 474
Pages 2
Unit 3 Research Assignment

I’d say that the SQL Server database-naming convention makes the most sense to me. The database name accurately reflects the database content and all database names must be prefixed with the originating components acronym. The file names match the database name and the table names should accurately reflect the table’s content and function. Each column name must be unique within its table. Guidelines and best practices should be followed as a general rule, but it is understood that exception situations may exist. Developers must be prepared to provide a justification for any exceptions. There are no right and wrong answers for naming conventions as far as I am concerned. It’s all down to factors such as existing naming conventions in your applications and personal preference. I think the most important rule to adhere to is to be consistent. People may argue about whether to have underscores in object names or whether you should have proper case but it doesn't really matter as long as everything adheres to the same set of rules. If you have an existing set of objects then I'd suggest trying to match what is already in place. Of course, it’s also good to ensure names are logical!

Also called an entity-relationship (ER) diagram, a graphical representation of entities and their relationships to each other, typically used in computing in regard to the organization of data within databases or information systems. An entity is a piece of data-an object or concept about which data is stored.
A relationship is how the data is shared between entities. There are three types of relationships between entities:
1. One-to-One
One instance of an entity (A) is associated with one other instance of another entity (B). For example, in a database of employees, each employee name (A) is associated with only one social security number (B).

2. One-to-Many
One instance of an entity (A) is associated with zero, one or many instances of another entity (B), but for one instance of entity B there is only one instance of entity A. For example, for a company with all employees working in one building, the building name (A) is associated with many different employees (B), but those employees all share the same singular association with entity A.

3. Many-to-Many
One instance of an entity (A) is associated with one, zero or many instances of another entity (B), and one instance of entity B is associated with one, zero or many instances of entity A. For example, for a company in which all of its employees work on multiple projects, each instance of an employee (A) is associated with many instances of a project (B), and at the same time, each instance of a project (B) has multiple employees (A) associated with it.

Similar Documents

Premium Essay

La from

...WGU- SST1 USE THESE SUBMITTED AND ACCEPTED ASIGNMENTS TO HELP YOU DO YOUR OWN WORK AND CHECK YOUR ANSWERS/USE THIS OUTLINE. I COMPLETED 67 CU'S AT WGU IN 1 TERM USING THESE ASSIGNMENTS. DO NOT PLAGERIZE, WGU USES TURNITIN TO MONITOR PLAGARISM, THESE ARE TO BE USED AS GUIDES FOR YOUTR OWN WORK ONLY. I WORKED HARD TO COMPLETE THEM. WGU- ATTACHEMENTS PROVIDED WITH FULL TASKS. SST1: TASK 1, 2 Social Science SST1 Task 1 Words like country, nation, state, and even nation-state are used to define social, cultural and political relationships in the United States and around the world. There are many defining characteristics that allow countries and groups of countries to understand each other, and in some cases, for unions. The purpose of this essay is to briefly discuss nations, states, and nation states, how the United States constitutes a nation state, and the European Union. A nation is a union of people who share social similarities such as language, beliefs, culture, possibly religion, and values. A state is defined by laws and politics, uniting people by geography, population, and government. The modern nation-state is more of a combination of nation and state and is defined as “a single or multiple nationalities joined together in a formal political union” (What is a Nation-State, N.D.). Basically, a nation-state makes the general regulations for large decisions such as what language the general population will speak, what form of currency will be accepted,......

Words: 1663 - Pages: 7

Premium Essay

Hnd Business Unit 3

...Asignment Brief Orgin Assessment Brief Distribution date: w/c 20/05/2013 Submission deadline: 29/07/2013 Result and feedback date: 4 weeks from the deadline Assessment Brief Unit Details: Unit Code: Organisations and Behaviour (Unit 3) Programme Name: BTEC Higher National Diploma (HND) in Business Awarding body: Edexcel Unit Level (QCF): QCF-4 Academic term: May - July 2013 Course Details | Course Name | BTEC Higher National Diploma (HND) in Business | Unit number | 3 | Unit Name | Organisations and Behaviour | Credit Value | 15 | Lecturer | Antonios/Hillary/Ousman/Raazia/Sunday/Victor | Hand Out/Issue Date | w/c 20.05.2013 | Submission Deadline | 29 July 2013 | Introduction Students are expected to write a report covering the points listed under each of the learning outcomes. To achieve a pass in this unit, you must successfully address all of the assessment criteria listed (P1-P12). We expect all students to achieve their potentials and would encourage you to address all pass criteria, merit and distinction descriptors. For certain tasks students are encouraged to use real life examples and/or the scenario provided below. There is not set format for this report. However, like all business report you should have an introduction and a conclusion. Scenarios A Coca-Cola Great Britain People often assume that The Coca-Cola Company bottles and distributes its own beverages. For the most part, it does not. The Company's primary business consists of......

Words: 2757 - Pages: 12

Free Essay

A. Dominant : Cheek Freckles Recessive:

...KENYATTA UNIVERSITY ODeL NAIROBI CENTRE ------------------------------------------------- STUDENT ASIGNMENT SUBMISSION FORM Student Name: HARRISON MBATO MUNYAO Registration Number: E156/Ol/8000/2013 Unit Code: ISC 300 Unit Title: RESEARCH METHODS Lecture’s Name: MR. NAMANDE Student’s Signature: _______________________________________ Coordinator’s Signature: ____________________________________ Rubber Stamp: _________________________ Date: _________________________________ CONCEPT PAPER KENYATTA UNIVERSITY NAME: HARRISON MBATO MUNYAO REG. NO.: E 156/OC/8000/2013 TEL: 0721573204/0735902001 EMAIL: SCHOOL: EDUCATION DEPT: LIBARRY AND INFORMATION SCIENCE UNIT CODE: UNIT NAME: CONCEPT PAPER TITLE: CHALLENGE FACED IN INFORMATION CENTRES IN PRESERVATION AND CONSERVATION OF INFORMATION MATERIALS INTRODUCTION In Kenya, information centers population known as registry was established by an act of parliament Cap.19 of 1965 and Cap.14 Laws of Kenya. There are also other circulars and general letters that govern registries and records or documents in Public offices. These rules and regulations range from creation, accumulation, destruction of valueless records to permanent preservation of records with enduring value. These information centers (registries) have been cascaded up to divisional level, currently known as sub-ward; administratively headed by Assistant County Commissioners formerly known as District Officers...

Words: 3294 - Pages: 14