ipl-logo

M1 Unit 3 Written Assignment

1098 Words5 Pages

Unit 3 Written Assignment
Terry J. King
University of the People

Abstract
Databases are an effective tool for a retail business, to help meet its needs and objectives, as outlined in its business strategy and the values that are contained within a company mission statement.
Efficiency is an important driver for a database, and this can be achieved by carefully considering the database relationships that are defined through the primary and foreign keys.
Keywords: Business, Information Technology, Database
Unit 3 Written Assignment
To continue from the previous paper on the topic of a retail business, the UK food retail Tesco plc., this paper will look in more detail into the structure and the functioning of a proposed database that would …show more content…

These business rules lay the foundation for the database. As established above, there are six key areas of interest that the database will focus on. The organization determines these rules and are significant as they determine the connectivity between tables.
In this database, I propose some rules that will determine the structure.
• One need the database must have been that a customer name must have an ID (a card number of the Clubcard loyalty program). This identification must be entirely numerical and will consist of an integer of 18 digits.
• Another rule is that every customer will have a total amount and items associated with the customer ID.
• A store number must be in four-digit integer form and will be connected to a daily sales figure
• Item must have a point of origin and be connected to a destination, to monitor environmental impact and efficiency
• Forecasting, to provide sales targets based on weekly, monthly, quarterly, and annual periods.

Include a word table that showcases your entities, attributes for each (with data types), relationships and cardinally …show more content…

We can conclude here that this reflects the organization's operations, and when the database is constructed to meet these needs, will facilitate the operation of the organization. This diagram shows this significance (Watt & Eng, 2014).
From the information planned in the previous table we can now visually represent the relationship between the data. As we can appreciate here the customer is central to the database structure, as the customer, and sales data is what drives the organization. We could also argue here that this is a direct reflection of the organization and how it operates. A fundamental aspect to consider when designing the database (Darwin, 2014).
Another central part of this is location as it be used to determine sales performance on items, to further enhance to efficiency and profitability of the retail business in question. As we can see from the diagram the structure, is defined through the primary and foreign keys that are visually determined in the diagram

Show More
Related
852 Words | 4 Pages

Joyce Balingit BIOL 196 - 1006 Instructor: Austin McKenna 30 October 2015 Writing Assignment #3 Part A In meiosis, the cell goes through the same stages as mitosis twice. The stages of Meiosis I are: prophase I, metaphase I, anaphase I, and telophase I.

Read More
100 Words | 1 Pages

Good Morning all, The confusion continues… Per the DOE, the Admin Supports are now required to the complete the Inpatient reporting class via TLC (RPT0-can be typed in the search field on the TLC page). Users will need to register and choose all of the classes associated with the registration before clicking on the submit button. Once they have completed all of the required classes and passed the assessment Epic security will be notified and access will be granted.

Read More
646 Words | 3 Pages

On Wednesday 10-14-15 at approximately 1700 hours I Officer Hildebrand and Sgt. Hard were advised by dispatch that Debra Vanblaricom was at the station asking to talk to an officer. Debra wished to report an assault on her granddaughter. We met with Debra in the Police Department to speak with her. Debra stated that she feared for her granddaughter 's safety.

Read More
205 Words | 1 Pages

I learned about my POC was that since I have converted the equation to exponential form, it made this problem a few steps easier now that the only thing that I need is to get t only; the only variable in the equation. The converted equation is (t-1)^2 lne = e^3; at first, Kirby thought that it was easy and try to help me, but in result, when Mr.Marshall came by, he told that "lne" can be cancel out because "lne" is equal to 1, so wouldn't make any changes in the equation at all. Next, I square root both side after he told me to cancel out the "lne" and got t-1= e^3. I added 1 to both side and I got t=

Read More
560 Words | 3 Pages

After it's been several days since your brow appointment, you may notice your goddess brows getting ruined by pesky little hairs. Now you still have a couple more days to survive until your next session, this guide will give you 6 tips to keep your eyebrows looking spiffy in between threading sessions. 1. Take a visual  As soon as you get off the chair at your brow bar, whip out your smartphone and take a bomb selfie. Now whether your post that on Instagram is none of our business, but that picture will be very useful for later when you are doing your brows or for showing your brow artist.

Read More
911 Words | 4 Pages

