Free Samples
SMB4102 Data And Information Management
.cms-body-content table{width:100%!important;} #subhidecontent{ position: relative;
overflow-x: auto;
width: 100%;}
SMB4102 Data And Information Management
0 Download6 Pages / 1,284 Words
Course Code: SMB4102
University: Asia Pacific International College
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: Australia
Questions:
1. Design and develop a database based on a real-life example2. Understand a database design as a critical element in achieving overall database objectives.3. Create tables and manipulate data using SQL queries
Answer:
Introduction
Chisholm institute of education offers over 250 certificate, diploma, advanced diploma, bachelor and graduate certificate course and is in need of a database. This report serves to detail the designing processes of the database that will hold records of all the courses offered, the subset courses and all the course information. The conceptual, logical and physical design of the database is well tabled in this report.
Conceptual design of the database
There are four real word entities identified; Chisholm university, the courses Chisholm offers, the subset of the courses offered by Chisholm and the information entailing the courses offered.
Chisholm university has very many courses it offers therefore the relationship is one to many(Healy & Conorozzo 2013). A course at Chisholm University has several course subsets and a course subset has so many course information.
Logical design of the database
According to (Teorey et.al 2011)
CourseID
Course Name
SubsetID
Subset Name
CourseID
Course Code
Course Name
Available online
Campuses
Length
Sample Study Units
Fee
Type
SubsetID
The logical design is in the third normalization form (Demba (2013). The first table is the course table which has the CourseID and Course Name, the CourseID is the primary key for the course table , the course name is uniquely identified by the CourseID.
The second table is the subset table which has three fields; SubsetID, Subset Name and CourseID. The subsetID is the primary key that uniquely identify a subset course. The CourseID is a foreign key.
The third table is the course information table which has nine fields; CourseCode, Course Name, Available online, Campuses, Length, Sample Study Units, Fee, Type and SubsetID. The CourseCode is the primary key and subsetID is the foreign key.
The primary key in the above design is in bold whereas the foreign key is italized.
Physical Design of the database
Sql queries for Creating the table
Query for creating Course table
CREATE TABLE Course ( CourseID int(255) NOT NULL, Course varChar(255) NOT NULL, PRIMARY KEY (CourseID), );
This query creates a table named Course with two fields; CourseID which is of type integer not null,of length 255 and the primary key and Course which is a variable character of length 255 characters.
Conversion in Microsoft Access
Query for table Subset
CREATE TABLE Subset ( SubsetID int(255) NOT NULL, Subset_Name varChar(255) NOT NULL, CourseID int(255), PRIMARY KEY (SubsetID), FOREIGN KEY (CourseID) REFERENCES Course(CourseID));
This query creates a table named Subset which has three fields; SubsetID which is a variable character of length 255 not null and is the primary key, Subset_Name which is a variable character of length 255 not null, CourseID is of type integer which is of length 255 and a foreign key from table Course (Chitkara et.al 2010).
Conversion in Microsoft Access
Query for creation of Course_information table
CREATE TABLE Course_information ( Course_code varChar(255) NOT NULL, Course_Name varChar(255) NOT NULL,
Available_online yes/no NOT NULL, Campuses varChar(255) NOT NULL,
Length varChar(255) NOT NULL, Sample_Study_Unit varChar(255) NOT NULL,
Fee currency(255) NOT NULL, Type varChar(255) NOT NULL, SubsetID int(255), PRIMARY KEY (Course_code), FOREIGN KEY (SubsetID) REFERENCES Subset(SubsetID));
This query creates a table Course_information with nine fields: Course_code which is a variable character of length 255 not null and the primary key, Course_Name is a variable character of length 255 not null, available online is of type yes/no not null, Campuses is a variable character of length 255, Sample_Study_Unit is a variable character of length 255 not null, Fee is of type currency of length 255 not null, Type is a variable character of length 255 not null and SubsetID is of type integer length 255 and the foreign key from table Subset (Coronel & Morris 2016).
Conversion in Microsoft Access
Creation of relationship between the tables in the database
The relationship between the Course table and the Subset table is one to many (Healy & Conorozzo 2013) which translates to one Course having many subset courses.
The relationship between the course subset and the Course_information is one to many which translates to one Subset course having many courses.
Referential integrity is also enforced for all the relationships between the table.
SQL query for data insertion
Query for insertion of data to table Course
INSERT INTO Course (CourseID, Course)VALUES (‘20000’, ‘Art and Design’);
Query for insertion of data into table Subset
INSERT INTO Subset (SubsetID, Subset_Name, CourseID)VALUES (‘767756’, ‘Graphic Design’, ‘20000’);
Query for insertion of data into table Course_information
INSERT INTO Course_information (Coursecode, CourseName, Availableonline, Campuses, Length, Sample_Study_Units, Fee, Type, SubsetID)VALUES (‘CPP41212’, ‘Certificate IV In Nathers Assessment’, ‘no’, ‘Chisholm at 311’, ‘Part time’, ‘Identify risk and apply risk management processes’, ‘11,636.00’, ‘certificate’, ‘234214’);
Data Manipulation SQL queries
Display all courses
SELECT * FROM Course_information;
Conversion in Microsoft Access
The output
Display all certificate courses
SELECT * FROM Course_information WHERE Type = ‘certificate’;
Conversion in Microsoft Access
The output
Display all diploma courses
SELECT * FROM Course_information WHERE Type = ‘diploma’;
Conversion in Microsoft Access
The output
Display names of course subsets
SELECT SubsetName FROM Course_Subset;
Conversion in Microsoft Access
The output.
Displaying a total number of courses
Count query according to (Chitkara et.al 2010).
SELECT COUNT(Course Name)FROM Course_information;
Conversion in Microsoft Access
The output
Display names of all course subsets and a number of courses in each subset
SELECT SubsetName FROM Course_subsetUNIONSELECT COUNT(Course Name) FROM Course_information;
The Union query is with reference to (Colossi et.al 2011).
Conversion in Microsoft Access
The output
Display course names and corresponding full fees.
SELECT Course_Name, Fee FROM Course_information;
Conversion in Microsoft
Output
Display course names and campus names where they are taught
SELECT CourseName, Campuses FROM Course_information;
Conversion in Microsoft Access
The output
Display part-time courses
SELECT * FROM Course_information
WHERE Length = ‘Part time’;
Conversion in Microsoft Access
Display on-line courses
SELECT * FROM Course_information
WHERE Availableonline = ‘yes’;
Conversion in Microsoft Access
The output
References
Coronel, C., & Morris, S. (2016). Database systems: design, implementation, & management. Cengage Learning.
Teorey, T. J., Lightstone, S. S., Nadeau, T., & Jagadish, H. V. (2011). Database modeling and design: logical design. Elsevier.
Chitkara, R. K., Banks, B. J., & Patel, A. R. (2010). U.S. Patent No. 7,743,069. Washington, DC: U.S. Patent and Trademark Office.
Demba, M. (2013). Algorithm for relational database normalization up to 3NF. International Journal of Database Management Systems, 5(3), 39.
Colossi, N. G., Dekimpe, D. M., Dere, J., & Sit, S. (2011). U.S. Patent No. 7,895,191. Washington, DC: U.S. Patent and Trademark Office.
Healy, J. J., & Conorozzo, D. R. (2013). U.S. Patent No. 8,538,935. Washington, DC: U.S. Patent and Trademark Office.
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 6 pages
PAY 4 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). Data And Information Management. Retrieved from https://myassignmenthelp.com/free-samples/smb4102-data-and-information-management/physical-design.html.
“Data And Information Management.” My Assignment Help, 2021, https://myassignmenthelp.com/free-samples/smb4102-data-and-information-management/physical-design.html.
My Assignment Help (2021) Data And Information Management [Online]. Available from: https://myassignmenthelp.com/free-samples/smb4102-data-and-information-management/physical-design.html[Accessed 18 December 2021].
My Assignment Help. ‘Data And Information Management’ (My Assignment Help, 2021)
My Assignment Help. Data And Information Management [Internet]. My Assignment Help. 2021 [cited 18 December 2021]. Available from: https://myassignmenthelp.com/free-samples/smb4102-data-and-information-management/physical-design.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:
Coming up with interesting research topics is a challenging task. If you are looking to save money for authentic assistance, MyAssignmenthelp.com is the place where you will get answers for topics like Bill Gates Leadership style, Starbucks social responsibility and more. Another daunting aspect, where our experts shine, is providing accurate citations. If you have no idea how to cite a research paper, do not hesitate to avail our service. To provide swift service, our writers frequently use referencing tools to ensure accurate citations on the chosen citation style. Even if you need assistance in the 11th hour, you know where to find us.
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