Free Samples
7003ICT Database Management
.cms-body-content table{width:100%!important;} #subhidecontent{ position: relative;
overflow-x: auto;
width: 100%;}
7003ICT Database Management
0 Download4 Pages / 757 Words
Course Code: 7003ICT
University: Griffith University
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: Australia
Question:
Correct identification of all the entities. Entity names should follow the standard conventions, i.e., they should be singular nouns and written in CAPITAL letters, or at least the first letter is CAPITAL.
Correct identification of all the attributes for each of the entities 8 marks Correct identification of all the relationships with appropriate cardinality and modality. If the cardinality and/or modality are not clear from the assignment specification, the assumptions made should be clearly stated.
Introduction of composite/bridge entity to represent many-to-many relationships. The relationship between language and country and that between driver and language should be identified as many-to-many.
Correct representation of strong and weak relationships (using solid and dashed line)
Correct identification of all the primary keys and foreign keys. The primary keys should be underlined and foreign keys should be italic.
Answer:
Assumptions
While developing the databases schema for the organization following assumptions are made in order to make the proposed database consistent one. Following are list of the assumptions;
Each of the productID, storeID, employeeID, inventoryID, deprtmentID will be unique for every new entry as they will be used as the primary as well as foreign keys among the tables.
A customer can be related to multiple number of stores as they can buy products from different stores situated at different locations.
Inventories will have a minimum reorder level for different products it stores. This is important in order to maintain the availability of the products in the stores.
The pickup date of the products by the customers should not be ago than the arrival date of the product at the store.
Each employee can work under a certain department of a specific store.
For a specific store there will be only one store manager and similarly there will be only one supervisor for the specific department at a store.
The payslips for the employees in different stores will be generated fortnightly. Hence time between two payslips of an employee.
The store manager should be an employee of the store.
The order for the product cannot be placed which is not available in the inventory or under the reorder level.
As any customer can order more than one product or multiple number of same products thus the order table may contain multiple similar productsIDs related to a specific order and specific cutomerID.
Normalisation
In order to normalize the tables determined for the database of the BigM stores the following instructions needs to considered
In order to make a table to 1 NF
For 2NF
The tables of the data base must be in the first normal form
All of the non-key attributes in the tables must be fully functionally dependent on primary key of the table.
And for 3NF
It is important that every non-prime attribute in the tables are non-transitively dependent on the key of the table.
For the store table
The table consisted of the of the following
1NF
storeid
storername
phonenumber
fax
city
street_address
state
Postcode
2NF
3NF
For the Customer table
customernumber
firstname
lastname
customeraddress
phonenumber
Postaladdress
2NF
For the order table
1NF
OrderID
Customernumber
Productid
Storeid
OrderDate
Pickupdate
2NF
For the Product table
1NF
productnumber
producttype
productdescription
productbrand
productsize
productprice
Productcategory
2NF
For the employee table
employeeid
firstname
lastname
Storeid
EmployeeAddress
Inventory table
inventoryid
productnumber
last_update
Storeid
Relational Database Schema
Store table
storeid
Integer
Primary key
storername
Varchar (15)
phonenumber
Integer
fax
Integer
Varchar (50)
city
Varchar (20)
street_address
Varchar (25)
state
Varchar (15)
Postcode
Varchar (10)
Inventory table
inventoryid
Integer
Primary key
productnumber
Varchar (15)
last_update
Date
Storeid
Integer
Employee Table
employeeid
Integer
Primary key
firstname
Varchar (15)
lastname
Varchar (15)
EmployeeAddress
Varchar (100)
StoreID
Integer
Foreign key
Reference table Store table
Product table
productnumber
Integer
Primary key
producttype
Varchar (15)
productdescription
Varchar (70)
productbrand
Varchar (25)
productsize
Integer
productprice
Integer
productcategory
Varchar (15)
Order table
OrderID
Integer
Primary key
Customernumber
Integer
Foreign key
Customer table
Productid
Integer
Storeid
Integer
OrderDate
Date
Pickupdate
Date
Customer table
customernumber
Integer
firstname
Varchar (25)
lastname
Varchar (25)
State
Varchar (15)
City
Varchar (10)
street_address
Varchar (50)
Postcode
Varchar (25)
Department table
DepartmentID
Integer
Departmentname
Text
Storeid
Integer
ManagerID
Integer
Foreign key
Reference EmployeeID (employee table )
References
Coronel, C. and Morris, S., 2016. Database systems: design, implementation, & management. Cengage Learning.
Davie, B., Koponen, T., Pettit, J., Pfaff, B., Casado, M., Gude, N., Padmanabhan, A., Petty, T., Duda, K. and Chanda, A., 2017. A database approach to sdn control plane design. ACM SIGCOMM Computer Communication Review, 47(1), pp.15-26.
Elmasri, R. and Navathe, S., 2016. Fundamentals of database systems. London: Pearson.
Harrington, J.L., 2016. Relational database design and implementation. Morgan Kaufmann.
Jukic, N., Vrbsky, S. and Nestorov, S., 2016. Database systems: Introduction to databases and data warehouses. Prospect Press.
Köhler, H. and Link, S., 2018. SQL schema design: foundations, normal forms, and normalization. Information Systems, 76, pp.88-113.
Free Membership to World’s Largest Sample Bank
To View this & another 50000+ free samples. Please put
your valid email id.
Yes, alert me for offers and important updates
Submit
Download Sample Now
Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.
UploadUnique Document
DocumentUnder Evaluation
Get Moneyinto Your Wallet
Total 4 pages
PAY 2 USD TO DOWNLOAD
*The content must not be available online or in our existing Database to qualify as
unique.
Cite This Work
To export a reference to this article please select a referencing stye below:
APA
MLA
Harvard
OSCOLA
Vancouver
My Assignment Help. (2021). Database Management. Retrieved from https://myassignmenthelp.com/free-samples/7003ict-database-management/databases-and-data-warehouses.html.
“Database Management.” My Assignment Help, 2021, https://myassignmenthelp.com/free-samples/7003ict-database-management/databases-and-data-warehouses.html.
My Assignment Help (2021) Database Management [Online]. Available from: https://myassignmenthelp.com/free-samples/7003ict-database-management/databases-and-data-warehouses.html[Accessed 18 December 2021].
My Assignment Help. ‘Database Management’ (My Assignment Help, 2021)
My Assignment Help. Database Management [Internet]. My Assignment Help. 2021 [cited 18 December 2021]. Available from: https://myassignmenthelp.com/free-samples/7003ict-database-management/databases-and-data-warehouses.html.
×
.close{position: absolute;right: 5px;z-index: 999;opacity: 1;color: #ff8b00;}
×
Thank you for your interest
The respective sample has been mail to your register email id
×
CONGRATS!
$20 Credited
successfully in your wallet.
* $5 to be used on order value more than $50. Valid for
only 1
month.
Account created successfully!
We have sent login details on your registered email.
User:
Password:
The law assignment help experts at MyAssignmenthelp.com are real subject matter experts and have helped millions of students in Australia with top-notch academic assignment assistance. They have obtained their law degrees from the top-rated law schools in the country and possess in-depth knowledge of the law to help you create 100% accurate and plagiarism-free assignment for all your assessments. Each expert is highly skilled in catering to the students’ needs with the utmost efficiency.
Latest Management Samples
div#loaddata .card img {max-width: 100%;
}
MPM755 Building Success In Commerce
Download :
0 | Pages :
9
Course Code: MPM755
University: Deakin University
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: Australia
Answers:
Introduction
The process of developing a successful business entity requires a multidimensional analysis of several factors that relate to the internal and external environment in commerce. The areas covered in this current unit are essential in transforming the business perspective regarding the key commerce factors such as ethics, technology, culture, entrepreneurship, leadership, culture, and globalization (Nzelibe, 1996; Barza, 2…
Read
More
SNM660 Evidence Based Practice
Download :
0 | Pages :
8
Course Code: SNM660
University: The University Of Sheffield
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: United Kingdom
Answers:
Critical reflection on the objective, design, methodology and outcome of the research undertaken Assessment-I
Smoking and tobacco addiction is one of the few among the most basic general restorative issues, particularly to developed nations such as the UK. It has been represented that among all risk segments smoking is the fourth driving purpose behind infections and other several ailments like asthma, breathing and problems in the l…
Read
More
Tags:
Australia Maidstone Management Business management with marketing University of New South Wales Masters in Business Administration
BSBHRM513 Manage Workforce Planning
Download :
0 | Pages :
20
Course Code: BSBHRM513
University: Tafe NSW
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: Australia
Answer:
Task 1
1.0 Data on staff turnover and demographics
That includes the staffing information of JKL industries for the fiscal year of 2014-15, it can be said that the company is having problems related to employee turnover. For the role of Senior Manager in Sydney, the organization needs 4 managers; however, one manager is exiting. It will make one empty position which might hurt the decision making process. On the other hand, In Brisba…
Read
More
MKT2031 Issues In Small Business And Entrepreneurship
Download :
0 | Pages :
5
Course Code: MKT2031
University: University Of Northampton
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: United Kingdom
Answer:
Entrepreneurial ventures
Entrepreneurship is the capacity and willingness to develop, manage, and put in order operations of any business venture with an intention to make profits despite the risks that may be involved in such venture. Small and large businesses have a vital role to play in the overall performance of the economy. It is, therefore, necessary to consider the difference between entrepreneurial ventures, individual, and c…
Read
More
Tags:
Turkey Istanbul Management University of Employee Masters in Business Administration
MN506 System Management
Download :
0 | Pages :
7
Course Code: MN506
University: Melbourne Institute Of Technology
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: Australia
Answer:
Introduction
An operating system (OS) is defined as a system software that is installed in the systems for the management of the hardware along with the other software resources. Every computer system and mobile device requires an operating system for functioning and execution of operations. There is a great use of mobile devices such as tablets and Smartphones that has increased. One of the widely used and implemented operating syste…
Read
More
Tags:
Australia Cheltenham Computer Science Litigation and Dispute Management University of New South Wales Information Technology
Next