Cmis 311 Assignment 1

[Escolastico Hall]

Todayon February 23, 2022, the Chairman of the KJC, Albert Zogaj, together with the ICT / CMIS Project Manager, Fatmir Rexhepi and the Director of the Statistics Department, Besnik Ramosaj, visited today the Supreme Court of Kosovo, where they informed The President of the Supreme Court, Enver Peci regarding the planned activities regarding the implementation of the function of automatic case assignment via CMIS system in this court.

After the successful piloting ofthis function in the Appellate Court, KJC will begin the implementation of theautomatic case assignment via CMIS system in the Supreme Court, starting fromMarch 1, 2022.

The Chairman of the KJC, AlbertZogaj and the President of the Supreme Court, Enver Peci stressed theimportance of the automatic case assignment in courts, aiming to digitize thework and increase transparency in the Kosovo judiciary

CMIS does not publicly advertise for business or recruitment. New consultants are only considered on a referral basis from our other consultants, customers, and associates for our "referral bonus" program.

CMIS can negotiate a "rent-to-own" agreement prior to assignment start in the event of a mutual desire by both Customer and CMIS consultant to establish a permanent employment relationship. Otherwise, CMIS will normally permit customer solicitation of CMIS consultants for permanent employment at no cost after six months on assignment.

Introduction.

During the course of your work in designing the library application system you havedeveloped a plan for the logical flow of processing in the application. This logical flowis given in Figure #1 below.

This figure shows the number of options on the main switchboard form (main menu). Italso shows the options on the Transactions, Maintenance, and Print Reports forms and theassociated form and report objects that must be built to support the menu options.

Open the LAB03.MDB database. Manually create the Member table without using the TableWizard. Add fields, define data types, define field properties, set the primary key, andsave the table as described below. The Member table should have the following fields:

Exercise 2-Create Adult Table.

Use the Table Wizard to create the Adult table by copying pre-defined fields provided bythe Table Wizard. Open a New Table dialogue box and choose the Table Wizards button. Makesure the Business option button is selected, not the Personal option button.

Now modify the Adult table by changing the field names and data types selected by theWizard and remove all Caption Values for each field in the Field Properties column, if anyexist. The necessary changes are given in the table below.

