115.107 Management Information Systems Assignment Report Contents Part 1 – ER Diagram 2 Part 2 – Tables and Keys 3 Part 3 – Queries 4 Part 4: Spreadsheet filters and pivot tables 7 List of Figures Figure 1 - ER diagram for event management system of hotel 2 Figure 2 - Query 1 QBE for staff allocation 4 Figure 3 - Query 1 output for staff allocation 4 Figure 4 - Query 2 QBE for scheduled events beginning of October 5 Figure 5 - Query 2 output for scheduled events beginning
Premium Spreadsheet Microsoft Excel Data modeling
INDEX 13. DBMS 14. SHOW TABLES‚ SHOW COLUMNS 15. SHOW INDEX 16. SHOW GRANTS 17. A rule for the data within the database to prevent incorrect additions. 18. During the CREATE TABLE command‚ but can be modified using the ADD PRIMARY KEY command 19. ADD FOREIGN KET Premere Products mysql> CREATE VIEW MAJOR_CUSTOMER (CUSTOMER_NUM‚ CUSTOMER_NAME‚ BALANCE‚ CREDIT_LIMIT‚ REP_NUM) AS SELECT CUSTOMER_NUM‚ CUSTOMER_NAME‚ BALANCE‚ CREDIT_LIMIT‚ REP_NUM FROM CUSTOMER WHERE
Premium SQL Database Foreign key
Database Database‚ it is a place use to store lots of data. It can be seen as a filing cabinet. And database management system (DBMS) is software that specificity designs for managing the data in database such as create‚ update or delete them. General is including security‚ retrieval and backup features. User also allows using the data to create a report or share data with multi-user. MS Access is a database management system design by Microsoft. It offers user four important objects they are:
Premium Data modeling Database normalization Foreign key
CSE4DWD – Data Warehouse Concepts and Design Assignment‚ Semester 1 2013 (30% of total assessment) Dimensional Modelling Business Case Due Date: 9.30am Friday‚ 17th May 2013 Objectives To create a Data Warehouse conceptual design using Star Schema Modelling To document all steps during the design process This is an INDIVIDUAL assignment. You are not permitted to work in a group when writing this assignment. Copying‚ Plagiarism: Plagiarism is the submission of somebody else’s work in a manner
Premium Foreign key SQL Data modeling
Final Case Study 1) SRS Problem Discription- DABBAWALAS in Mumbai INTRODUCTION: Everyone wants to eat freshly prepared homemade food for their lunch after working hard in our morning shift. But what if the home is too far to go and have lunch. There seems to be a solution for this‚ that is‚ to bring your tiffin box with you in the morning but what about the freshly preparedness. So in order to solve this problem there is a service available in the economic capital of India‚ Mumbai
Premium Foreign key SQL Dabbawala
to one relationships between entities are valid but rare. 6) Crow’s feet notation conveys more information about cardinality than arrow notation. 7) In a one-to-many relationship‚ each row on in the primary key table can be related to any number of rows in the foreign key or child table. 8) Cross relationships between parent and child tables can make data entry impossible. 9) Maximum cardinality refers to the maximum number of records allowed in a table. 10) Minimum cardinality
Premium Data modeling SQL Database
PROJECT DESCRIPTION Northwestern Swimming (NWS) manages athlete and coach data for swim teams with different locations in Washington. Athletes include developmental swimmers who are learning to swim and national-level athletes who have competed at the Olympic and world-championship levels. Julia Montoya is the General Chairperson of NWS and has just received approval from the Board of Directors to replace NWS’s manual system of managing data about athletes‚ coaches‚ and teams with a database. She
Premium Data modeling Field Foreign key
field is the primary key field. This does not have to be the case‚ so right click on the “key” and click on “Primary Key”. Input the field names: Click on the first field and type in “CustomerID”; Use right arrow and choose Number”. Use the arrow keys and go to the next row under Field Name: Last Name Text First Name Text Middle Initial Text Address Text City Text State Text Zip Text Right click on the square box next to the “CustomerID” field and choose “Primary Key”. Right click on
Premium Foreign key Field SQL
AvailableStatus varchar2(10) Not Null; PRIMARY KEY(RoomId); FOREIGN KEY (RoomTypeId) references ROOMTYPE (RoomTypeID); The cardinalities of the relationship between Room and RoomType shown in my ERD specifies that each Room is uniquely identified by a RoomId‚ which can be described by only one of all available RoomTypes. As such‚ each RoomId must be classified into a RoomType‚ and therefore‚ in accordance with entity integrity‚ both primary keys must not be null. Since RoomType will occur several
Premium Data modeling SQL Entity-relationship model
1. SELECT e.ename‚ e.deptno‚ d.dname‚ d.deptno FROM dept d LEFT OUTER JOIN emp e ON d.deptno = e.deptno ORDER BY d.deptno; SQL> SELECT e.ename‚ e.deptno‚ d.dname‚ d.deptno 2 FROM dept d 3 LEFT OUTER JOIN emp e 4 ON d.deptno = e.deptno 5 ORDER BY d.deptno; ENAME DEPTNO DNAME DEPTNO ---------- ---------- -------------- ---------- MILLER 10 ACCOUNTING 10 KING 10 ACCOUNTING
Premium SQL Foreign key Relational model