1.1. Creating objects & Right side panel – brief This panel is the main medium that is used to create ( ) objects, I can also modify ( ) and edit objects as well in addition I can alter different aspects in 3ds max as well. I could also alter the pivot point (gismo) and decide where it origin point is.

Read More
314 Words | 2 Pages

The data I will be collecting is from a primary source as the groups of Year 7’s and Year 10’s will be completing the practical where they will see how quick they can find the same five words in the three languages. It will also be discrete even though time is continuous so the results will be clearer. The data will then be recorded onto a table and after, put together on a data sheet using excel. I am using a sample as it makes the investigation fair and also means a range of unbiased results are created from it.

Read More
72 Words | 1 Pages

Dear helpdesk My name is hashimoto I want to ask something about TS and TM, please confirm the info below: Protocol number: CNTO136ARA3004 Study: JJ90061 Site: 081047 This study will use TS from Sep, MIFI and cable cannot be used in this site. I received a manual about how to set up WIFI. But I cannot understand it very clearly, could you let me know the details about how to do this?

Read More
415 Words | 2 Pages

My original copy of Assignment # 3: Sundus Alhaji- 150 Assignment 3 The Professor’s grading and feedback for Assignment #3: sundus_A3rubric (1) My revised copy of Assignment # 3: Revised Version A Reflection On My Writing Revision After looking at the rubric and analyzing my written assignment, I have noticed that I lack some of the information about ISU being connected to the Reiman Gardens as wells as its mission and vision. Therefore, I supported that missing portion in the fifth paragraph which now focuses beyond the factual descriptions of the organization in itself.

Read More
100 Words | 1 Pages

Has research experiences and currently working as a Quality Assurance Manager at SOLUT! , suggesting plenty of research experience. Good letters for highly recommended. 3 research presentation at local meetings and one at the national meeting. She had a family issue that prevented her going for graduate study, decided to get a job at company.

Read More
150 Words | 1 Pages

To summarize At’s such as captions, visual aids, and captions, allow students who are hearing impaired or death a chance to interact with text and function as independently as possible. With Hannah, who is 5 years old, i suggest that her teacher Ms.Martha start using closed captions when she shows the class videos and consider investing or requesting a FM system that best fits Hannah needs. However i was able to use a visual aid with Hannah that showed her how to wash her hand properly. The steps had both text and a visual with a simple 4 step instruction. Hannah was encouraged to ask questions before and try to follow as best she could on her own.

Read More
296 Words | 2 Pages

I asked Nikki how long has she been attending the school she goes to now. Nikki said that she has been at this school for two months. I asked Nikki what pronouns she would like everyone to use. She said he/him pronouns.

Read More
442 Words | 2 Pages

In developing a database, one of the first things one must know is how the database(DB) will be used within the organization. Seconda,y what type of data will be required to develop the database and how it will enhance productivity and reliability to the organization. All the information is gathered in the first phase of the database life cycle, which is planning. In the planning phase, you are gathering information on the need, cost and feasibility of the database within the organization. Also within this phase you would look to see if there are databases within the organization that can meet the requirements.

Read More
1680 Words | 7 Pages

Tesco is amongst the largest food retailers in the United Kingdom (U.K) with over 3,400 stores and staff amounting up to 310,000. Tesco operates predominately in Europe and America with their headquarters located in the U.K. Tesco has the greatest market share in the U.K dominating approximately 28% of the overall market at the end of 2017. However, there is a constant battle in the highly competitive U.K supermarket industry with the four major players being Tesco, Sainsbury, ASDA and Morrisons. In recent years, Tesco has had to change their business model as well as their services to stay a market leader and differ-entiate from the competition. To find the main sources of competitive advantage that Tesco has over its competitors an analysis of the structure of the industry should be under-taken (Porter, 1980).

Read More
764 Words | 4 Pages

ADMS 2511. Management Information System Section Q Raqib Ibrahim Prof. M.Zia ul Haq 215251754 Case Assignment 1 Question A i) Data items: Example of Data in Lululemon case is sales over $1 billion. Data item is a set of description which gives information but does not convey a meaning. ii) Information: As stated above the sales resulted in over $1 billion but actually the 10 percent of those sales were from the Internet store.

Read More

More about M1 Unit 3 Written Assignment

Related Topics

Open Document