and Field Size Description CustomerID Member_No Number (long integer) Number automatically assigned to new member BillingAddress Street Text (35) City City Text (20 State/Province State Text (2) PostalCode Zip Text (10) PhoneNumber Phone_No Text (20) DateJoined Expr_Date Date/Time Photograph Photo OLE Object

Use the Expression Builder to add an expression that calculates the expiration date forthe Expr_Date field by adding one year to the membership date. Do this by selecting theExpr_Date field. In the Field Properties section of the dialog box, select the DefaultValue property and choose the Build button. Double-click the Functions folder in theExpression Builder dialog box and click the Built-In Functions folder. Select Date/Timefrom the list of functions and then select the DateAdd option in the right box. Choose thePaste button. The function will appear as: DateAdd (

Exercise 3-Create Juvenile Table.

In this exercise create the Juvenile table by using the Field Builder. Select the NewTable option. From the toolbar, choose the Build button. In the Sample Tables box of theField Builder dialog box, select Customers. In the Sample Fields box, select CustomerID,and choose OK. Move to the next row and repeat the steps to create a second CustomerIDfield. Create a third field by selecting Mailing List in the Sample Tables box and selectBirthdate from the Sample Fields box for the Mailing List sample table. Change the fieldnames as follows:

Delete the Caption property in the Field Properties section of the Table dialog box forthe Member_No and Adult_Member_No fields. Also, delete the index for the Adult_Member_Nofield by setting the Indexed property to No. Set the Member_No field as the primary key(use the Edit menu). Save the table with the name Juvenile.

Exercise 4-Establish Relationships for Member, Adult, and Juvenile.

Before you establish any relationships, close all open tables. Choose Relationships fromthe Tools menu. Six of the Library database tables have already been defined withrelationships.

Highlight the Member.Member_No field (this is the Member_No field in the Members box).Click and drag the Member.Member_No field to the Adult.Member_No field and theRelationships dialog box appears. Note that when creating relationships, it is importantthat the direction of the line when clicking and dragging fields is consistent with thetype of relationship to be defined. For example, the first field that is clicked becomesthe One in a One-to-Many relationship.

Exercise 5-Establish Relationships Between the Member, Reservation, Loan, and LoanHistTables.

Create relationships between the Member table and the Reservation, Loan, and LoanHisttables. Determine the referential integrity requirements for each join. Save the changes.

Exercise 6-Adding and Editing Data.

In this lab you will add data to the tables created in Lab 3. Since you may have deviatedin minor ways from the directions provided in the exercises (not necessarily mistakes,simply deviations in naming fields, etc.), everyone will start this part of the laboratoryby using the LAB04.MDB file. Open the LAB04.MDB file.

Open the Title table. Add a new title number by entering 1 in the Title_No field. Addthe name of your favorite book to the Title field (your favorite book is Modern DatabaseManagement). Tab to the Author_Last field. Add the first author’s last name and firstname (McFadden, Fred). Try adding the same information to the next record in the table(you should get an error message). Take the necessary action to undo the duplicate record.Now add a second record with Title_No = 2. Make up your own data for the other fields.Keep the Title table open for use with the next exercise.

Exercise 7-Performing Cascading Updates and Deletes.

In this exercise, you will perform cascading updates and deletes. First, you will openseveral tables and display them on the screen at the same time. This is done by tiling thetables. After tiling, you will be able to view the effects of modifying data on bothtables.

In the Title table, change record number one’s Title_No from 1 to 105. Press the DOWNARROW key to see the change take effect. What happened? Now add the remaining 3records given below to the Item table.

Select record two in the Title table. From the Edit menu, choose delete. What message didyou receive? Why? Choose the Yes button. Look at the Item table. What happened? Why?Delete the remaining record in the Title table, close the tables, and maximize theDatabase window.

Importing Delimited Text Files.

You will import data to the Title table from the TITLE.TXT file. Preview the data in theTITLE.TXT file, which is a delimited text file. From Windows Explorer, open the TITLE.TXTfile. Note that the information contained in this file is delimited by commas. CloseWindows Explorer without modifying the file.

Return to Microsoft Access and select Get External Data from the File menu, then selectImport. The Import dialog box will appear. Select Text Files in the File Type section.Select the TITLE.TXT file and choose the Import button to open the Import Text Optionsdialog box. Select Delimited as the format, then click the Next button. Choose Comma asthe delimiter, then click the Next button. Indicate that you’d like to store thisdata in an existing table (Title), then click the Next button. Then click Finish.

Importing Undelimited Text Files.

Next you will import an undelimited text file and append data to the Item table. The Itemtable currently has no data. Use Windows Explorer to preview the ITEM.TXT file, which isan undelimited text file. Note that the information contained in this file is in columns.Close Windows Explorer without changing the file.

Return to Microsoft Access and select Get External Data from the File menu, then selectImport. Follow the same process you used to load text data into the Title table, exceptindicate that this data file is Fixed Width (rather than Delimited).

Importing a FoxPro File.

Next you will import data from a FoxPro file to a new table named COPY_FOX. You will notbe able to preview the file (unless you have a copy of the FoxPro RDBMS software). Thefile contains the ISBN, Copy_No, Title_No, and On_Loan fields and contains 450 records.Using the steps above as a guideline, import the FoxPro file (File type is MicrosoftFoxPro) named COPY_FOX.DBF. Access will create a table called COPY_FOX that contains 450rows. You may want to check the COPY_FOX table to insure that the records importedsatisfactorily.

Importing Data From a Microsoft Excel Spreadsheet.

Unless you have Microsoft Excel 7.0 or higher installed on your computer, you will not beable to preview the Microsoft Excel file. It contains the following columns: Employee,Last Name, First Name, Title, Birth Date, Hire Date, Address, City, and Region, and has 15rows of data.

Import the Microsoft Excel file named MEMDATA.XLS to a new table. After requesting anImport operation and a File type of Microsoft Excel, select the Show Worksheets option andclick on Next. Select the First Row Contains Field Names checkbox, then click Next. Importall the fields in the Excel dataset, and identify Employee ID as the primary key for thenew table. You may open the MEMDATA table to insure the 15 records importedsatisfactorily.

3a8082e126