Jay-Star Incorporated is a small machine shop located in Lexington, Kentucky. There are only seven employees that actually work on the shop floor. Jay-Star produces metal core and distributes that core to various aerospace manufacturers. There are three different types of core that Jay-Star produces: Square Cell, Hexagonal Cell, and Beneflex Cell. Each of them can be produced using different materials from various shipping companies. The employees take these materials from the shipping company, produce the product, and then deliver the finished product to the aerospace manufacturer (customer). For a small company, Jay-Star keeps a very hectic schedule. Any miscalculation on shipping dates could be disastrous for the order …show more content…
The last three tables are probably the most important in the database. The Orders, Product, and Order Line Items tables connect it all together. They show how each customer gets each product, how the product gets there, and when it is supposed to arrive. They also show how much each product costs. The requirements of creating this database are to define the primary keys for each table and to show what order each table should be placed. The primary keys are simple. They are usually the number that defines each row in the table (i.e. EMPLOYEE_ID). It can either be part of the actual record itself , or it can be an artificial field (one that has no meaning other than being an identifier of the record) (Data Analytics Software). The order in which each table is created is based upon their relationships. The Customer, Shipper, and Employee tables all have a one-to-many relationship with the Orders table, so therefore, they are created first. A one-to-many relationship, in this example, is where one customer, shipper, or employee is associated with many orders (Pratt, Last p. 26).
The first step in creating the database was defining each entity. Each entity would represent its own table. The entities that were established were Customer, Shippers, Employees, Orders, and Products. The next step was to determine a unique identifier for each entity. Identifiers, such as personal identification numbers, worker numbers, and license numbers, are used for identifying individual
Step 2. Data Analysis: The data will be analyzed to determine database modeling. Step 3. Database normalization: Fields and
* As explained throughout this course, entity relationship modeling is a critical element of database design. If the database is not properly modeled, it is unlikely that the database will be properly developed. Using this knowledge, explain the key reasons why entity relationship modeling is important, and determine at least (1) way in which it impacts the overall development of the database.
# 6: Given a physical database containing tables and relationships and business requirements, create the necessary queries.
What is the probability that a randomly selected order will require more than six days?
A relational database is a database that consists of a collection of tables with columns showing entities, and rows showing data. This type of database uses a primary key and foreign key. The foreign key in another table will point to the primary key of a table, and this is how tables can relate to each other. This permits for one-to-one, one-to-many, and many-to-many relationship between the data. An advantage of relational databases includes the ease of adding or modifying new tables and entities without needing to change the structure of the database already in place. Relational database have many features, including indexing, setting data type, and setting validation tests, all these help to ensure data integrity.
2- Order Table - The Order Table is used to record information pertinent to each Order placed with a given store. Each order will have one or more entries in the Order Line Table associated with it.
Prior to designing my database, I will have a clear understanding of the data. This will allow me to determine the purpose of the database. Once all information is
There will be three main entities in the system; the students, the instructors and the courses. The
First our team will talk about how Microsoft Access was used to create these tables by Huffman Trucking Database. Then how we used the tables with made up information to be tested on. Then on how we used forms in the maintenance database system. While the creation of relationships and normalization is explained in the process of using queries to search the database (University of Phoenix, 2007).
When it comes to the data model, there exists a relationship that has three different representations for the reason that database requires the relationship between the tables. It goes hand-in-hand with one another without the relationship the tables would have no purpose. The information cannot be repetitive in order for the each table to work and provide the specific database that is related to the information. In different ways the tables in the Huffman Trucking Fleet Truck database
One of the main components of a database is characters. Characters are letters, numbers and punctuation marks. You are using characters when you are typing a sentence for example. Another main component would be fields. Fields separate data in defined fields. When data is being entered even if you don’t have an answer for all fields a space is still left but it would be blank. If you have ever seen an excel spreadsheet that would give you an idea of how data is lined out into different fields. Records are a main database component as well. Records are a group of fields that are about one thing. An example would be social security numbers in a database of patients. Each patient would have a social security number and each social security number is in a field. That field would have the same information which is that patients social security number even though every ones is different and there would be many listed depending on how many patients was in the database. Gartee, R. (2011).
Numerous large businesses that are operating today were once started as small businesses. A new business is established to create a good or service that no other businesses have ever created or simply a product of higher quality than existing products, with the purpose of meeting customers’ needs and earning profits. Due to the technological advances at the present time, starting and operating a new business is less laborious. Nevertheless, would-be entrepreneurs should be familiar with the proper approaches to start their businesses.
M&L Manufacturing makes various components for printers and copiers. The company supplies these items to a major manufacturer. The company also distributes these and similar items to office supply stores and computer stores as replacement parts for printers and desktop copiers. In all, the company manufactures about 20 different items to distribute. The two markets (the major manufacturer and the replacement market) require somewhat different handling. Product for the major manufacturer can be shipped in bulk. However, the products for the retail segment must be packaged individually which requires additional handling and expense. Instead of using forecasting for production planning the operations manager decides which
* Intensive planning of daily shipment should be done (calculation of exact amount of goods to be shipped and arrangement of the goods)